Wednesday, May 16, 2012

Derby - DBVisualizer


When trying to do a simple query, with Apache Derby Database, on a table name written in CamelCase.

select *
from TBL.TmpEndpoints

I'm getting this error

 13:58:44  [SELECT - 0 row(s), 0.000 secs]  [Error Code: -1, SQL State: 42X05]  Table/View 'TBL.TMPENDPOINTS' does not exist.
... 1 statement(s) executed, 0 row(s) affected, exec/fetch time: 0.000/0.000 sec  [0 successful, 0 warnings, 1 errors]

In order to be able to query the table, I need to add double quotes to the table name. My query is :

select *
from TBL."TmpEndpoints"