JDBC API - To get the current catalog/schema of the database

697330

Is there any JDBC API to get the current catalog/schema of the database. The solution needs to be generic so that it can be applied across databases..

For example,
- for Oracle i need to get the current schema of the session
- for SQL Server i need to get the current catalog and schema for the session
....
...

castorp

shankar wrote:
Is there any JDBC API to get the current catalog/schema of the database.

No

Joe Weinstein-Oracle

Try Connection.getSchema(), getCatalog()

castorp

[email protected] wrote:
Try Connection.getSchema(), getCatalog()

There is no Connection.getSchema() - at least not in Java6/JDBC4
http://download.oracle.com/docs/cd/E17409_01/javase/6/docs/api/java/sql/Connection.html

And I'm not sure if getCatalog() works correctly in SQL Server when you have changed the current database with "USE ..."

Joe Weinstein-Oracle

FOR SQLSServer, setCatalog(...) is the same as executing "USE ...".

Sorry, my mistake on the getSchema(). I was thinking of
DatabaseMetaData.getUserName() (which should be a connection method IMHO).
Try that.

697330

Thanks castorp and Joe...

I think the solution doesn't seem to solve the problem that i have...

The problem statement is...

I have retrieved the whole set of tables from the database(can be oracle,mysql,sqlsever,db2.. etc).. The tables are represented along with catalog/schema or both based on the support provided by the database.. I need to strip of the catalog/schema from the tables which are related to the current user/schema/catalog.. All other tables(related to other schemas) should remain the same... For this i need to get the current schema/catalog for the connected database...

So for example,
- for Oracle i need to get the current schema of the session
- for SQL Server i need to get the current catalog and schema for the session

MatthiasGaiser

Just in case, someone reads this old post in looking for a solution. This post helped me: How to find currentSchema from JDBC application - DB2 Database

Execute "values current schema" SQL statement with the connection. The resultset will have the current schema.

Best wishes,

Matthias.

PhHein

Thanks Matthias, but please don't revive long dead threads.

Mod: locking this zombie.