Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Fetching Current Schema value

 
Kishore Kumar
Ranch Hand
Posts: 71
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I am using WAS 6 with db2.

I've used currentSchema i.e deafault schema property in Datasource for JDBC connectiion pooling. Is there any way to fetch this value from java. I need to send this value to VB from java.
 
Peter Johnson
author
Bartender
Posts: 5856
7
Android Eclipse IDE Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
If you do a query, you can get the schema name from java.sql.ResultSetMetaData.getSchemaName(). If your query did not contain an explicit schema name, this should be the default schema name.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic