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 2B60B769A for ; Mon, 21 Nov 2011 21:25:19 +0000 (UTC) Received: (qmail 35659 invoked by uid 500); 21 Nov 2011 21:25:14 -0000 Delivered-To: apmail-tomcat-users-archive@tomcat.apache.org Received: (qmail 35472 invoked by uid 500); 21 Nov 2011 21:25:14 -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 35463 invoked by uid 99); 21 Nov 2011 21:25:14 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 21 Nov 2011 21:25:14 +0000 X-ASF-Spam-Status: No, hits=3.0 required=5.0 tests=HTML_IMAGE_RATIO_02,HTML_MESSAGE,RCVD_IN_DNSWL_NONE,SPF_HELO_PASS,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of appy74@dsl.pipex.com designates 212.74.114.14 as permitted sender) Received: from [212.74.114.14] (HELO mk-outboundfilter-6.mail.uk.tiscali.com) (212.74.114.14) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 21 Nov 2011 21:25:06 +0000 X-Trace: 388085988/mk-outboundfilter-6.mail.uk.tiscali.com/PIPEX/$PIPEX-ACCEPTED/pipex-customers/81.86.114.41/None/appy74@dsl.pipex.com X-SBRS: None X-RemoteIP: 81.86.114.41 X-IP-MAIL-FROM: appy74@dsl.pipex.com X-SMTP-AUTH: X-Originating-Country: GB/UNITED KINGDOM X-MUA: Microsoft Outlook 14.0 X-IP-BHB: Once X-IronPort-AV: E=Sophos;i="4.69,549,1315177200"; d="jpg'145?scan'145,208,217,145";a="388085988" X-IP-Direction: IN Received: from 81-86-114-41.dsl.pipex.com (HELO Ustane) ([81.86.114.41]) by smtp.pipex.tiscali.co.uk with ESMTP; 21 Nov 2011 21:24:38 +0000 From: "Martin O'Shea" To: "Tomcat Users List" Subject: Re: Connection pooling issue with MySQLNonTransientConnectionException and Java webapp Date: Mon, 21 Nov 2011 21:24:37 -0000 Message-ID: <007901cca893$f90a4340$eb1ec9c0$@dsl.pipex.com> MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_NextPart_000_007A_01CCA893.F90B0690" X-Mailer: Microsoft Outlook 14.0 Thread-Index: AcyokyeWy6LBn28JRLigX2LZbdXMVA== Content-Language: en-gb ------=_NextPart_000_007A_01CCA893.F90B0690 Content-Type: multipart/alternative; boundary="----=_NextPart_001_007B_01CCA893.F90B0690" ------=_NextPart_001_007B_01CCA893.F90B0690 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Well, I hope I'm reading VisualVM correctly, because when I run the JMeter test first time around, I see 40 'connector' threads created in VisualVM, all of which run for so long and then return to a wait state. And if I run the test again several times in succession, the number of connector threads remains the same: they run, and then wait. JMeter also indicates a clean run with no errors reported. ------=_NextPart_001_007B_01CCA893.F90B0690 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Well, I hope I’m reading VisualVM = correctly, because when I run the JMeter test first time around, I see = 40 ‘connector’ threads created in VisualVM, all of which run = for so long and then return to a wait state.

And if I run the test = again several times in succession, the number of connector threads = remains the same: they run, and then wait.

JMeter also indicates a = clean run with no errors reported.

------=_NextPart_001_007B_01CCA893.F90B0690-- ------=_NextPart_000_007A_01CCA893.F90B0690--