Hi,
We use Oracle db with flowable and after running a soak test (perf) for 8 hours, our database team have reported that there are approx 560 inactive sessions. The database configuration is
spring.datasource.hikari.maximum-pool-size=150
Is there any know issue with using hikari cp - had assumed that the connections would be closed when not in use, and shouldn’t go beyond the max pool size. Is there any specific setting that needs to be added please.
No, this would be discovered soon, as Hikari is used in Spring Boot too.
How have you configured Flowable or how are you running it? Perhaps you have misconfigured the datasource of Flowable.
Thanks. Have updated the datasource details below. Is Hikari better than UCP, if so, will modify the configuration to use Hikari
#oracle db flowable
spring.datasource.driver-class-name=oracle.jdbc.OracleDriver
#spring.datasource.type=oracle.ucp.jdbc.UCPDataSource
spring.datasource.type=oracle.ucp.jdbc.PoolDataSource
spring.datasource.oracleucp.connection-factory-class-name=oracle.jdbc.replay.OracleDataSourceImpl
spring.datasource.oracleucp.sql-for-validate-connection=select * from dual
spring.datasource.oracleucp.connection-pool-name=connectionPoolName1
spring.datasource.oracleucp.initial-pool-size=100
spring.datasource.oracleucp.min-pool-size=50
spring.datasource.oracleucp.max-pool-size=150
spring.datasource.oracleucp.max-idle-time=1700
#the max time available where connections can remain idle before it is closed and removed from pool
spring.datasource.oracleucp.inactive-connection-timeout=1700
#the connections that are created , reused and its time exceed more than 1700 seconds will be closed due to firewall time restrictions
spring.datasource.oracleucp.max-connection-reuse-time=1700
#abandon connection if borrowed connection is not used for more than 180 seconds
spring.datasource.oracleucp.abandoned-connection-timeout=180
#max time a borrowed connection to remain borrowed before being reclaimed by pool
spring.datasource.oracleucp.time-to-live-connection-timeout=600
#max number of times connection can be reused
spring.datasource.oracleucp.max-connection-reuse-count=150
Do you mean that you switched to Hikari and were using UCP before? Or the other way atound? In any case, Hikari is what by default is used in Spring Boot.