This week's giveaway is in the Spring forum.
We're giving away four copies of REST with Spring (video course) and have Eugen Paraschiv on-line!
See this thread for details.
The moose likes JDBC and Relational Databases and the fly likes Oracle-jdbc Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of REST with Spring (video course) this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Oracle-jdbc " Watch "Oracle-jdbc " New topic


Neha Yadav

Joined: Aug 26, 2004
Posts: 5
Hi All

I have a problem with accessing the meta-data of the table created by me as 'scott' user.
when i do a 'getColumns' for the Database meta-data, giving table name as the one i created , i get a null ResultSet.

But i can all the System/Oracle-specific cols listed through getColumns, excluding those of the tables created by me.

It is possible that 'Database.getMetaData' doesnot recognise the tables created by me from SQLPlus.(I have done a commit)

Please help, im stuck

Thank you
Barbara Norway
Ranch Hand

Joined: Sep 30, 2003
Posts: 150
Just a wild guess here but is there a chance you need to append scott. (schema name) to the name of the table(s)? This ould apply if you're using another userid that does not have privileges in the scott. schema.

For example scott.mytable instead of just mytable

I agree. Here's the link:
subject: Oracle-jdbc
It's not a secret anymore!