DatabaseMetaData and Oracle

[Rik Sweeney]

Hi,

I'm using the DatabaseMetaData to list all the tables available in a schema for Oracle. The problem is that I don't know what schema the user is connected to so I cannot pass in the schema name

e.g.

dmd.getTables(null, schemaString, "%", new String[]{"TABLE", "VIEW"});

The schemaString will be blank usually so I won't get any tables back, if I change this to

dmd.getTables(null, "%", "%", new String[]{"TABLE", "VIEW"});

then I get back *everything* which isn't too helpful to the user. Basically I'm wondering if there is a way to determine the default schema for the current connection?

Thanks

Richard

[Maximilian Xavier Stocker]

Did you try the method getCatalog of() of java.sql.Connection ?