Hi
In our current solution ,We are using a DB Failover mechanism when our Primary DB server is down (configured by “Add Failover” in the DB connections as if Primary DB downs , then it fails over to Secondary DB and if the second downs ,fails over to Primary) although that this works we always needs to restart tomcat when a connection is reestablished to the primary server for the app to detect this , more importantly if both servers go down even if they come back again we are unable to detect this so nothing is written on the DB even though that both servers are up unless we restart tomcat.

So, suggest us how can we change the code so it works without a tomcat restart (bearing in mind that the current architecture is used many places in the code so if possible we would like to avoid reengineering this).

Avaya OD Version : 6.0

Thanks
Kasthoori.J

This question appears to be a duplicate of:

http://www.devconnectprogram.com/forums/posts/list/92.page

where Wilson provides an answer.