OSB 12.2.1.4 DB adapter polling is not working
OSB version 12.2.1.4
DB adapter is polling from an Oracle databasebut polling is not working.Below is the error in logs. We can test datasource successfully.
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..
We followed steps to RECREATE connection factory and updated DB adapter as suggested in