Refresh OC4J Connection Pool when trapping ORA-04068 in a Fault Policy
130180Apr 9 2008 — edited Jun 25 2008Hi everyone
We are using BPEL to integrate a number of systems with E-Business Suite. Consequently we use the DB Adapter to call PL/SQL packages in this system.
I've been thinking about an issue that we get whenever we change a PL/SQL package, thus changing it's state.
If a JDBC database connection has used this before, then it's state becomes invalid and we have to manually refresh the connection pool in EM.
Now, I thought that if we are using Fault Policies, we could specifically trap errors like that:
ORA-04068: existing state of packages has been discarded
ORA-04063:could not find program unit being called
Once trapped, I would ideally like to call something to refresh the connection pool , then retry the step that failed.
That is where I am stuck. I cannot find a utility that provides the functionality to refresh a connection pool. Does anyone know any way of doing this except via Enterprise Manager?
Otherwise, this is something we need to be aware of when applying changes to an environment and although this should not happen often in Production, if we can avoid it, then so much the better.
Any thoughts?
Many thanks
Chris