Thursday, March 31, 2011

Refreshing your connection pool

If you're using the database adapter to "poll" an external database, and that database restarts, the connection pool on that BPEL instance, and, consequently, any BPEL processes using that connection pool, will not work properly.

More troubling is that, due to how BPEL processes instantiate from the DB Adapter, you might not see any errors.

To fix this, you can go into the EM, and navigate to the following location:

-- Administration -- JDBC Resources -- Connection Pools

Find the pool with the dropped database, click "Refresh Connection Pool" and confirm. Test your connectivity then and see what happens.

No comments: