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!

Retrieving column metadata over database link

527123Aug 8 2006 — edited Aug 29 2006

Hi,

when querying for column metadata with con.getMetaData().getColumns() this works fine for tables and synonyms on local tables. But it doesn't work neither for remote tables (over a database link) specified as "table@dblink" nor for synonyms for such tables. An empty result set is returned all the time.

I'm using the latest 10.2.0.1.0 java-only jdbc driver with a 9.2.0.4.0 database. Is there anything known about limitations in the jdbc driver relating to retrieving metadata for tables over database links?

Regards,
Ralf

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 26 2006

Added on Aug 8 2006

#java-database-connectivity-jdbc

7 comments

3,616 views