Log4J显示ibatis的执行日志

首先配置appender

 

<appender name="IBatis" class="org.apache.log4j.ConsoleAppender">
		  <layout class="org.apache.log4j.PatternLayout">
		   <param name="ConversionPattern"
		    value="%-4r [%t] %-5p %c %x - %m%n" />
		  </layout>
		  <filter class="org.apache.log4j.varia.LevelRangeFilter">
		   <param name="LevelMin" value="DEBUG" />
		   <param name="LevelMax" value="DEBUG" />
		  </filter>
		 </appender>

 其次配置logger

 <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" />
		  <appender-ref ref="IBatis" />
		 </logger>
		 
		 <logger name="java.sql.ResultSet" additivity="true">
		  <level value="DEBUG" />
		  <appender-ref ref="IBatis" />
		 </logger>

 一个都不能少~

评论

1 楼 azheng270 2012-12-02  

mybatis呢?
sql输出是可以直接复制出来执行的 , 还是sql和参数分离的?