Problem with mysql table name

mitrship · 07-25-2005, 12:53 AM

hi
i have a table name in mysql database named 'my pet'. I want to get the columns of the table using Jdbc.
but no columns are returned by getColumns.
Plz help me

ResultSet rsColumns = dataBaseMetaData.getColumns(this.getCatalog() , this.getSchema(), `my pet`,null);

thanking in advance
saurabh

chrism01 · 07-25-2005, 03:01 AM

Generally speaking I'd advise against spaces in table name, as you need to ensure that the name is properly quoted when it hits the mysql engine, and a lang like Java for example will prob strip quotes by default...
See http://dev.mysql.com/doc/mysql/en/legal-names.html

mitrship · 07-25-2005, 07:12 AM

thnks mate
but ours is a reporting tool for databases. The database and tables are at the clients, and we are not sure the table format. So the code should take all the possible names in consideration
ne ways thnks
mitrship