spring boot - oracle wallet

build.gradle 설정

• 공식문서 url (https://www.oracle.com/database/technologies/maven-central-guide.html)

// For building with Gradle (build.gradle)
dependencies {
   // Get BOM file and choose Oracle JDBC driver (ojdbc8.jar) and Universal Connection Pool (ucp.jar)
  implementation(enforcedPlatform("com.oracle.database.jdbc:ojdbc-bom:21.1.0.0"))
  implementation("com.oracle.database.jdbc:ojdbc8")
  implementation("com.oracle.database.jdbc:ucp")
  // Additional Jars for using Oracle Wallets 
  implementation("com.oracle.database.security:oraclepki")
  implementation("com.oracle.database.security:osdt_core")
  implementation("com.oracle.database.security:osdt_cert")
  // Additional Jars for High Availability 
  implementation("com.oracle.database.ha:ons")
  implementation("com.oracle.database.ha:simplefan")
}

• ha:ons 와 ha:simplefan 은 고가용성 사용을 위한 라이브러리들

implementation("com.oracle.database.ha:ons")
implementation("com.oracle.database.ha:simplefan")

• 밑에 두줄을 제외한 코드를 추가

application.yml 설정

spring:
  datasource:
    url: jdbc:oracle:thin:@DB이름_high?TNS_ADMIN=오라클 전자지갑 경로
    username: DB 만들 때 아이디
    password: DB 만들 때 비밀번호
    driver-class-name: oracle.jdbc.OracleDriver
    hikari:
      connection-timeout: 3000
      validation-timeout: 3000
      minimum-idle: 5
      maximum-pool-size: 20
      idle-timeout: 200000
      max-lifetime: 240000
      pool-name: oraPool

• 이렇게 하니 고가용성 설정을 안했다고 뜨는 에러가 더 이상 나지 않고 연결이 잘 됨