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

最新推荐文章于 2022-11-17 21:42:56 发布

最新推荐文章于 2022-11-17 21:42:56 发布 · 136 阅读

文章标签：

#log4j #iBATIS #SQL #Apache #JDBC

iBATIS 实战总结专栏收录该内容

3 篇文章

订阅专栏

本文详细介绍了Log4j的日志配置方法，包括根记录器设置、控制台输出配置、文件滚动策略及各种输出级别调试信息的设定。通过具体示例展示了如何针对不同组件进行精细的日志级别控制。

#log4j.rootLogger = [ level ] , appenderName, appenderName, ...
log4j.rootLogger = INFO, console, R
#level = INFO,all can be output

#console is set to be a ConsoleAppender
log4j.appender.console = org.apache.log4j.ConsoleAppender

#log4j.debug=true
#iBATIS log configure
#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

#console have four patterns
#org.apache.log4j.HTMLLayout
#org.apache.log4j.PatternLayout
#org.apache.log4j.SimpleLayout
#org.apache.log4j.TTCCLayout
log4j.appender.console.layout = org.apache.log4j.PatternLayout
#define the output type
log4j.appender.console.layout.ConversionPattern = %-d{yyyy-MM-dd HH:mm:ss} [%c]-[%p] %m%n

#file is set to output to a extra file
log4j.appender.R = org.apache.log4j.RollingFileAppender
#the absolute route of the log4j file
log4j.appender.R.File = ${webapp.root}/log/log.txt
#the size
log4j.appender.R.MaxFileSize = 500KB [Page]
#back up a file
log4j.appender.R.MaxBackupIndex = 1
log4j.appender.R.layout = org.apache.log4j.PatternLayout
log4j.appender.R.layout.ConversionPattern=%-d{yyyy-MM-dd HH:mm:ss} [%c]-[%p] - %m%n