You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@commons.apache.org by "Phil Steitz (JIRA)" <ji...@apache.org> on 2015/01/28 14:37:34 UTC

[jira] [Resolved] (DBCP-427) Examines 'SQLException's thrown by underlying connections or statements for fatal (disconnection) errors

     [ https://issues.apache.org/jira/browse/DBCP-427?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Phil Steitz resolved DBCP-427.
------------------------------
    Resolution: Fixed

Modified version of the patch committed in r1655301. 

Modifications were to make the behavior configurable.  I added fastFailValidation property to turn on/off the failfast validation and I also added support for user-supplied sets of fatal disconnection SQL_STATE codes.

Thanks for the patch!

> Examines 'SQLException's thrown by underlying connections or statements for fatal (disconnection) errors
> --------------------------------------------------------------------------------------------------------
>
>                 Key: DBCP-427
>                 URL: https://issues.apache.org/jira/browse/DBCP-427
>             Project: Commons Dbcp
>          Issue Type: Improvement
>    Affects Versions: 2.0
>            Reporter: Vladimir Konkov
>            Priority: Minor
>             Fix For: 2.1
>
>         Attachments: DBCP-427_initial_impl.diff
>
>
> Affected cases:
> 1. Ability to detect severed connection without need for validity check (it can be time demand).
> 2. Not all fatal errors detected with simple validation query or isValid() call. For example: 
> Broken XA connections of MS SQL Server and Oracle Database (and may be other) pass validation for both isValid() and simple validation query such as 'SELEC 1 FROM DUAL' but throw fatal errors on data and/or transaction manipulation calls. Such errors gone only after reconnect. In case of use DBCP for polling application has no chance to cleanup broken connection.
> By providing infractructure for check thrown exceptions and mark PoolableConnection as poisoned we can cleanup pool on validation phase.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)