Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

DatabaseMetaData.getTables() and DBMS with no schema support

843854Nov 15 2003 — edited Nov 16 2003

Hi,

I'm developing JDBC driver for Firebird DBMS (http://firebirdsql.org), open-source clone of Borland's InterBase. I have problem in understanding what to do in methods where catalog and schema are passed as parameters. Firebird does not have such concepts and each user sees all tables, and table names do not include name of the user who created it (unlike Oracle).

My DatabaseMetaData.getSchemas() method returns empty result set - no schemas available. However, JDBC CTS suite (v1.3.1) ignores this and calls DatabaseMetaData.getTables(String, String, String, String) method passing null as catalog (ok) and current user name as schema.

What should driver do in this case? Currently it throws exception saying that catalogs and schemas are not supported by Firebird, but this causes JDBC CTS tests to fail. Should I simply ignore any value passed as schema? Is this correct?

Thanks a lot in advance,
Roman Rokytskyy

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 14 2003

Added on Nov 15 2003

#java-database-connectivity-jdbc

2 comments

848 views