Spring Boot + Logback 설정

- build.gradle dependencies 추가

compile group: 'org.bgee.log4jdbc-log4j2', name: 'log4jdbc-log4j2-jdbc4.1', version: '1.16'

 

- application.properties 추가 (dev) 

spring.datasource.driver-class-name=net.sf.log4jdbc.sql.jdbcapi.DriverSpy
spring.datasource.url=jdbc:log4jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=x.x.x.x)(PORT=xxxx)))(CONNECT_DATA=(SID= xxx)))

 

jdbc driver를 로그 전용으로 바꿉니다.

 

 

    #logging

spring.main.banner-mode=off  
spring.output.ansi.enabled=always 
#logging.pattern.console=%clr(%d{yy-MM-dd E HH:mm:ss.SSS}){blue} %clr(%-5p) %clr(${PID}){faint} %clr(---){faint} %clr([%8.15t]){cyan} %clr(%-40.40logger{0}){blue} %clr(:){red} %clr(%m){faint}%n 
logging.pattern.console=%clr(%d{HH:mm:ss}){green} %highlight([%-5level]) %clr(%-20.40logger{0}){faint} %clr(:){red} %clr(%m){cyan}%n

logging.level.root=WARN 
logging.level.org.springframework=ERROR 
logging.level.x.x.x=DEBUG (package)

Log Level 에 색깔 넣고 필요한 데이터만 찍기

 

 

- loglog4jdbc.log4j2.properties 생성해서 아래 추가

log4jdbc.spylogdelegator.name=net.sf.log4jdbc.log.slf4j.Slf4jSpyLogDelegator

 

- logback.xml 생성

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE configuration>
<configuration>
<include resource="org/springframework/boot/logging/logback/base.xml" />
<logger name="jdbc.splonly" level="DEBUG" />
<logger name="jdbc.sqltiming" level="DEBUG" />
<logger name="jdbc.audit" level="WARN" />
<logger name="jdbc.resultset" level="ERROR" />
<logger name="jdbc.resultsettable" level="OFF" />
<logger name="jdbc.connection" level="OFF" />
</configuration>