기존
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'Spring' 카테고리의 다른 글
| [Spring] web.xml (0) | 2025.08.20 |
|---|---|
| [Spring] 스프링 프레임워크 / 스프링 모듈 (0) | 2025.08.20 |
| [Spring] 스프링 빈 중복 에러(UnsatisfiedDependencyException, NoUniqueBeanDefinitionException) (0) | 2024.08.20 |
| [Spring] log4jdbc 라이브러리로 sql 로그 파라미터 값까지 출력하기 (0) | 2023.08.08 |
| [Spring] 로깅 프레임워크 개념 및 종류 (0) | 2023.07.28 |






