log4j ibatis

GodIT

浏览: 6408 次
性别:
来自: 湖南

最近访客更多访客>>

博主相关

博客

微博

相册

留言

关于我

文章分类

社区版块

存档分类

博客分类：

log4j

一个xml形式的配置：

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE log4j:configuration PUBLIC "-//APACHE//DTD LOG4J 1.2//EN" "log4j.dtd">
<log4j:configuration xmlns:log4j="http://jakarta.apache.org/log4j/" debug="false">

<appender name="CONSOLE" class="org.apache.log4j.ConsoleAppender">
   <layout class="org.apache.log4j.PatternLayout">
    <param name="ConversionPattern" value="%d{yyy-MM-dd HH:mm:ss} - %m%n" />
   </layout>
</appender>

<appender name="DEBUG" class="org.apache.log4j.DailyRollingFileAppender">
   <param name="File" value="D:/logs/debuglogs/debug.log" />
   <param name="Append" value="true" />
   <param name="DatePattern" value="'.'yyyy-MM-dd'.log'" />
   <layout class="org.apache.log4j.PatternLayout">
    <param name="ConversionPattern" value="%d{yyy-MM-dd HH:mm:ss} - %m%n" />
   </layout>
   <filter class="org.apache.log4j.varia.LevelRangeFilter">
    <param name="LevelMin" value="DEBUG" />
    <param name="LevelMax" value="DEBUG" />
   </filter>
</appender>

<appender name="INFO" class="org.apache.log4j.DailyRollingFileAppender">
   <param name="File" value="D:/logs/infologs/info.log" />
   <param name="Append" value="true" />
   <param name="DatePattern" value="'.'yyyy-MM-dd'.log'" />
   <layout class="org.apache.log4j.PatternLayout">
    <param name="ConversionPattern" value="%d{yyy-MM-dd HH:mm:ss} - %m%n" />
   </layout>
   <filter class="org.apache.log4j.varia.LevelRangeFilter">
    <param name="LevelMin" value="INFO" />
    <param name="LevelMax" value="INFO" />
   </filter>
</appender>

<appender name="WARN" class="org.apache.log4j.DailyRollingFileAppender">
   <param name="File" value="D:/logs/warnlogs/warn.log" />
   <param name="Append" value="true" />
   <param name="DatePattern" value="'.'yyyy-MM-dd'.log'" />
   <layout class="org.apache.log4j.PatternLayout">
    <param name="ConversionPattern" value="%d{yyy-MM-dd HH:mm:ss} - %m%n" />
   </layout>
   <filter class="org.apache.log4j.varia.LevelRangeFilter">
    <param name="LevelMin" value="WARN" />
    <param name="LevelMax" value="WARN" />
   </filter>
</appender>

<appender name="ERROR" class="org.apache.log4j.DailyRollingFileAppender">
   <param name="File" value="D:/logs/errorlogs/error.log" />
   <param name="Append" value="true" />
   <param name="DatePattern" value="'.'yyyy-MM-dd'.log'" />
   <layout class="org.apache.log4j.PatternLayout">
    <param name="ConversionPattern" value="%d{yyy-MM-dd HH:mm:ss} - %m%n" />
   </layout>
   <filter class="org.apache.log4j.varia.LevelRangeFilter">
    <param name="LevelMin" value="ERROR" />
    <param name="LevelMax" value="ERROR" />
   </filter>
</appender>

  <logger name="com.ibatis" additivity="true"> 
  <level value="DEBUG" /> 
 </logger> 
 <logger name="java.sql.Connection" additivity="true"> 
  <level value="DEBUG" /> 
 </logger> 
 <logger name="java.sql.Statement" additivity="true"> 
  <level value="DEBUG" /> 
 </logger> 
 <logger name="java.sql.PreparedStatement" additivity="true"> 
  <level value="DEBUG" /> 
 </logger> 
 <logger name="java.sql.ResultSet" additivity="true"> 
  <level value="DEBUG" /> 
 </logger> 



<category name="org.apache">
   <priority value="WARN" />
   <appender-ref ref="WARN" />
</category>

<category name="com.netsdar.song">
   <priority value="DEBUG" />
   <appender-ref ref="DEBUG" />
</category>

<category name="com.netsdar">
   <priority value="ERROR" />
   <appender-ref ref="ERROR" />
</category>

<root>
   <level value="INFO" /><!--
   <level value="DEBUG" />
   --><!--priority value="error" />
     appender-ref ref="INFO" /-->
   <appender-ref ref="WARN" />
   <appender-ref ref="ERROR" />
   <appender-ref ref="DEBUG" />
   <appender-ref ref="CONSOLE" />
</root>

</log4j:configuration>

在ibatis中使他在console中print sql 语句：

log4j.logger.com.ibatis=DEBUG
log4j.logger.com.ibatis.common.jdbc.SimpleDataSource=DEBUG
log4j.logger.com.ibatis.common.jdbc.ScriptRunner=DEBUG
log4j.logger.com.ibatis.sqlmap.engine.impl.SqlMapClientDelegate=DEBUG
log4j.logger.java.sql.Connection=DEBUG
log4j.logger.java.sql.Statement=DEBUG
log4j.logger.java.sql.PreparedStatement=DEBUG

分享到：