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)



-- 
You received this message because you are subscribed to the Google Groups "jOOQ 
User Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
For more options, visit https://groups.google.com/d/optout.

Reply via email to