Openbravo Issue Tracking System - Java Client POS
View Issue Details
0003907Java Client POS(No Category)public2006-10-16 13:122008-10-07 11:56
user71 
user71 
normalminoralways
acknowledgedopen 
5
 
 
0003907: handle database reconnections
Currently when the database connection is dropped for
some reason, tinapos fails with a error. To get
everything working again, tinapos has to be restarted.
This is a big problem when deploying tinapos over
wan/vpn links as connections do drop, in some cases
many times a day.

To fix this, tinapos should detect connection drops &
try to reconnect, possibly failing after certain number
of tries or after a prespecified timeout.

Adrian has suggested other fixes to this problem, as
using HA jdbc drivers, but in my opinion this would
complicate tinapos deployment to a degree that is not
suitable.
No tags attached.
Issue History
2008-10-07 11:56adrianromeroStatusnew => acknowledged
2012-11-07 09:40priyamCategory01 - General => (No Category)

Notes
(0007631)
user71   
2005-06-01 00:00   
(edited on: 2008-06-12 10:12)
This bug was originally reported in SourceForge bug tracker and then migrated to Mantis.

You can see the original bug report in:
https://sourceforge.net/support/tracker.php?aid=1578072 [^]
(0007463)
user71   
2007-02-07 01:54   
(edited on: 2008-06-12 10:08)
Logged In: YES
user_id=421591
Originator: NO

adrian, what about a reconnect method in the "catch {}" section or something like


try { blah blah }

catch (databaseexecption e) {
if !(db.isconnected()); //checks for connections
db.connect(); //if not, then connect

}



It should be easy to implement this...