DriverManagerDataSource in java spring?

Hi,

Is there a property to designate the database schema name in the datasource config file?
Is it possible to name the schema  namehere in the datasource config file?
Right now ,the schema name is in the sql itself:

String sql="select * from schema_name.table_name";

Open in new window

<bean id="dataSource"
		class="org.springframework.jdbc.datasource.DriverManagerDataSource">
		<property name="driverClassName" value="${db2.jdbc.driverClassName}" />
		<property name="url" value="${db2.jdbc.url}" />
		<property name="username" value="${db2.jdbc.username}" />
		<property name="password" value="${db2.jdbc.password}" />
	</bean>

Open in new window

dkim18Asked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
dkim18Connect With a Mentor Author Commented:
I think I found it.

currentSchema=
0
All Courses

From novice to tech pro — start learning today.