ibatls打印sql语句
上一篇 /
下一篇 2012-03-26 20:11:04
/ 个人分类:监控sql
为了方便跟踪调试,利用log4j把ibatis执行的sql语句,参数,执行结果打印出来是一个不错的做法,只要在在配置文件log4j.properties中加入以下代码就可以了:
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, fileout
log4j.logger.java.sql.ResultSet = DEBUG
log4j.xml
<!--监控sql-->
<appendername="pic-sql"
class="com.alibaba.common.logging.spi.log4j.FileAppender">
<paramname="file"value="${picturecenter.loggingRoot}/pic-sql.log"/>
<paramname="Append"value="true"/>
<paramname="DatePattern"value="'.'yyyy-MM-dd"/>
<layoutclass="org.apache.log4j.PatternLayout">
<paramname="ConversionPattern"value="%d %-5p [%c] %m%n"/>
</layout>
</appender>
<loggername="com.ibatis">
<levelvalue="DEBUG"/>
<appender-refref="pic-sql"/>
</logger>
<loggername="com.ibatis.common.jdbc.SimpleDataSource">
<levelvalue="DEBUG"/>
<appender-refref="pic-sql"/>
</logger>
<loggername="com.ibatis.common.jdbc.ScriptRunner">
<levelvalue="DEBUG"/>
<appender-refref="pic-sql"/>
</logger>
<loggername="com.ibatis.sqlmap.engine.impl.SqlMapClientDelegate">
<levelvalue="DEBUG"/>
<appender-refref="pic-sql"/>
</logger>
<loggername="java.sql.Connection">
<levelvalue="DEBUG"/>
<appender-refref="pic-sql"/>
</logger>
<loggername="java.sql.PreparedStatement">
<levelvalue="DEBUG"/>
<appender-refref="pic-sql"/>
</logger>
收藏
举报
TAG: