[Spring Boot] MyBatis 쿼리 log4j 로그 출력 설정

gradle 추가

implementation 'org.bgee.log4jdbc-log4j2:log4jdbc-log4j2-jdbc4:1.16'

datasource 설정 변경

spring:
  datasource:
    hikari:
      #jdbc-url: jdbc:mysql://127.0.0.1:3306/
      #driver-class-name: com.mysql.cj.jdbc.Driver
      jdbc-url: jdbc:log4jdbc:mysql://127.0.0.1:3306/
      driver-class-name: net.sf.log4jdbc.sql.jdbcapi.DriverSpy

logging 설정

logging:
  level:
    jdbc.sqlonly: OFF
    jdbc.audit: OFF
    jdbc.resultset: OFF
    jdbc.connection: OFF
    jdbc.sqltiming: DEBUG
    jdbc.resultsettable: DEBUG

log4jdbc.log4j2.properties 생성

• src/main/resources 하위에 생성

log4jdbc.spylogdelegator.name=net.sf.log4jdbc.log.slf4j.Slf4jSpyLogDelegator
log4jdbc.dump.sql.maxlinelength=0

 

 

https://log4jdbc.brunorozendo.com/