当前位置: 代码迷 >> SQL >> ibatis配置log4j输出sql话语等日志信息
  详细解决方案

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

热度:4   发布时间:2016-05-05 13:32:10.0
ibatis配置log4j输出sql语句等日志信息
配置的log4j.properties
#-------------------------------- #log4j.rootLogger=DEBUG, stdout, fileout#log4j.logger.test=info#log4j.logger.org.apache.jasper = DEBUG#log4j.logger.org.apache.catalina.startup.TldConfig = DEBUG#log4j.logger.org.apache.catalina.session.ManagerBase = DEBUGlog4j.logger.com.fiscal = DEBUGlog4j.logger.com.system = DEBUGlog4j.logger.com.ibatis = DEBUGlog4j.logger.com.ibatis.common.jdbc.SimpleDataSource = DEBUGlog4j.logger.com.ibatis.common.jdbc.ScriptRunner = DEBUGlog4j.logger.com.ibatis.sqlmap.engine.impl.SqlMapClientDelegate = DEBUGlog4j.logger.java.sql.Connection = DEBUG#log4j.logger.java.sql.Statement = DEBUG#log4j.logger.java.sql.PreparedStatement = DEBUGlog4j.logger.java.sql.ResultSet = DEBUGlog4j.appender.stdout=org.apache.log4j.ConsoleAppender log4j.appender.fileout=org.apache.log4j.RollingFileAppenderlog4j.appender.fileout.File=C:\\ibatis.log log4j.appender.fileout.MaxFileSize=10000KB log4j.appender.stdout.layout=org.apache.log4j.PatternLayout log4j.appender.stdout.layout.ConversionPattern=[%-5p] %d{yyyy-MM-dd HH:mm:ss} :%m%n log4j.appender.fileout.layout=org.apache.log4j.PatternLayout log4j.appender.fileout.layout.ConversionPattern=[%-5p]_%d{yyyy-MM-dd HH:mm:ss} :%m%n#log4j.appender.stdout.layout=org.apache.log4j.SimpleLayout # log4j.logger.org=info#-------------------------------- 


XML
<?xml version="1.0" encoding="UTF-8"?>   <!DOCTYPE log4j:configuration SYSTEM "log4j.dtd">     <log4j:configuration xmlns:log4j='http://jakarta.apache.org/log4j/'>         <appender class="org.apache.log4j.ConsoleAppender" name="console">           <layout class="org.apache.log4j.PatternLayout">               <param name="ConversionPattern"                  value="%d %-5p [%t] %-17c{2} (%13F:%L) %3x - %m%n" />               <!-- param name="ConversionPattern"                  value="=%d %-5p [%t] %-17c{2} (%13F:%L) %3x - %m%n" /-->           </layout>       </appender>       <appender class="org.apache.log4j.RollingFileAppender"          name="file">           <param name="File" value="MengBackup.log" />           <param name="MaxFileSize" value="100KB" />           <param name="MaxBackupIndex" value="2" />           <layout class="org.apache.log4j.PatternLayout">               <param name="ConversionPattern"                  value="=%d %-5p [%t] %-17c{2} (%13F:%L) %3x - %m%n" />           </layout>       </appender>              <logger name="com.ibatis">           <level value="debug" />       </logger>              <logger name="com.ibatis.common.jdbc.SimpleDataSource">           <level value="debug" />       </logger>              <logger name="com.ibatis.common.jdbc.ScriptRunner">           <level value="debug" />       </logger>              <logger name="com.ibatis.common.jdbc.SqlMapClientDelegate">           <level value="debug" />       </logger>              <logger name="java.sql.Connection">           <level value="debug" />       </logger>              <logger name="java.sql.Statement">           <level value="debug" />       </logger>              <logger name="java.sql.PreparedStatement">           <level value="debug" />       </logger>              <logger name="java.sql.ResultSet">           <level value="debug" />       </logger>              <root>           <priority value="DEBUG" />           <appender-ref ref="console" />           <appender-ref ref="file" />       </root>   </log4j:configuration>  
  相关解决方案