How to log SQL statements used by JOOQ generator maven plugin

Viewed 529

When executing the JOOQ generator maven plugin, only the fetch results are logged, not the SQL statement itself.

mvn generate-sources -Dorg.slf4j.simpleLogger.defaultLogLevel=DEBUG  -Dorg.slf4j.simpleLogger.level.org.jooq.tools.LoggerListener=DEBUG

I've tried with both, DEBUG and TRACE, TRACE only additionally logs every fetched record. Within my applications (Spring Boot, Quarkus), there is no such problem: with log level

org.jooq=DEBUG

I see SQL statements, bind values and the record fetched.

my environment:

Maven home: /usr/local/Cellar/maven/3.6.3_1/libexec
Java version: 13.0.2
jooq-codegen-maven 3.13.14
1 Answers
Related