'Spring Boot App + Hikari + Oracle - we are seeing connection storms in listener logs
We have a Spring Boot app with Hikari library to connect to Oracle DB - where we notice huge number of open/closes in the listener logs. Please find our connection props below. Couldn't pinpoint an issue.
spring.datasource.hikari.connection-timeout=2000
spring.datasource.hikari.maximum-pool-size=10
spring.datasource.hikari.pool-name=springHikariConnection
spring.datasource.hikari.max-lifetime=1800000
spring.datasource.hikari.idle-timeout=60000
spring.datasource.hikari.allow-pool-suspension=true
Noticed few other posts mentioned the same issue:
Spring JDBC Hikari constantly logon logoffs in Oracle Database
spring jdbc hikari connection pool - constantly logs on and off to database
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
