Getting MySQL Error on OIC Caused by java.sql.SQLNonTransientConnectionException
Summary:
Error Message:-
<err:serviceInvocationError xmlns:err="http://xmlns.oracle.com/cloud/generic/service/fault">
<err:type>DBReadInteractionSpec Execute Failed Exception</err:type>
<err:title>Query name: [FetchRecordSelect], Descriptor name: [FetchRecord.Test].</err:title>
<err:detail>Caused by java.sql.SQLNonTransientConnectionException: No operations allowed after connection closed..</err:detail>
<err:errorCode>serviceInvocationError</err:errorCode>
<err:remedialAction>See root exception for the specific exception.</err:remedialAction>
</err:serviceInvocationError>
Content (required):
Hi Team,
We are unable to perform queries to MySQL DB from OIC which was working perfectly fine earlier. Both the Connectivity Agent and MySQL Connection are in Active and Configure state respectively.