It's not a secret anymore!
The moose likes JDBC and Relational Databases and the fly likes Fetching Current Schema value Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Java Interview Guide this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Fetching Current Schema value" Watch "Fetching Current Schema value" New topic

Fetching Current Schema value

Kishore Kumar
Ranch Hand

Joined: Oct 15, 2007
Posts: 71
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

Joined: May 14, 2008
Posts: 5852

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.

JBoss In Action
I agree. Here's the link:
subject: Fetching Current Schema value
It's not a secret anymore!