How to obtain the schema from a JDBC Connection ?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

apattin - 31 Mar 2006 02:41 GMT

Hi all,

Does anyone know how to get the schema name given a JDBC Connection
object? I see that I can do "toString" and pick the "User=" substring,
but smells of a hack. :)

Thanks,

Alejandrina

Reply to this Message

Knut Stolze - 03 Apr 2006 09:52 GMT

> Hi all,
>
> Does anyone know how to get the schema name given a JDBC Connection
> object? I see that I can do "toString" and pick the "User=" substring,
> but smells of a hack. :)

Query the CURRENT SCHEMA special register.

Signature

Knut Stolze
DB2 Information Integration Development
IBM Germany

Reply to this Message

apattin - 03 Apr 2006 17:06 GMT

Thanks! I can do that.

Alejandrina

Reply to this Message