Check DB connection availability

Posted by Mamdouh Kaadan-2 on Aug 27, 2006; 4:39pm
URL: http://ofbiz.116.s1.nabble.com/Check-DB-connection-availability-tp141538.html

Dear all

 

I'm facing a problem with my DB connections, I have 2 DBs, one life and
the other is Backup.

Sometimes, the life one due to unexpected error shut down suddenly, and
all the pages in OFBiz related to this DB give an error.

 

How can I check if the connection is still available or not, and in case
of unavailability, how can I connect to the backup DB in a transparent
way??

The DBA advised me to retrieve the data through stored procedures, but
as I know, the stored procedure is not supported by OFBiz.

 

Please advice

 

Kind regards

 

==================================

Mamdouh Kaadan