i'm using jooq in a springboot-1.4.0 test project which advanced the jooq version number to 3.8.4.
in this test project, jooq generates java dsl for a db2 (expc) database using the generic org.jooq.util.jdbc.JDBCDatabase generator. all that worked fine up until springboot-1.3.6 which used jooq 3.7.4, but now the code generation fails with an error:
---
[ERROR] Could not load schemata
org.jooq.exception.DataAccessException: SQL [select 1 "one"]; DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=END-OF-STATEMENT;select 1 "one";<table_expr>, DRIVER=4.21.29
---
obviously, db2 does not accept "select 1" (without a table expression) as a well formed sql.
my questions:
- is that something that is circumvented in the commercial org.jooq.util.db2.DB2Database generator?
- i could not find any generation meta/config option to keep away the generic driver to submit this type of select, is that possible?
(at the moment, i can go on by replacing springboot jooq dependency with 3.7.4)