当前位置: 代码迷 >> SQL >> mybatis 日记打印出sql
  详细解决方案

mybatis 日记打印出sql

热度:77   发布时间:2016-05-05 13:39:19.0
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>

1 楼 Torero 2012-02-09  
楼主, 你的myBatis版本是多少?
这个文件放在什么位置?
2 楼 wcp88888888 2012-02-15  
Torero 写道
楼主, 你的myBatis版本是多少?
这个文件放在什么位置?

myBatis 版本是3.0.5
log4j.xml文件和spring-confing放在同一层目录
3 楼 mimang2007110 2012-02-26  
打印不出sql语句呀
  相关解决方案