Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0003907
TypeCategorySeverityReproducibilityDate SubmittedLast Update
feature request[Java Client POS] (No Category)minoralways2006-10-16 13:122008-10-07 11:56
Reporteruser71View Statuspublic 
Assigned Touser71 
PrioritynormalResolutionopenFixed in Version
StatusacknowledgedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Regression date
Regression introduced by commit
Regression level
Review Assigned To
Regression introduced in release
Summary

0003907: handle database reconnections

DescriptionCurrently 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.
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
(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...
(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 [^]

- Issue History
Date Modified Username Field Change
2008-10-07 11:56 adrianromero Status new => acknowledged
2012-11-07 09:40 priyam Category 01 - General => (No Category)


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker