Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Cloud/Virtualization forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Oracle-jdbc

 
Neha Yadav
Greenhorn
Posts: 5
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Regards
 
Barbara Norway
Ranch Hand
Posts: 150
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic