JDBC Database connections are continuous recycling
search cancel

JDBC Database connections are continuous recycling


Article ID: 237178


Updated On:


CA API Gateway


We have a cluster of API 10 CR4 gateway's 

We are experiencing a weird behavior. One of the database pool is recycling connections every few minutes and the other one is not doing that .


Release : 10.0

Component :


The maxIdleTime c3p0 setting should prevent the pool manager to close the idle connections .

This can be reproduced when you set the maxIdleTime to a short value . 

make sure the setting is applied correctly and there is no  typo  or non printable char in the c3p0 settings name

remove all the current c3p0 settings you have defined.

create only the c3p0.maxIdleTime again, to do this make sure you type it do not copy paste 

Type "maxIdleTime" and select the box for c3p0 settings  set the value to 0 .

save the jdbc datasource and see if you still see the connection to the database are still being recycled .