<?xml version="1.0" encoding="UTF-8"?>
<configuration debug="true">
    <appender name="STDOUT" class="ch.qos.logback.core.ConsoleAppender">
        <!-- encoders are assigned the type
             ch.qos.logback.classic.encoder.PatternLayoutEncoder by default -->
        <encoder>
            <pattern>%d{HH:mm:ss.SSS} [%thread] %-5level %logger{36} - %msg%n</pattern>
        </encoder>
    </appender>

    <!-- log SQL (pre-execution) plus exceptions caused by SQL -->
    <!-- <logger name="jdbc.sqlonly" level="debug"/>-->

    <!-- log SQL with timing information, post execution -->
    <!-- <logger name="jdbc.sqltiming" level="debug"/> -->

    <!-- only use the two logs below to trace ALL JDBC information, NOTE: This can be very voluminous! -->

    <!-- log all jdbc calls except ResultSet calls -->
    <!-- <logger name="jdbc.audit" level="debug"/> -->

    <!-- log the jdbc ResultSet calls -->
    <!-- <logger name="jdbc.resultset" level="debug"/> -->

    <!-- log connection open/close events and dump of all open connection numbers -->
    <!-- <logger name="jdbc.connection" level="debug"/> -->

    <!-- this log is for internal debugging of log4jdbc, itself -->
    <!-- debug logging for log4jdbc itself -->
    <!-- <logger name="log4jdbc.debug" level="debug"/> -->

    <root level="info">
        <appender-ref ref="STDOUT" />
    </root>
</configuration>