derby和hsqldb中的表名和字段名转义问题

我有点问题 ORMLite package . 当我为一个表生成模式时,我认为转义所有实体名是一个好的实践。这将保护一些Java类或字段名不为SQL保留字:

CREATE TABLE "footable" ("stuff" VARCHAR(255))

I'm now adding "raw" query support so that ORMLite can help users perform their own queries. However, I find that with Derby and Hsqldb, the entity names cannot be used 没有 逃逸。例如,以下查询:

SELECT * FROM footable

generates the following errors:

Derby: ERROR 42X05: Table/View 'FOOTABLE' does not exist.
Hsqldb: Table not found in statement [select * from footable]

如果select表也被转义为 "footable" . The other databases supported by ORMLite work fine with or without the escaping: MySQL, Postgres, Microsoft SQL Server, H2, and Sqlite.

Are there better ways to escape reserved words in Derby and Hsqldb? Other ideas about how to do this in a portable manner?

谢谢。