Return-Path: Delivered-To: apmail-commons-user-archive@www.apache.org Received: (qmail 30486 invoked from network); 17 Jul 2010 18:00:11 -0000 Received: from unknown (HELO mail.apache.org) (140.211.11.3) by 140.211.11.9 with SMTP; 17 Jul 2010 18:00:11 -0000 Received: (qmail 49715 invoked by uid 500); 17 Jul 2010 18:00:10 -0000 Delivered-To: apmail-commons-user-archive@commons.apache.org Received: (qmail 49621 invoked by uid 500); 17 Jul 2010 18:00:09 -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 49613 invoked by uid 99); 17 Jul 2010 18:00:08 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 17 Jul 2010 18:00:08 +0000 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests=FREEMAIL_FROM,RCVD_IN_DNSWL_NONE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of phil.steitz@gmail.com designates 209.85.212.43 as permitted sender) Received: from [209.85.212.43] (HELO mail-vw0-f43.google.com) (209.85.212.43) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 17 Jul 2010 18:00:00 +0000 Received: by vws4 with SMTP id 4so3354686vws.30 for ; Sat, 17 Jul 2010 10:59:39 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from :user-agent:mime-version:to:subject:references:in-reply-to :x-enigmail-version:content-type:content-transfer-encoding; bh=A/NK+NafV8ErLXv+bAb3j3X757RIcMKNDCY8//0cWOo=; b=f0GngOjDMBvLqahWF/mOI9/uu/7U4RGOUHpc8WW3R++nxpmiebbLl0S/dbT/mPzHrQ TmWykFwfMXioVemgywJ1UG5DzlNqxqpiYs0WcAPHK1WxaUilysctxc4LXuzbVC7q7/WY UqlaXIchzAtqr55oFYCwCr3rfB/VNBY9LpqAw= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:user-agent:mime-version:to:subject:references :in-reply-to:x-enigmail-version:content-type :content-transfer-encoding; b=kPPYBbfirUyJfLMQ0Cz5PyZ47AUe2ipmZYVSPXq/iLayneYe78dXxtFNW2HeJUjks4 G+RaQcCjmD5kzCadVA+uOiwVZQAr0pUlL487IbJVkW1S9eoT8leRlBbF75w9jtZ2GVY4 IgDdtRk+qcdyl+fjIhPvLAqllhn9CyH/EKZ+Q= Received: by 10.220.59.202 with SMTP id m10mr1494331vch.23.1279389578967; Sat, 17 Jul 2010 10:59:38 -0700 (PDT) Received: from phil-steitzs-macbook-pro.local (c-76-99-90-51.hsd1.de.comcast.net [76.99.90.51]) by mx.google.com with ESMTPS id h17sm937987vcr.27.2010.07.17.10.59.37 (version=SSLv3 cipher=RC4-MD5); Sat, 17 Jul 2010 10:59:38 -0700 (PDT) Message-ID: <4C41EF89.7070108@gmail.com> Date: Sat, 17 Jul 2010 13:59:37 -0400 From: Phil Steitz User-Agent: Thunderbird 2.0.0.24 (Macintosh/20100228) MIME-Version: 1.0 To: Commons Users List Subject: Re: DBCP reconnecting fails References: In-Reply-To: X-Enigmail-Version: 0.96.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org Harut Martirosyan wrote: > Hi, I have a program which periodically executes a simple query on each > connection, and once the connection is being lost it fails during next > iteration and doesn't recover the connections. > > My configuration is > > initialSize = 5 > maxActive = 5 > maxWait = 10000 > maxIdle = 3 > minIdle = 2 > autoReconnect = true > autoReconnectForPools = true > maxReconnects = 10 > testOnBorrow = true > validationQuery = SELECT * FROM vtable > Do you close the connections? What exactly do you mean by "the connection is being lost?" Phil --------------------------------------------------------------------- To unsubscribe, e-mail: user-unsubscribe@commons.apache.org For additional commands, e-mail: user-help@commons.apache.org