'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