Return-Path: X-Original-To: apmail-tomcat-users-archive@www.apache.org Delivered-To: apmail-tomcat-users-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 213139694 for ; Sat, 3 Mar 2012 13:17:13 +0000 (UTC) Received: (qmail 26268 invoked by uid 500); 3 Mar 2012 13:17:09 -0000 Delivered-To: apmail-tomcat-users-archive@tomcat.apache.org Received: (qmail 26048 invoked by uid 500); 3 Mar 2012 13:17:09 -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 26037 invoked by uid 99); 3 Mar 2012 13:17:09 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 03 Mar 2012 13:17:09 +0000 X-ASF-Spam-Status: No, hits=-0.7 required=5.0 tests=RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of pid@pidster.com designates 209.85.212.173 as permitted sender) Received: from [209.85.212.173] (HELO mail-wi0-f173.google.com) (209.85.212.173) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 03 Mar 2012 13:17:01 +0000 Received: by wibhi18 with SMTP id hi18so1635327wib.18 for ; Sat, 03 Mar 2012 05:16:41 -0800 (PST) Received-SPF: pass (google.com: domain of pid@pidster.com designates 10.180.101.72 as permitted sender) client-ip=10.180.101.72; Authentication-Results: mr.google.com; spf=pass (google.com: domain of pid@pidster.com designates 10.180.101.72 as permitted sender) smtp.mail=pid@pidster.com; dkim=pass header.i=pid@pidster.com Received: from mr.google.com ([10.180.101.72]) by 10.180.101.72 with SMTP id fe8mr3970565wib.4.1330780601650 (num_hops = 1); Sat, 03 Mar 2012 05:16:41 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=pidster.com; s=google; h=message-id:date:from:organization:user-agent:mime-version:to :subject:references:in-reply-to:x-enigmail-version:openpgp :content-type; bh=HNZkT9F3x4KN/1jgkLSh1OKHHl7Quxtu7Ju0XVCyMeY=; b=kZDzcwWC0DIX+8lxzPoVVd6+f4TmG6CYbImbvFbzISFc2f9AZQsn/kO31lcpObjb5o 9P90qBUgGVR8+Do+jiZy0Kp9BBilOCemT5J1ltLcCSHPv5V+n5Ax7iSBL4CSpRj+xoTO s4Jx39Bk5xn3n6369TZC2TweGGJ3o/w08v+tM= Received: by 10.180.101.72 with SMTP id fe8mr3133982wib.4.1330780601578; Sat, 03 Mar 2012 05:16:41 -0800 (PST) Received: from Asura.local (cpc10-lewi14-2-0-cust355.2-4.cable.virginmedia.com. [82.4.249.100]) by mx.google.com with ESMTPS id hn8sm27140712wib.11.2012.03.03.05.16.39 (version=SSLv3 cipher=OTHER); Sat, 03 Mar 2012 05:16:40 -0800 (PST) Message-ID: <4F5219AF.2050105@pidster.com> Date: Sat, 03 Mar 2012 13:16:31 +0000 From: Pid Organization: Pidster Inc User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.7; rv:10.0.2) Gecko/20120216 Thunderbird/10.0.2 MIME-Version: 1.0 To: Tomcat Users List Subject: Re: [Tomcat JDBC Pool] Close pooled connections via JMX References: <4F520F97.3050506@gmx.net> In-Reply-To: <4F520F97.3050506@gmx.net> X-Enigmail-Version: 1.3.5 OpenPGP: id=62590808 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="------------enig630F78F36DC02C9EDCABB825" X-Gm-Message-State: ALoCoQl30n0kl43hFmQkosD9UDGiavFchHh6Lfb0/SU7YOVZFVbfVfYEONVIbri4wZUyrx/dbw8d X-Virus-Checked: Checked by ClamAV on apache.org --------------enig630F78F36DC02C9EDCABB825 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable On 03/03/2012 12:33, Michael wrote: > Hi folks, >=20 > I've been examining the JMX operations of the new pool and did not find= > a crucial one. >=20 > Sometimes our Oracle database has to be restarted, the pool still keeps= > the pooled connections. The webapp requests a connection, receives a > pooled one and boom =3D> ORA-... Connection closed. >=20 > I'd like to be able via JMX to reopen all open pooled connections > without the need to restart the webapp. Do you have testOnBorrow=3D"true" and a validationQuery=3D"SELECT 1 FROM DUAL" configured? This should suffice to ensure each connection is valid before use. p --=20 [key:62590808] --------------enig630F78F36DC02C9EDCABB825 Content-Type: application/pgp-signature; name="signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG/MacGPG2 v2.0.17 (Darwin) Comment: GPGTools - http://gpgtools.org Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iQIcBAEBCgAGBQJPUhm2AAoJEGoM2OGpOvr9H+8QAIkr80vDkzSb+a4ekKoZF/C+ 082zaxN83p4Zi/c23x3wMU80MI4/RpKPlT1dPoJ29Uw/xzcfsQr7A5L11W7x57DU cidhbZ+fX+heuXYKKOLzjA+aiEk91PysDJdimU9RpG5VNU6ILGStr/ElKkeqRIF6 RYPGwqHZbiJYrbU/C0u76N6CiDQdnWumLaHtIQQWs4rGGVY0pAtD0ySSh2f4SFxK r/3G/YB4wAIlqNJhYyPmx0CRhwSGeF8Y6sZ4x/8mdReFmACetazn+3sGI6UsMN6+ jFK5FVmkZlAkJmvsGwLWWIbHT3gvLdJPr6vRJ6M7rE4sYep5luSjIu3jUy+RL+8/ dp/DBvz95QTvlL4AjC2JYp6sKJAtey5+AoSJiZ/5apT12eWfOl13sqyM4G2IATs/ oKk3GgM5gIBIIGGwRFn9QBvJanu8NnJehYhSx+L97Jx1o2zEP40WLyPFAYNeRRiI 2JVjFZ7+Wpe45tp26Md5Dozi2Es8sb4pkWRSleKV3o4tWhg6FBBrKNdgqFgEyICI jEHND+SrX7biTT38AoNhCSddprciwsJKqA2Bk0jNWuHF7PQ8tOjT15HE7Q5M4qX9 1WJLQ9GeBuonFg+WhwmCI4xijZ/K2EwYCyYd41wJCQTHxo4BnXgUTmM5+oexworG 3u5mD1tajoi1XnFfazUe =kLcg -----END PGP SIGNATURE----- --------------enig630F78F36DC02C9EDCABB825--