I have a table that uses reserved word as name , so it is quoted like :
create table "ORDER"(a int ) ;
All SQL queries seems to expect it as quoted name , except Database
Metadata getColumns(..).
DatabaseMetaData dmd = conn.getMetaData();
ResultSet rs = dmd.getColumns(null, null , "\"ORDER\"" , null) ;
does not return any column information , where as
ResultSet rs = dmd.getColumns(null, null , "ORDER"" , null) ;
retunns the "ORDER" table columns Information.
I am wondering what is the correct usage here , i.e does metadata
calls suppose to
expect quoted tables names like SQL or the one without quotes ?
Thanks
-suresht
