Thursday, 28 September 2017

Oracle SOA DB Poller Error-Caused by BINDING.JCA-11608 Connection Already Closed Exception.


Error :
 BINDING.JCA-11624[[
DBActivationSpec Polling Exception.
Query name: [pollALPSelect], Descriptor name: [pollALP.IfAlpOwner]. Polling the database for events failed on this iteration.
Caused by BINDING.JCA-11608
Connection Already Closed Exception.
This [javax.resource.cci.Connection] is already closed.
This should not happen when running within a packaged application like BPEL or ESB but may occur when the adapter is used standalone.

Reason :
 Made changes to the weblogic server data source / Connection factory leads to a DB adaptor redeploy and that DB adaptor incidences will fail with the same error.


Solution :
Retire all DB Pollers which have encountered this error.
Activate all DB  Pollers.

The issue will be fixed.