Return-Path: Delivered-To: apmail-commons-user-archive@www.apache.org Received: (qmail 94071 invoked from network); 23 Feb 2009 23:22:47 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 23 Feb 2009 23:22:47 -0000 Received: (qmail 55784 invoked by uid 500); 23 Feb 2009 23:22:43 -0000 Delivered-To: apmail-commons-user-archive@commons.apache.org Received: (qmail 55727 invoked by uid 500); 23 Feb 2009 23:22:42 -0000 Mailing-List: contact user-help@commons.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: "Commons Users List" Delivered-To: mailing list user@commons.apache.org Received: (qmail 55716 invoked by uid 99); 23 Feb 2009 23:22:42 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 23 Feb 2009 15:22:42 -0800 X-ASF-Spam-Status: No, hits=-4.0 required=10.0 tests=RCVD_IN_DNSWL_MED,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: local policy) Received: from [140.172.10.146] (HELO rome.boulder.noaa.gov) (140.172.10.146) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 23 Feb 2009 23:22:33 +0000 Received: from lynx.ngdc.noaa.gov ([140.172.179.24]) by email.boulder.noaa.gov (iPlanet Messaging Server 5.2 HotFix 2.01 (built Aug 26 2004)) with ESMTPSA id <0KFJ00MK5KX0LF@email.boulder.noaa.gov> for user@commons.apache.org; Mon, 23 Feb 2009 23:22:12 +0000 (GMT) Date: Mon, 23 Feb 2009 16:22:12 -0700 From: John Cartwright Subject: Re: [DBCP] re-establish severed connections In-reply-to: <49A32C68.8020804@apache.org> To: Commons Users List Message-id: <49A32FA4.2050709@noaa.gov> MIME-version: 1.0 Content-type: text/plain; charset=ISO-8859-1; format=flowed Content-transfer-encoding: 7BIT User-Agent: Thunderbird 2.0.0.19 (X11/20081209) References: <291301.88756.qm@web50612.mail.re2.yahoo.com> <49A158AC.5040107@apache.org> <49A2D0E0.3090606@noaa.gov> <49A2E398.8090307@noaa.gov> <49A32C68.8020804@apache.org> X-Virus-Checked: Checked by ClamAV on apache.org Mark Thomas wrote: > The validation query on its own does nothing. Have you tried setting > testOnBorrow="true" ? That may be sufficient if you can live with a slight delay > if a broken connection needs to be refreshed. > > Mark > Thanks Mark, I have the "testWhileIdle=true" which I understood would run the validationQuery when the evictor thread fires up - is that correct? In limited testing, DBCP in this configuration seems to even re-establish connections after a database restart. Any further advice that you can offer in dealing w/ that situation? Listed below is my current configuration which seems to be working. Many thanks for your help! --john --------------------------------------------------------------------- To unsubscribe, e-mail: user-unsubscribe@commons.apache.org For additional commands, e-mail: user-help@commons.apache.org