Search results
Oracle UCP Connection Pool Configuration in Spring Boot Applications
pom.xml:
<properties>
<ojdbc17-ucp.version>23.26.0.0.0</ojdbc17-ucp.version>
</properties>
<dependency>
<groupId>com.oracle.database.jdbc</groupId>
<artifactId>ojdbc17</artifactId>
<version>${ojdbc17-ucp.version}</version>
</dependency>
<dependency>
<groupId>com.oracle.database.jdbc</groupId>
<artifactId>ucp</artifactId>
<version>${ojdbc17-ucp.version}</version>
</dependency>
Or
<properties>
<oracle-spring-boot-starter-ucp.version>26.0.0</oracle-spring-boot-starter-ucp.version>
</properties>
<dependency>
<groupId>com.oracle.database.spring</groupId>
<artifactId>oracle-spring-boot-starter-ucp</artifactId>
<version>${oracle-spring-boot-starter-ucp.version}</version>
</dependency>
application.yml:
spring:
datasource:
# This property is not needed when including the oracle-spring-boot-starter-ucp dependency.
type: oracle.ucp.jdbc.PoolDataSource # Use Oracle UCP instead of HikariCP.
oracleucp:
connection-factory-class-name: oracle.jdbc.pool.OracleDataSource
connection-pool-name: DB_DVDRENTAL-CONN-POOL
initial-pool-size: 15
min-pool-size: 15
max-pool-size: 50
connection-wait-timeout: 30 # 30 seconds
inactive-connection-timeout: 300 # 5 minutes
timeout-check-interval: 120 # 2 minutes
max-connection-reuse-time: 3600 # 1 hour
time-to-live-connection-timeout: 7200 # 2 hours
max-statements: 100
validate-connection-on-borrow: true
connection-harvest-trigger-count: 10
connection-harvest-max-count: 5
