Return-Path: Delivered-To: apmail-commons-dev-archive@www.apache.org Received: (qmail 2608 invoked from network); 29 Jul 2007 15:35:15 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 29 Jul 2007 15:35:15 -0000 Received: (qmail 54551 invoked by uid 500); 29 Jul 2007 15:35:14 -0000 Delivered-To: apmail-commons-dev-archive@commons.apache.org Received: (qmail 54490 invoked by uid 500); 29 Jul 2007 15:35:14 -0000 Mailing-List: contact dev-help@commons.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: "Jakarta Commons Developers List" Delivered-To: mailing list dev@commons.apache.org Received: (qmail 54481 invoked by uid 500); 29 Jul 2007 15:35:14 -0000 Delivered-To: apmail-jakarta-commons-dev@jakarta.apache.org Received: (qmail 54478 invoked by uid 99); 29 Jul 2007 15:35:14 -0000 Received: from Unknown (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 29 Jul 2007 08:35:14 -0700 X-ASF-Spam-Status: No, hits=-100.0 required=10.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [140.211.11.4] (HELO brutus.apache.org) (140.211.11.4) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 29 Jul 2007 15:35:13 +0000 Received: from brutus (localhost [127.0.0.1]) by brutus.apache.org (Postfix) with ESMTP id 1DCBF714208 for ; Sun, 29 Jul 2007 08:34:53 -0700 (PDT) Message-ID: <27643077.1185723293118.JavaMail.jira@brutus> Date: Sun, 29 Jul 2007 08:34:53 -0700 (PDT) From: "Phil Steitz (JIRA)" To: commons-dev@jakarta.apache.org Subject: [jira] Updated: (DBCP-146) [dbcp] Invalidate "broken" connections by monitoring SQLExceptions MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org [ https://issues.apache.org/jira/browse/DBCP-146?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Phil Steitz updated DBCP-146: ----------------------------- Fix Version/s: (was: 1.3) 1.4 Lifecycle enhancment - moving to 1.4 > [dbcp] Invalidate "broken" connections by monitoring SQLExceptions > ------------------------------------------------------------------ > > Key: DBCP-146 > URL: https://issues.apache.org/jira/browse/DBCP-146 > Project: Commons Dbcp > Issue Type: Improvement > Affects Versions: 1.1 > Environment: Operating System: All > Platform: All > Reporter: Dirk Verbeeck > Priority: Minor > Fix For: 1.4 > > Attachments: brokenConn-patch.txt > > > A PoolableConnection can know when it is "broken". (When a fatal SQLException is > thrown.) A SQLException is considered fatal when it includes an error code from > a configurable list of broken connection indicators. > The attached patch is a partial implementation for review > (not all Delegating* methods are covered) > Summary: > Add a list of indicators that (when found in an SQLException) mark a Connection > as "broken". Broken Connections will be destroyed and not returned to the pool. > if (!isBroken()) { > _pool.returnObject(this); > } else { > _pool.invalidateObject(this); > } -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online. --------------------------------------------------------------------- To unsubscribe, e-mail: dev-unsubscribe@commons.apache.org For additional commands, e-mail: dev-help@commons.apache.org