I have a problem with logging as it is described here.
My code:
Class.forName("com.mysql.jdbc.Driver").newInstance();
conn = DriverManager.getConnection(url, userName, password);
Settings settings = new Settings();
settings.withRenderFormatted(true);
settings.setExecuteLogging(true);
DSLContext dslContext = DSL.using(conn, SQLDialect.MYSQL, settings);
dslContext.select(USER.USERID, USER.IMIE, USER.NAZWISKO).from(USER).orderBy(USER.USERID).limit(1, 2).fetch();
And I have nothing in my console
This is my log4j.xml:
<?xml version="1.0" encoding="UTF-8"?>
<log4j:configuration>
<appender name="stdout" class="org.apache.log4j.ConsoleAppender">
<layout class="org.apache.log4j.PatternLayout">
<param name="ConversionPattern" value="%m%n" />
</layout>
</appender>
<root>
<priority value="debug" />
<appender-ref ref="stdout" />
</root>
</log4j:configuration>
and my IVY dependencies:
<dependency org="org.jooq" name="jooq" rev="3.2.2"/>
<dependency org="org.jooq" name="jooq-codegen" rev="3.2.2"/>
<dependency org="org.jooq" name="jooq-meta" rev="3.2.2"/>
<dependency org="mysql" name="mysql-connector-java" rev="5.1.26"/>
<dependency org="log4j" name="log4j" rev="1.2.16"/>
<dependency org="org.slf4j" name="slf4j-simple" rev="1.7.4"/>
As far as I could read the code (cf org.jooq.tools.JooqLogger
), Jooq
is guessing the logger to use by trying to load each ones until it succeeds. Considering you ivy.xml, you have both Log4j
and slf4j-simple
. And Jooq is trying slf4j
first. So Log4j
is not used.
So you need to remove slf4j-simple
from your dependencies.
If you do require a slf4j logger,
try slf4j-log4j12
, which redirects slf4j
logs into log4j.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With