<div>
Is there any good/better way to check if the connection still is working?
</div>


Is there any good/better way to check if the connection still is working?

<div>
I'm still looking for a good solution concerning this connection validation problem.<br />
<br />
Is there somthing like validationQuery for OracleDataSource or ConnectionCacheManager ? <br />
<br />
I know that I could simply query the DB every time the users need a connection, but I guess it is just a workaround...
</div>


I'm still looking for a good solution concerning this connection validation problem.

Is there somthing like validationQuery for OracleDataSource or ConnectionCacheManager ?

I know that I could simply query the DB every time the users need a connection, but I guess it is just a workaround...

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
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.<br />
<br />
At first, I used OracleDataSource and OraclePooledConnection, but now it seems that OracleConnectionCacheManag<wbr />er is much more useful and &quot;powerful&quot;. 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?<br />
<br />
Thanks
</div>
</div>


Hi,

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?

Thanks

OracleConnectionCacheManager - Event Listener

Java is a platform-independent, object-oriented programming language and run-time environment, designed to have as few implementation dependencies as possible such that developers can write one set of code across all platforms using libraries. Most devices will not run Java natively, and require a run-time component to be installed in order to execute a Java program.