Springboot SQL log formatting 설정 (logback)

logback - DriverSpy

• Spring 3 부터는 기본으로 logback 사용 (log4j X)
• 환경 : Spring boot 3 / gradle / oracle
• 참고 : https://earth-95.tistory.com/41#Logback%EC%25-D%25B-%EB%25-E%25--%25-F

1. 변경파일
   • build.gradle
   • application.yml
   • logback-spring.xml
   • (추가) log4jdbc.log4j2.properties
2. build.gradle
3. # 의존성 추가 implementation 'org.bgee.log4jdbc-log4j2:log4jdbc-log4j2-jdbc4.1:1.16' /* Log4JDBC */
4. log4jdbc.log4j2.properties
5. # 구현체 추가 log4jdbc.spylogdelegator.name=net.sf.log4jdbc.log.slf4j.Slf4jSpyLogDelegator log4jdbc.dump.sql.maxlinelength=0
6. application.yml
7. # 드라이버 적용 (MySql의 경우 Driver Dep 이슈있음) datasource : maindb: driverClassName : net.sf.log4jdbc.sql.jdbcapi.DriverSpy jdbc-url: jdbc:log4jdbc:oracle:thin:@------ username: - password: -
8. logback-spring.xml
9. # 포맷 및 로거 추가&컬러설정 https://velog.io/@backtony/Spring-%EB%A1%9C%EA%B7%B8-%EC%84%A4%EC%A0%95%ED%95%98%EA%B8%B0-Logback

참고

https://earth-95.tistory.com/41#Logback%EC%25-D%25B-%EB%25-E%25--%25-F
https://congsong.tistory.com/23#5.-log4jdbc.log4j2.properties-%EC%B6%94%EA%B0%80%ED%95%98%EA%B8%B0
https://backtony.github.io/interview/spring/2021-12-01-interview-13/
https://breakcoding.tistory.com/400