Skip to Main Content
Forums

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

DatabaseMetaData getColumns() returns empty ResultSet for synonym over database link

rcalitaJul 15 2015 — edited Jul 17 2015

I have a synonym created over a database link and, when trying to retrieve the synonym's columns with the method getColumns(catalog, schemaPattern, tableNamePattern, columnNamePattern), the ResultSet is always empty.

I have tried using null as catalog, schemaPattern and columnNamePattern and setting the includeSynonyms property to true but had the same result.

I'm using oracle jdbc driver 11.2.0.1 and oracle 12c database.

Is this a driver limitation?

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 14 2015
Added on Jul 15 2015
#java-database-connectivity-jdbc
4 comments
1,494 views