This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
The moose likes JDBC 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 Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
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: 5812

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
It is sorta covered in the JavaRanch Style Guide.
subject: Fetching Current Schema value
Similar Threads
The matching wildcard is strict, but no declaration can be found for element 'context:annotation'
Getting all the Tables from schema
Castor mapping problem
need of schema export feature?
Data Trafer one DB to anothert