log4j配置可以查看sql脚本_log4j日志能看sql语句吗-优快云博客

本文链接：https://blog.youkuaiyun.com/lujun12/article/details/49741381

该配置文件详细定义了log4j的日志级别和输出目标，包括控制台、日志文件和不同类型的日志文件，如error.log、audit.log和tracer.log。特别地，通过设置特定logger，如com.ibatis及其相关类，可以启用对iBATIS SQL脚本的调试日志输出。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

#############################################
#
# Log4J 配置文件
#
#############################################

# 定义缺省的日志级别和输出对象
log4j.appender.file.encoding=UTF-8
log4j.rootLogger=INFO, console, logfile, error
pafa.log.home=D:\\fwaLogs\\fwa
# 设定控制台输出模式
log4j.appender.console=org.apache.log4j.ConsoleAppender
log4j.appender.console.layout=org.apache.log4j.PatternLayout
log4j.appender.console.layout.ConversionPattern=[%d{MM/dd HH:mm:ss}] [%-3p] %c{1}: %X{MDCString} %m%n

#制定logger的名字，用于外部获取此logger
log4j.logger.errorLogger=ERROR,errorLogger
log4j.logger.auditLogger=INFO,auditLogger
log4j.logger.tracer=DEBUG,tracer

# 针对package定义日志级别
log4j.logger.org.apache=WARN
log4j.logger.com.paic.pafademo=DEBUG
log4j.logger.com.paic.fwa.rules.execution.biz.service=info,auditLogger

# 设定日志文件的输出模式
log4j.appender.logfile=org.apache.log4j.FileAppender
# ${pafa.log.home}通过参数-D指定，比如启动WebLogic时加入参数-Dpafa.log.home=c:/
log4j.appender.logfile.File=${pafa.log.home}/fwa/pafa.log
log4j.appender.logfile.layout=org.apache.log4j.PatternLayout
log4j.appender.logfile.layout.ConversionPattern=%x %d{MM/dd HH:mm:ss} [%-3p] %c{1}: %m%n
#log4j.appender.logfile=org.apache.log4j.RollingFileAppender
#log4j.appender.logfile.MaxFileSize=100KB
#log4j.appender.logfile.MaxBackupIndex=1

# 设定错误日志文件的输出模式
log4j.appender.errorLogger=org.apache.log4j.DailyRollingFileAppender
log4j.appender.errorLogger.File=${pafa.log.home}/fwa/error.log
log4j.appender.errorLogger.layout=org.apache.log4j.PatternLayout
log4j.appender.errorLogger.layout.ConversionPattern=%x %m %n

# 设定错误日志文件的输出模式
log4j.appender.error=org.apache.log4j.FileAppender
log4j.appender.error.File=${pafa.log.home}/fwa/error.
log4j.appender.error.layout=org.apache.log4j.PatternLayout
log4j.appender.error.layout.ConversionPattern=%x %d{yyyy/MM/dd HH:mm:ss} [%-3p] %c{1}: %m%n
log4j.appender.error.Threshold=ERROR

# 设定审计日志文件的输出模式
log4j.appender.auditLogger=org.apache.log4j.DailyRollingFileAppender
log4j.appender.auditLogger.File=${pafa.log.home}/fwa/audit.log
log4j.appender.auditLogger.layout=org.apache.log4j.PatternLayout
log4j.appender.auditLogger.layout.ConversionPattern=[%d{MM/dd HH:mm:ss}] [%-3p] %c{1}: %X{MDCString} %m%n

# 设定跟踪日志文件的输出模式
log4j.appender.tracer=org.apache.log4j.DailyRollingFileAppender
log4j.appender.tracer.File=${pafa.log.home}/fwa/tracer.log
log4j.appender.tracer.layout=org.apache.log4j.PatternLayout
log4j.appender.tracer.layout.ConversionPattern=%x %m %n

# 如果要查看iBATIS的SQL日志信息，确保有下面配置
#log4j.logger.com.ibatis=debug
#log4j.logger.java.sql.Connection=warn
#log4j.logger.java.sql.Statement=debug
#log4j.logger.java.sql.PreparedStatement=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
log4j.logger.java.sql.Connection=debug
log4j.logger.java.sql.Statement=debug
log4j.logger.java.sql.PreparedStatement=debug,stdout

# 访问日志Buffer
log4j.logger.com.paic.fwa.ac.web.util = info, accessLog
log4j.appender.accessLog=org.apache.log4j.DailyRollingFileAppender
log4j.appender.accessLog.File=${pafa.log.home}/fwa/accessRecord.log
log4j.appender.accessLog.layout=org.apache.log4j.PatternLayout
log4j.appender.accessLog.layout.ConversionPattern=%m %n