[Spring Boot] application.yml DB 연동 - Oracle에 log4jdbc 적용 (Oracle, MariaDB)

# 적용전

기본적으로 이렇게 설정되어 있을 것이다.

spring.datasource.driver-class-name=oracle.jdbc.driver.OracleDriver
spring.datasource.hikari.jdbc-url=jdbc:oracle:thin:@localhost:1521:xe

 

 

 

#적용후

Oracle

 

spring:
  datasource:
    type: com.zaxxer.hikari.HikariDataSource
    driver-class-name: net.sf.log4jdbc.sql.jdbcapi.DriverSpy
    url: jdbc:log4jdbc:oracle:thin:@192.168.56.33:1521:ora12c

 

MariaDB

 

spring:
  datasource:
    type: com.zaxxer.hikari.HikariDataSource
    driver-class-name: net.sf.log4jdbc.sql.jdbcapi.DriverSpy
    url: jdbc:log4jdbc:mariadb://127.0.0.1:3306/mariaDB?characterEncoding=UTF-8