$$config title: [Spring] SQL 로거 적용하기 keywords: - IT - Spring - Java - SQL로거 $$ # Pom.xml ```xml org.bgee.log4jdbc-log4j2 log4jdbc-log4j2-jdbc4.1 1.16 ``` # src/main/resources/application.yml ## 기존코드 ```yml server: port: 8011 spring: datasource: driver-class-name: com.mysql.cj.jdbc.Driver url: jdbc:mysql://127.0.0.1:3306/sb_c_2021_2nd_t?useUnicode=true&characterEncoding=utf8&autoReconnect=true&serverTimezone=Asia/Seoul&useOldAliasMetadataBehavior=true&zeroDateTimeNehavior=convertToNull username: sbsst password: sbs123414 mybatis: type-aliases-package: com.sbs.exam.demo.vo ``` ## 수정 코드 ```yml server: port: 8011 spring: datasource: # driver-class-name: com.mysql.cj.jdbc.Driver driver-class-name: net.sf.log4jdbc.sql.jdbcapi.DriverSpy url: jdbc:log4jdbc:mysql://127.0.0.1:3306/sb_c_2021_2nd_t?useUnicode=true&characterEncoding=utf8&autoReconnect=true&serverTimezone=Asia/Seoul&useOldAliasMetadataBehavior=true&zeroDateTimeNehavior=convertToNull username: sbsst password: sbs123414 mybatis: type-aliases-package: com.sbs.exam.demo.vo ``` # src/main/resources/log4jdbc.log4j2.properties ```properties log4jdbc.spylogdelegator.name = net.sf.log4jdbc.log.slf4j.Slf4jSpyLogDelegator log4jdbc.dump.sql.maxlinelength = 0 ``` # src/main/resources/logback-spring.xml ```xml %d{yyyy-MM-dd HH:mm:ss} [%thread] [%-5level] %logger{36} - %msg%n UTF-8 ${LOG_PATH}/today_common.log %d{yyyy-MM-dd HH:mm:ss} [%-5level] %logger{36} - %msg%n UTF-8 ${LOG_PATH}/daily_common/%d{yyyy-MM-dd}.log 30 ${LOG_PATH}/archived/today_common.log %d{yyyy-MM-dd HH:mm:ss} [%-5level] %logger{36} - %msg%n UTF-8 10MB ${LOG_PATH}/archived/today_common.%i.log.zip 1 10 error ACCEPT DENY ${LOG_PATH}/error.log %d{yyyy-MM-dd HH:mm:ss} [%-5level] %logger{36} - %msg%n UTF-8 ${LOG_PATH}/daily_error/%d{yyyy-MM-dd}.log 30

```

게시글 상세