Originally posted by mitrship gupta:
i have a table name 'my pet' with space in between
haven't worked on mysql but still wonder if we can have table name with spaces.
now i want to get the column name for table using getcolumns
but the result set s not returning any columns
Result set rsColumns = dataBaseMetaData.getColumns(this.getCatalog() , this.getSchema(), `my pet`,null);
As far my experience with oracle I remember that database object are in upper case and case-senstive.
1. Try with
"MY PET" 2. Alternatively you can use
% for table name, It will list all tables, onwords you can check if table name is being picked by code.
Shailesh