aspose file tools*
The moose likes JDBC and the fly likes setting currentSchema for DB2 during runtime? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "setting currentSchema for DB2 during runtime?" Watch "setting currentSchema for DB2 during runtime?" New topic
Author

setting currentSchema for DB2 during runtime?

subbukumararaja chandrasekaran
Greenhorn

Joined: Sep 24, 2010
Posts: 17
Hi
I am using the JDBC connection pooling for my application.
My resource definition in context.xml is as below;
<Resource name="myJDBC" auth="Container" type="javax.sql.DataSource"
maxActive="30"
maxIdle="30"
maxWait="10000"
username="User_Name" password="passWord"
driverClassName="com.ibm.db2.jcc.DB2Driver"
url="jdbc:db2://localhost:2552/myDB:currentSchema=mySchema;"/>

In this one, i want to set the currentSchema from the code. Could somebody tell me how to set the currentSchema value during runtime?

Thanks.
 
 
subject: setting currentSchema for DB2 during runtime?