HSQLDB和JOOQ代码生成

Question

我试图使用JOOQ连接到HSQLDB，但我失败了，这里是错误消息：

INFO: Initialising properties  : /codegen.xml
2014-02-09T09:55:19.542+0100  SEVERE  Error while fetching check constraints
org.jooq.exception.DataAccessException: SQL [select "tc"."TABLE_SCHEMA", "tc"."TABLE_NAME", "cc"."CONSTRAINT_NAME", "cc"."CHECK_CLAUSE" from "INFORMATION_SCHEMA"."TABLE_CONSTRAINTS" as "tc" join "INFORMATION_SCHEMA"."CHECK_CONSTRAINTS" as "cc" using( "CONSTRAINT_CATALOG", "CONSTRAINT_SCHEMA", "CONSTRAINT_NAME") where "tc"."TABLE_SCHEMA" in (cast(? as varchar(128)))]; user lacks privilege or object not found: cc.CONSTRAINT_NAME

此查询也会在HSQLDB Manager上失败（与JOOQ代码生成器的错误相同）：

select "tc"."TABLE_SCHEMA", "tc"."TABLE_NAME", "cc"."CHECK_CLAUSE" , "cc"."CONSTRAINT_NAME"
from "INFORMATION_SCHEMA"."TABLE_CONSTRAINTS" as "tc" 
    join "INFORMATION_SCHEMA"."CHECK_CONSTRAINTS" as "cc" 
    using( "CONSTRAINT_CATALOG", "CONSTRAINT_SCHEMA", "CONSTRAINT_NAME") 

此查询工作正常：

select "tc"."TABLE_SCHEMA", "tc"."TABLE_NAME", "cc"."CHECK_CLAUSE" , "CONSTRAINT_NAME"
from "INFORMATION_SCHEMA"."TABLE_CONSTRAINTS" as "tc" 
    join "INFORMATION_SCHEMA"."CHECK_CONSTRAINTS" as "cc" 
    using( "CONSTRAINT_CATALOG", "CONSTRAINT_SCHEMA", "CONSTRAINT_NAME") 

我认为问题出在“cc”限定符上（在查询返回的“CONSTRAINT_NAME”字段上），这是HSQLDB错误吗？

我正在使用：

• HSQLDB 2.3.1
• JOOQ 3.2.3

谢谢Ciccio

Answer 1

这是jooq3.2中的一个bug。我为此创建了一个问题：#3019。这是一个与jOOQ当前对JOIN.的解释有关的更一般性错误的副作用。。使用和of自然连接：#2808。

不过，这个错误应该只是表面上的，不会对代码生成产生任何影响。