log4j.properties 配置 ibatis SQL输出到文件

# settings
dir=/data/
fileName=paipai_dimcode.log
target=${dir}/log/${fileName}

# logger level: ERROR、WARN、INFO、DEBUG
# Set root logger level to DEBUG and add appenders
log4j.rootLogger=DEBUG, A1
#org.apache.log4j.PatternLayout
# A1 ConsoleAppender   lf5.LF5Appender
log4j.appender.A1=org.apache.log4j.ConsoleAppender
log4j.appender.A1.layout=org.apache.log4j.PatternLayout
log4j.appender.A1.layout.ConversionPattern=[%p] %d{yyyy-MM-dd HH:mm:ss,SSS} %t %x %c - %m%n

# A2 FileAppender
log4j.appender.A2=org.apache.log4j.DailyRollingFileAppender
log4j.appender.A2.File=${target}
log4j.appender.A2.File.DatePattern='.'yyyy-MM-dd
log4j.appender.A2.layout=org.apache.log4j.PatternLayout
log4j.appender.A2.layout.ConversionPattern=[%p] %T %t %c - %m%n

# set threshold
log4j.appender.A1.Threshold=DEBUG
log4j.appender.A2.Threshold=DEBUG

log4j.category.org.apache.http=WARN
log4j.category.org.springframework.web.client.RestTemplate=WARN
log4j.category.com.paipai.boss.bj.aggregation.util.HttpUtil=WARN

log4j.appender.stdout=org.apache.log4j.ConsoleAppender 
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout 
log4j.appender.stdout.layout.ConversionPattern=%d %p [%c] - %m%n 
 
 
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