Win a copy of Design for the Mind this week in the Design forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

setting currentSchema for DB2 during runtime?

 
subbukumararaja chandrasekaran
Greenhorn
Posts: 17
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic