OAuth DB Connection Error using Oracle db

Products

• CA API Gateway

Issue/Introduction

When we call our  api services, sometimes we are getting below database error.

"Perform JDBC Query" assertion failed due to: Cannot retrieve a C3P0 DataSource: No connections available for 'OAuth' No connections available for 'OAuth'

When we get this error, I try to test connection from "JDBC Connection Properties" screen and it can connect successfully.

For a resolution we change max pool size value (increase or decresase, it doesn't matter), like from 100 to 150 or from 100 to 50.

Environment

Release : 10.0

Component :

Resolution

Remove the following setting from the JDBC connection settings to prevent the connection never times out when it is closed for some reason .

 c3p0.maxConnectionAge 0