Skip to Main Content

Oracle Database Discussions

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!

Viewing Public Synonyms thru JDBC

274340Jan 12 2006 — edited Jan 12 2006
Hi Guys,
Didn't find any java specifc forum so thought to post it here. What I have done is created a public synonym for a table, so it resides under PUBLIC.My question is that I don't see the PUBLIC schema being listed when I do DatabaseMetaData.getSchemas(). I have even granted PUBLIC to the username and still doesn't work. I think PUBLIC is not really a SCHEMA, it is a User group. So how do I view public synonyms in the java code? Is there any other method other than getSchemas which will show PUBLIC or any other property to be set? Btw, if I do getTables(null, "PUBLIC", null, null), it works. But I would rather get the name PUBLIC from the DatabaseMetaData instead of coding the word PUBLIC explictly there.

Thanks!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 9 2006
Added on Jan 12 2006
3 comments
315 views