"Current" schema and Oracle Connection

Hi all !

Is it possible to get the current schema name for an Oracle connection ?

We don't want to execute a query but we want to use the DatabaseMetadata if it is possible... or another stuff like this...

Moreover, something like createStatement().executeQuery("SELECT 'FOO' FROM DUAL").getMetaData().getSchemaName(1)

returns an empty string.

This Oracle connection is retrieved from a JNDI resource so that its schema is not known... And the schema name is needed to use another tool.

Thanks you very much in advance for your help,

St閜hane.

[620 byte] By [crasniera] at [2007-11-27 5:55:57]