commons-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Vladimir Konkov (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DBCP-427) Examines 'SQLException's thrown by underlying connections or statements for fatal (disconnection) errors
Date Sat, 04 Oct 2014 11:08:34 GMT
Vladimir Konkov created DBCP-427:
------------------------------------

             Summary: 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
            Reporter: Vladimir Konkov
            Priority: Minor


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)

Mime
View raw message