R2DBC Oracle driver 연결 처리

r2dbc로 mysql은 쉽게 연결이 되었는데
막상 오라클 연결 할일이 있어 연결하니  쉽게 처리가 되지 않고 구글링에서도 정보가 잘 나오지 않아 정리한다.

mysql driver

build.gradle.kts

implementation("dev.miku:r2dbc-mysql")

application.yml

spring:
  r2dbc:
    url: r2dbc:mysql://localhost:3306/scoregame_dev?serverTimezone=Asia/Seoul&characterEncoding=UTF-8
    username: username
    password: password
    pool:
      enabled: true
      initial-size: 1
      max-size: 1

 

---

oracle driver

build.gradle.kts

    implementation("com.oracle.database.jdbc:ojdbc11:21.5.0.0")
    implementation("com.oracle.database.r2dbc:oracle-r2dbc:0.4.0")
    implementation("io.r2dbc:r2dbc-spi:1.0.0.RELEASE")

application.yml

spring:
  r2dbc:
    url: r2dbc:oracle:thin://localhost:1521/orcl
    username: username
    password: password
    pool:
      enabled: true
      initial-size: 1
      max-size: 1