[Spring] log4j.properties 설정 바꾸기

기존

log4j.rootLogger=DEBUG,console,rolling

log4j.logger= DEBUG
log4j.logger.java.sql= DEBUG

log4j.logger.jdbc.sqltiming=DEBUG,stdout
log4j.additivity.jdbc.sqltiming=false

log4j.logger.jdbc.sqlonly=ERROR,sql
log4j.additivity.jdbc.sqlonly=false

log4j.logger.jdbc.audit=ERROR,jdbc
log4j.additivity.jdbc.audit=false

log4j.logger.jdbc.resultset=ERROR,jdbc
log4j.additivity.jdbc.resultset=false

log4j.logger.org.springframework=DEBUG
log4j.logger.org.springframework.transaction=DEBUG

log4j.logger.com.ibatis=DEBUG
log4j.logger.com.ibatis.common.jdbc.SimpleDataSource=ERROR
log4j.logger.com.ibatis.common.jdbc.ScriptRunner=ERROR
log4j.logger.com.ibatis.sqlmap.engine.impl.SqlMapClientDelegate=ERROR

log4j.logger.java.sql.Connection=ERROR
log4j.logger.java.sql.Statement=ERROR
log4j.logger.java.sql.PrepareStatement=ERROR
log4j.logger.java.sql.ResultSet=ERROR

log4j.appender.rolling=org.apache.log4j.DailyRollingFileAppender
log4j.appender.rolling.File=../logs/dr.log
log4j.appender.rolling.Append=true
log4j.appender.rolling.DatePattern= '.'yyyy-MM-dd
log4j.appender.rolling.layout=org.apache.log4j.PatternLayout
log4j.appender.rolling.ConversionPattern=[%d] %-5p - %m%n

log4j.appender.console=org.apache.log4j.ConsoleAppender
log4j.appender.console.layout=org.apache.log4j.PatternLayout
log4j.appender.console.layout.ConversionPattern=%5p (%F[%M]:%L) [%d] - %m%n

log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
log4j.appender.stdout.layout.ConversionPattern=%5p (%F[%M]:%L) [%d] - %m%n

log4j.appender.jdbc=org.apache.log4j.ConsoleAppender
log4j.appender.jdbc.layout=org.apache.log4j.PatternLayout
log4j.appender.jdbc.layout.ConversionPattern=%5p (%F[%M]:%L) [%d] - %m%n

log4j.appender.sql=org.apache.log4j.ConsoleAppender
log4j.appender.sql.layout=org.apache.log4j.PatternLayout
log4j.appender.sql.layout.ConversionPattern=%5p (%F[%M]:%L) [%d] - %m%n

불편한 점

• 콘솔창에 실행 쿼리가 2개씩 중복 출력됨
• 설정을 보니 jdbc.sqltiming만 따로 지정했고,
  jdbc.sqlonly가 루트(DEBUG)로 살아 있어서 그런 거였음

변경

log4j.rootLogger=DEBUG,console,rolling

log4j.logger.jdbc.sqltiming=DEBUG,console
log4j.additivity.jdbc.sqltiming=false

log4j.logger.jdbc.sqlonly= ERROR
log4j.additivity.jdbc.sqlonly=false

log4j.logger.jdbc.audit=ERROR
log4j.additivity.jdbc.audit=false

log4j.logger.jdbc.resultset=ERROR
log4j.additivity.jdbc.resultset=false

log4j.logger.org.springframework=ERROR
log4j.logger.org.springframework.transaction=ERROR

log4j.logger.com.ibatis= ERROR
log4j.logger.com.ibatis.common.jdbc.SimpleDataSource=ERROR
log4j.logger.com.ibatis.common.jdbc.ScriptRunner=ERROR
log4j.logger.com.ibatis.sqlmap.engine.impl.SqlMapClientDelegate=ERROR

log4j.logger.java.sql.Connection=ERROR
log4j.logger.java.sql.Statement=ERROR
log4j.logger.java.sql.PreparedStatement=ERROR
log4j.logger.java.sql.ResultSet=ERROR

log4j.appender.rolling=org.apache.log4j.DailyRollingFileAppender
log4j.appender.rolling.File=../logs/dr.log
log4j.appender.rolling.Append=true
log4j.appender.rolling.DatePattern='.'yyyy-MM-dd
log4j.appender.rolling.layout=org.apache.log4j.PatternLayout
log4j.appender.rolling.ConversionPattern=[%d] %-5p - %m%n

log4j.appender.console=org.apache.log4j.ConsoleAppender
log4j.appender.console.layout=org.apache.log4j.PatternLayout
log4j.appender.console.layout.ConversionPattern=%d{HH:mm:ss.SSS} %-5p [%c{1}] (%F:%L) - %m%n