We are running CA API Gateway v9.2. I have a 2 cluster node setup with replication setup between them.
Node 1 is receiving "Perform JDBC Query" assertion failed due to: Cannot retrieve a C3P0 DataSource: no connections available for 'OAuth' (JDBC Connection Name).
Node is receiving "Perform JDBC Query" assertion failed due to: Cannot retrieve a C3P0 DataSource: Name OAuth is not bound in this Context.
These are happening when services are calling into the OAuth2 policy fragments as well as within the schedule maintainence jobs that run every few minutes.
Our Database is an external Oracle DB. We have 3 levels in test stood up. Our first level is working with the JDBC connection without issue. We started noticing this on our level 3 and level 4 test levels. The JDBC connection Test comes back successful in all cases.
What am I missing?
there is a issue with Oracle that will cause connection instability.
Follow these steps to configure your jdbc connection
JDBC Connection Failures
I have instituted the changes from the link provided...I have restarted both of the Gateway Appliances.
I am still seeing the exact same error as before on Node 2. I am not seeing any issues on Node 1 at this time.
if you can get the log from oracle side, it may give some clues on why the connection rejected.
I would guess the max connection limit is reached, note that the pool setting is per node, the total connections to oracle is the sum of all pool size.