ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

JDBC Database connections are continuous recycling

book

Article ID: 237178

calendar_today

Updated On:

Products

CA API Gateway

Issue/Introduction

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 .

Second one, this:

 

Environment

Release : 10.0

Component :

Resolution

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

This can be reproduced when tou 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 .