Return-Path: Delivered-To: apmail-tomcat-users-archive@www.apache.org Received: (qmail 67130 invoked from network); 1 Jul 2009 14:50:07 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 1 Jul 2009 14:50:07 -0000 Received: (qmail 49979 invoked by uid 500); 1 Jul 2009 14:50:13 -0000 Delivered-To: apmail-tomcat-users-archive@tomcat.apache.org Received: (qmail 49945 invoked by uid 500); 1 Jul 2009 14:50:13 -0000 Mailing-List: contact users-help@tomcat.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: "Tomcat Users List" Delivered-To: mailing list users@tomcat.apache.org Received: (qmail 49934 invoked by uid 99); 1 Jul 2009 14:50:13 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 01 Jul 2009 14:50:13 +0000 X-ASF-Spam-Status: No, hits=-2.8 required=10.0 tests=RCVD_IN_DNSWL_MED,SPF_NEUTRAL X-Spam-Check-By: apache.org Received-SPF: neutral (athena.apache.org: 128.253.83.141 is neither permitted nor denied by domain of dns4@cornell.edu) Received: from [128.253.83.141] (HELO authusersmtp.mail.cornell.edu) (128.253.83.141) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 01 Jul 2009 14:50:03 +0000 Received: from [128.253.209.217] (dns4-endeavour.calsnet.cornell.edu [128.253.209.217]) (authenticated bits=0) by authusersmtp.mail.cornell.edu (8.13.1/8.12.10) with ESMTP id n61EnfgO025076 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NOT) for ; Wed, 1 Jul 2009 10:49:42 -0400 (EDT) Message-ID: <4A4B7786.5030707@cornell.edu> Date: Wed, 01 Jul 2009 10:49:42 -0400 From: David Smith User-Agent: Thunderbird 2.0.0.21 (Windows/20090302) MIME-Version: 1.0 To: Tomcat Users List Subject: Re: DBCP and Firewall timeouts References: <200907010900020000@265006334> In-Reply-To: X-Enigmail-Version: 0.95.7 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org It would and the performance hit is minimal if you use the ping syntax in your validation query. I believe it looks like this: validationQuery="/* ping */ SELECT 1" -David AD wrote: > would that simply be the testOnBorrow ? Is there a perf hit for this ? > > > > On Wed, Jul 1, 2009 at 4:00 AM, Mark Thomas wrote: > >>> ------- Original Message ------- >>> From: AD >>> To: Tomcat Users List >>> Sent: 01/07/09, 04:37:26 >>> Subject: DBCP and Firewall timeouts >>> >>> Is there a recommended config of ensuring the connection pool >>> connections either get cleanly terminated or are sanity checked for >>> proper connectivity? We are using JRuby/Tomcat/Rails and are seeing a >>> lot of timeouts after inactivity in the app. >>> >> Use a validation query on borrow. >> >> Mark >> >> >> --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org For additional commands, e-mail: users-help@tomcat.apache.org