MySQL + Springboot JPA + logback

 

연동 과정

 

1. gradle 빌드 사용

2. 로그백 사용

3. application.properties

 

기호에 맞게 수정해주자

 

 

build.gradle

dependencies {
    //    todo: logback , log4jdbc 설정
    implementation 'org.bgee.log4jdbc-log4j2:log4jdbc-log4j2-jdbc4.1:1.16'

    //	todo: mysql
    implementation 'mysql:mysql-connector-java:8.0.32'
    
    // 나머지들
    implementation 'org.springframework.boot:spring-boot-starter-data-jpa'
    implementation 'org.springframework.boot:spring-boot-starter-web'
    compileOnly 'org.projectlombok:lombok'
    developmentOnly 'org.springframework.boot:spring-boot-devtools'
    annotationProcessor 'org.projectlombok:lombok'
    providedRuntime 'org.springframework.boot:spring-boot-starter-tomcat'
    testImplementation 'org.springframework.boot:spring-boot-starter-test'
}

 

 

logback

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




// logback-spring.xml
<?xml version="1.0" encoding="UTF-8"?>
<configuration debug="true">

	<!-- Appenders -->
	<appender name="console" class="ch.qos.logback.core.ConsoleAppender">
		<encoder>
			<Pattern>%d %5p [%c] %m%n</Pattern>
		</encoder>
	</appender>

	<appender name="console-infolog" class="ch.qos.logback.core.ConsoleAppender">
		<encoder>
			<Pattern>%d %5p %m%n</Pattern>
		</encoder>
	</appender>

	<!-- Logger -->
	<logger name="com.example.simpledms" level="DEBUG" appender-ref="console" />
	<logger name="jdbc.sqlonly" level="INFO" appender-ref="console-infolog" />
	<logger name="jdbc.resultsettable" level="INFO" appender-ref="console-infolog" />

	<!-- Root Logger -->
	<root level="off">
		<appender-ref ref="console" />
	</root>
</configuration>

 

 

application.properties

server.port=8000

# My SQL 설정
spring.datasource.driver-class-name=net.sf.log4jdbc.sql.jdbcapi.DriverSpy
# DB Source URL
# jdbc:log4jdbc:mysql://ip주소:port번호/사용할 데이터베이스?
spring.datasource.url=jdbc:log4jdbc:mysql://localhost:3306/exam01?serverTimezone=UTC&characterEncoding=UTF-8
spring.datasource.username=
spring.datasource.password=
spring.jpa.database-platform=org.hibernate.dialect.MySQL57Dialect

spring.jpa.hibernate.ddl-auto=none
spring.jpa.show-sql=true
spring.jpa.properties.hibernate.format_sql=true
logging.level.org.hibernate=info
spring.jpa.properties.hibernate.default_batch_fetch_size=1000
spring.sql.init.continue-on-error=true

spring.devtools.restart.enabled=true

# HikariCP settings
spring.datasource.hikari.minimumIdle=1
spring.datasource.hikari.maximumPoolSize=1
spring.datasource.hikari.poolName=HikariPoolBooks

 

 

나머지 기호에 맞게 사용

 

 

 

 

 

 

< 에러 >

receiver class org.springframework.boot.logging.logback.rootloglevelconfigurator does not define or inherit an implementation of the resolved method 'abstract void configure(ch.qos.logback.classic.loggercontext)' of interface ch.qos.logback.classic.spi.configurator

 

로그백 에러로써 로그백 버전 등 확인 또는 재실행