OracleConnectionCacheManager - Event Listener
Posted on 2005-05-14
I have an Oracle 10g database and we are developping a 3-tier application. I am currently working on the database connection management (Connection Pooling) and would like to notify client applications when there is a problem with connecting to the database and then notify when connection is available again later.
At first, I used OracleDataSource and OraclePooledConnection, but now it seems that OracleConnectionCacheManager is much more useful and "powerful". Now that this is implemented, how can I add an event listener to the caching object so that when physical connection to DB goes down, my app could send a notification?