mybatis 日志打印出sql

<?xml version='1.0' encoding='UTF-8' ?>
<!DOCTYPE log4j:configuration SYSTEM "log4j.dtd">

<log4j:configuration xmlns:log4j="http://jakarta.apache.org/log4j/">
   
    <appender name="CONSOLE" class="org.apache.log4j.ConsoleAppender">
        <layout class="org.apache.log4j.PatternLayout">
            <param name="ConversionPattern" value="[%7r] %6p - %30.30c - %m \n"/>
        </layout>
    </appender>

    <appender name="FILE-DEBUG" class="org.apache.log4j.FileAppender">
        <param name="Append" value="false"/>
        <param name="file" value="${wms-example.log.path}/wms-example-debug.log"/>
        <layout class="org.apache.log4j.PatternLayout">
            <param name="ConversionPattern" value="%d [%7r] %6p - %30.30c - %m \n"/>
        </layout>
    </appender>
   
    <appender name="FILE" class="org.apache.log4j.DailyRollingFileAppender">
        <param name="DatePattern" value="'.'yyyy-ww"/>
        <param name="Append" value="true"/>
        <param name="file" value="${wms-example.log.path}/wms-example.log"/>
        <layout class="org.apache.log4j.PatternLayout">
            <param name="ConversionPattern" value="%d [%7r] %6p - %30.30c - %m \n"/>
        </layout>
        <filter class="org.apache.log4j.varia.LevelRangeFilter">
            <param name="LevelMin" value="INFO"/>
            <!--<param name="LevelMax" value="FATAL "/>-->
        </filter>
    </appender>

    <appender name="FILE-AOP" class="org.apache.log4j.DailyRollingFileAppender">
        <param name="DatePattern" value="'.'yyyy-ww"/>
        <param name="file" value="${wms-example.log.path}/wms-example-aop.log"/>
        <layout class="org.apache.log4j.PatternLayout">
            <param name="ConversionPattern" value="%d [%7r] %6p - %30.30c - %m \n"/>
        </layout>
        <filter class="org.apache.log4j.varia.LevelRangeFilter">
            <param name="LevelMin" value="INFO"/>
            <!--<param name="LevelMax" value="FATAL "/>-->
        </filter>
    </appender>

    <appender name="FILE-SQL" class="org.apache.log4j.DailyRollingFileAppender">
        <param name="DatePattern" value="'.'yyyy-ww"/>
        <param name="file" value="${wms-example.log.path}/wms-example-sql.log"/>
        <layout class="org.apache.log4j.PatternLayout">
            <param name="ConversionPattern" value="%d [%7r] %6p - %30.30c - %m \n"/>
        </layout>
    </appender>

    <appender name="FILE-VELOCITY" class="org.apache.log4j.DailyRollingFileAppender">
        <param name="DatePattern" value="'.'yyyy-ww"/>
        <param name="file" value="${wms-example.log.path}/wms-example-velocity.log"/>
        <layout class="org.apache.log4j.PatternLayout">
            <param name="ConversionPattern" value="%d [%7r] %6p - %30.30c - %m \n"/>
        </layout>
    </appender>

    <category name="java.sql" additivity="true">   该句设为true就可以打印sql了
        <priority value="${wms-example.log.level}"/>
        <appender-ref ref="FILE-SQL"/>
        <appender-ref ref="FILE-DEBUG"/>
        <appender-ref ref="FILE"/>
    </category>

    <category name="org.apache.velocity" additivity="false">
        <priority value="${wms-example.log.level}"/>
        <appender-ref ref="FILE-VELOCITY"/>
        <appender-ref ref="FILE-DEBUG"/>
        <appender-ref ref="FILE"/>
    </category>

    <category name="com.jd.aop" additivity="false">
        <priority value="${wms-example.log.level}"/>
        <appender-ref ref="FILE-AOP"/>
        <appender-ref ref="FILE"/>
    </category>

    <category name="com.jd" additivity="true">
        <priority value="${wms-example.log.level}"/>
        <appender-ref ref="FILE"/>
    </category>

    <root>
        <priority value="${wms-example.log.level}"/>
        <appender-ref ref="CONSOLE"/>
        <appender-ref ref="FILE-DEBUG"/>
    </root>
</log4j:configuration>

评论

3 楼 mimang2007110 2012-02-26  

打印不出sql语句呀

2 楼 wcp88888888 2012-02-15  

Torero 写道

楼主, 你的myBatis版本是多少?
这个文件放在什么位置?

myBatis 版本是3.0.5
log4j.xml文件和spring-confing放在同一层目录

1 楼 Torero 2012-02-09  

楼主, 你的myBatis版本是多少?
这个文件放在什么位置?