OSB DB Polling Service Error: "The Connection Pool Associated With It Has Already Been Destroyed"
(Doc ID 2183838.1)
Last updated on JULY 10, 2020
Applies to:Oracle Service Bus - Version 18.104.22.168.0 and later
Information in this document applies to any platform.
After deploying an OSB service using a DB Adapter the following error is seen in the logs:
DBActivationSpec Polling Exception.
Query name: [dbPollServiceSelect], Descriptor name: [dbPollService]. Polling the database for events failed on this iteration.
Caused by javax.resource.spi.IllegalStateException: [Connector:199176]Unable to execute allocateConnection(...) on ConnectionManager. A stale Connection Factory or Connection Handle may be used. The connection pool associated with it has already been destroyed. Try to perform another lookup of the Connection Factory eis/DB/EBS from JNDI and get a new Connection Handle..
This exception is considered not retriable, likely due to a modelling mistake. This polling process will shut down, unless the fault is related to processing a particular row, in which case polling will continue but the row will be rejected (faulted).
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document