Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

JOOQ Log4j - missing console output

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"/>
like image 549
Przemek Lewandowski Avatar asked Oct 18 '25 04:10

Przemek Lewandowski


1 Answers

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.

like image 156
Nicolas Lalevée Avatar answered Oct 20 '25 16:10

Nicolas Lalevée



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!