how to log generated sql executed by JOOQ

Question

when executing JOOQ queries, what is the easiest way to log the generated SQL being executed to the log

Answer 1

As mentioned in a comment, this is documented in the manual: https://www.jooq.org/doc/latest/manual/sql-execution/logging/.

So you don't have to enable DEBUG logging on the root logger, you can do it only on the org.jooq.tools.LoggerListener logger, which does all the SQL logging in jOOQ.