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!

Metadata not support synonym

pedro_rikyNov 21 2013 — edited Oct 15 2014

Hi all

    i try to get meta data from my tables:

     [code]

          DatabaseMetaData databaseMetaData = conn.getMetaData();

          databaseMetaData.storesUpperCaseIdentifiers();

          ResultSet columns = databaseMetaData.getColumns(null, null, "myTable", null);

     [/code]

If i pass myTable like synonym i get 0 rows, but if i pass like table name i get some rows.So is possible that oracle doesn't support synonym on metadata?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 19 2013
Added on Nov 21 2013
#database-connectivity-discussions
2 comments
706 views