Hi Manuel, Thank you very much for your message.
As of jOOQ 3.11 the Settings object has two new properties "executeUpdateWithoutWhere" and "executeDeleteWithoutWhere" which can be used to control the logging of such statements. They can both be set to one of the values IGNORE, LOG_DEBUG, LOG_INFO, LOG_WARN, or THROW. LOG_DEBUG is the default for both, which explains the log message you are seeing. Apart from that these messages are not logged any differently from other log messages in jOOQ. So if the logging to the console (stdout?) is unexpected, there could be something wrong with your logging configuration. I hope this helps. Please let us know if you have any other questions. Knut On Tue, Jul 30, 2019 at 10:05 PM Manuel Rossetti <[email protected]> wrote: > I am in the process of upgrading to Java 11 and going from jooq 3.10.4 to > 3.11.11. > > I normally log the jooq messages into their own log files using slf4j and > logback. > > I do have a delete without where clause implemented in my project. In my > pre-java 11 work (java 8 with jooq 3.10.4), I use something like: > > getDSLContext().settings().withExecuteLogging(false); > > > To turn of the logging. I don't get any delete without were clause in my > logs. The delete from table logging is captured, when I do turn on the > logging. > > However, when running under java 11 with 3.11.11, I get log messages to > the console like below. I would like to know where they are coming from > and a solution to get them into the normal jooq log flow. > > Thanks! > > 2019-07-29 17:06:47,983 3272 [main] DEBUG org.jooq.impl.AbstractQuery - > DELETE without WHERE : A statement is executed without WHERE clause > 2019-07-29 17:06:48,015 3304 [main] DEBUG org.jooq.impl.AbstractQuery - > DELETE without WHERE : A statement is executed without WHERE clause > 2019-07-29 17:06:48,020 3309 [main] DEBUG org.jooq.impl.AbstractQuery - > DELETE without WHERE : A statement is executed without WHERE clause > 2019-07-29 17:06:48,033 3322 [main] DEBUG org.jooq.impl.AbstractQuery - > DELETE without WHERE : A statement is executed without WHERE clause > 2019-07-29 17:06:48,044 3333 [main] DEBUG org.jooq.impl.AbstractQuery - > DELETE without WHERE : A statement is executed without WHERE clause > 2019-07-29 17:06:48,063 3352 [main] DEBUG org.jooq.impl.AbstractQuery - > DELETE without WHERE : A statement is executed without WHERE clause > > -- > 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]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/jooq-user/3ff5216e-549d-418a-a7cf-46ca45fcdb36%40googlegroups.com > <https://groups.google.com/d/msgid/jooq-user/3ff5216e-549d-418a-a7cf-46ca45fcdb36%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- 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]. To view this discussion on the web visit https://groups.google.com/d/msgid/jooq-user/CAFx%3DKgc-NhS1X_oX-MYEVWFTyU5enVJucDyZe-DBHe_UWXGcyQ%40mail.gmail.com.
