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"
No comments:
Post a Comment