Return-Path: 
 <users-return-181754-apmail-tomcat-users-archive=tomcat.apache.org@tomcat.apache.org>
Delivered-To: apmail-tomcat-users-archive@www.apache.org
Received: (qmail 131 invoked from network); 23 Jun 2008 13:48:14 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2)
  by minotaur.apache.org with SMTP; 23 Jun 2008 13:48:14 -0000
Received: (qmail 92597 invoked by uid 500); 23 Jun 2008 13:46:34 -0000
Delivered-To: apmail-tomcat-users-archive@tomcat.apache.org
Received: (qmail 92558 invoked by uid 500); 23 Jun 2008 13:46:34 -0000
Mailing-List: contact users-help@tomcat.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:users-help@tomcat.apache.org>
List-Unsubscribe: <mailto:users-unsubscribe@tomcat.apache.org>
List-Post: <mailto:users@tomcat.apache.org>
List-Id: <users.tomcat.apache.org>
Reply-To: "Tomcat Users List" <users@tomcat.apache.org>
Delivered-To: mailing list users@tomcat.apache.org
Received: (qmail 92508 invoked by uid 99); 23 Jun 2008 13:46:33 -0000
Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136)
    by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 23 Jun 2008 06:46:33 -0700
X-ASF-Spam-Status: No, hits=1.2 required=10.0
	tests=SPF_NEUTRAL
X-Spam-Check-By: apache.org
Received-SPF: neutral (athena.apache.org: local policy)
Received: from [203.161.124.50] (HELO smtp1.wa.amnet.net.au) (203.161.124.50)
    by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 23 Jun 2008 13:36:21 +0000
Received: from localhost (localhost.localdomain [127.0.0.1])
	by smtp1.wa.amnet.net.au (Postfix) with ESMTP id 9B49882CC6
	for <users@tomcat.apache.org>; Mon, 23 Jun 2008 21:36:33 +0800 (WST)
X-Virus-Scanned: amavisd-new at smtp1.wa.amnet.net.au
Received: from smtp1.wa.amnet.net.au ([127.0.0.1])
	by localhost (smtp1.wa.amnet.net.au [127.0.0.1]) (amavisd-new, port 10024)
	with ESMTP id dn+QBMPFL1hd for <users@tomcat.apache.org>;
	Mon, 23 Jun 2008 21:36:33 +0800 (WST)
Received: from [192.168.1.101] (202-89-165-113.static.dsl.amnet.net.au
 [202.89.165.113])
	by smtp1.wa.amnet.net.au (Postfix) with ESMTP id 15FD582F1A
	for <users@tomcat.apache.org>; Mon, 23 Jun 2008 21:36:32 +0800 (WST)
Message-Id: <ABD3EEC1-ECB5-4503-AA28-B30376F64DC0@recallmedia.com.au>
From: Thomas Haines <thomas.haines@recallmedia.com.au>
To: "Tomcat Users List" <users@tomcat.apache.org>
In-Reply-To: <485D1F40.5070701@christopherschultz.net>
Content-Type: text/plain; charset=US-ASCII; format=flowed; delsp=yes
Content-Transfer-Encoding: 7bit
Mime-Version: 1.0 (Apple Message framework v924)
Subject: Re: Tomcat Connection Pooling - wait_timeout
Date: Mon, 23 Jun 2008 21:36:30 +0800
References: <9153041.607311213690247218.JavaMail.www@wwinf2208>
 <48582D7E.6080509@christopherschultz.net>
 <3666BAE4-657A-4BBE-9557-3D72ABD9065F@recallmedia.com.au>
 <485D1F40.5070701@christopherschultz.net>
X-Mailer: Apple Mail (2.924)
X-Virus-Checked: Checked by ClamAV on apache.org

Chris / David / Youssef

Thanks for the help.  Problem has been resolved!  Comments inline.

>
> | a) downgrade to MySQL Connector/J 5.0.8 and see if this fixes it;
>
> This may fix your problem, but probably not.

Confirmed, this had no effect.

> | b) add a while (!verified && attempts<2) type loop in  
> getConnection()
> | method to query the DB using a minimal query and then catch the  
> first
> | dead connection.
>
> Using 'validationQuery' achieves the same goal without modifying your
> code (which is always nice).


I've used the validation query within the <Resource> as you  
suggested.  This has stopped the "first connection after a while is a  
dead one" problem, and all is well in the land of my webapp!

Thanks all for the tips.

--
Tom


---------------------------------------------------------------------
To start a new topic, e-mail: users@tomcat.apache.org
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org