본문 바로가기

JAVA - Backend/SpringBoot - ApplicationFramework

Oracle DB 설정

Gradle : 
// DB Connection (HikariCP - Connection Pool 포함)
implementation 'org.springframework.boot:spring-boot-starter-jdbc'
// Oracle JDBC Driver
runtimeOnly 'com.oracle.ojdbc:ojdbc8'

설정파일에 설정 추가 (src>resources>application.properties)

#Oracle
spring.datasource.url=jdbc:oracle:thin:@172.16.0.00:1521:xe
spring.datasource.username=id
spring.datasource.password=pass
spring.datasource.driver.class=oracle.jdbc.OracleDriver

# Hikari Connection pool
## 최소 유지 커넥션 수
spring.datasource.hikari.minimum-idle=5
## 최대 커넥션 수 = 사용중 + 유휴상태
spring.datasource.hikari.maximum-pool-size=10
## 커넥션 대기시간(밀리초), 초과시 익셉션
spring.datasource.hikari.connection-timeout=30000
## 커넥션 유휴대기 가능시간(밀리초)
spring.datasource.hikari.idle-timeout=30000
## 커넥션 풀 네임
spring.datasource.hikari.pool-name=SpringBootJPAHikariCP