[
http://jira.jboss.com/jira/browse/JBESB-109?page=comments#action_12345259 ]
Daniel Brum commented on JBESB-109:
-----------------------------------
Apache's DBCP handles all of this already using a SQL Validate string, configurable in
the Message Store properties. Everytime a connection is requested, it will check if that
connection is still valid by executing the validate sql string. Stale connections are
removed and refreshed automatically as well.
I do need some people to test out the pool though, I have done limited testing,
DB reconnect after network failure/DB down
------------------------------------------
Key: JBESB-109
URL:
http://jira.jboss.com/jira/browse/JBESB-109
Project: JBoss ESB
Issue Type: Feature Request
Security Level: Public(Everyone can see)
Components: ESB Core
Affects Versions: 4.0 Beta 1
Reporter: Kurt Stam
Assigned To: Mohit Keswani
Fix For: 4.1
Add db reconnnect feature (congifurable). Before using a connection check if the
connection is still valid, if not clean up this connection and try to use another existing
connection, if a connections are removed, try to make a new connection. If this fails give
up, throw exception, but next time try again..
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://jira.jboss.com/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira