AnsweredAssumed Answered

Cannot retrieve a C3P0 DataSource:

Question asked by rick.reed2.2 on Apr 12, 2018
Latest reply on Apr 27, 2018 by Mark_HE

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?

 

Outcomes