This week's giveaway is in the EJB and other Java EE Technologies forum. We're giving away four copies of EJB 3 in Action and have Debu Panda, Reza Rahman, Ryan Cuprak, and Michael Remijan on-line! See this thread for details.
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)
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.