연동 과정
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
로그백 에러로써 로그백 버전 등 확인 또는 재실행
'SpringBoot' 카테고리의 다른 글
Springboot - NoSQL Redis (0) | 2023.12.14 |
---|---|
윈도우 카프카 - Kafka 를 Springboot 에서 간단히 써보자 (1) | 2023.12.12 |
SpringBoot - MyBatis (RestController) (0) | 2023.10.16 |
SpringBoot - SSR , SCR (개념 간략) (0) | 2023.10.04 |
SpringBoot - Controller 에서 자주 사용되는 어노테이션 (0) | 2023.10.04 |