ibatis配置log4j输出sql语句等日志信息

log4j.logger.java.sql.Connection=DEBUG
log4j.logger.java.sql.Statement=DEBUG
log4j.logger.java.sql.PreparedStatement=DEBUG
log4j.logger.java.sql.ResultSet=DEBUG

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

 

 

<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 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>