This week's book giveaway is in the Clojure forum.
We're giving away four copies of Clojure in Action and have Amit Rathore and Francis Avila on-line!
See this thread for details.
Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

setting currentSchema for DB2 during runtime?

 
subbukumararaja chandrasekaran
Greenhorn
Posts: 17
  • 0
  • 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.
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic