[jboss-jira] [JBoss JIRA] Commented: (JBESB-109) DB reconnect after network failure/DB down

[Daniel Brum (JIRA)]

    [ 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