Return-Path: 
 <users-return-221312-apmail-tomcat-users-archive=tomcat.apache.org@tomcat.apache.org>
Delivered-To: apmail-tomcat-users-archive@www.apache.org
Received: (qmail 24917 invoked from network); 27 Jan 2011 16:26:16 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3)
  by minotaur.apache.org with SMTP; 27 Jan 2011 16:26:16 -0000
Received: (qmail 24845 invoked by uid 500); 27 Jan 2011 16:26:12 -0000
Delivered-To: apmail-tomcat-users-archive@tomcat.apache.org
Received: (qmail 23476 invoked by uid 500); 27 Jan 2011 16:26:06 -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 23452 invoked by uid 99); 27 Jan 2011 16:26:05 -0000
Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230)
    by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 27 Jan 2011 16:26:05 +0000
X-ASF-Spam-Status: No, hits=-0.0 required=5.0
	tests=SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (nike.apache.org: local policy)
Received: from [72.22.94.67] (HELO virtual.halosg.com) (72.22.94.67)
    by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 27 Jan 2011 16:25:56 +0000
Received: (qmail 22299 invoked from network); 27 Jan 2011 10:25:35 -0600
Received: from dsl081-072-059.sfo1.dsl.speakeasy.net (HELO ?192.168.1.12?)
 (64.81.72.59)
  by halosg.com with (DHE-RSA-AES256-SHA encrypted) SMTP;
 27 Jan 2011 10:25:35 -0600
Message-ID: <4D419CF9.7010907@hanik.com>
Date: Thu, 27 Jan 2011 09:27:37 -0700
From: Filip Hanik - Dev Lists <devlists@hanik.com>
User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; en-US;
 rv:1.9.1.9) Gecko/20100330 Fedora/3.0.4-1.fc11 Lightning/1.0b2pre
 Thunderbird/3.0.4
MIME-Version: 1.0
To: Tomcat Users List <users@tomcat.apache.org>
Subject: Re: Problems with connections pool in Tomcat 6.0.18 6.0.20 + MySQL
 5.1 + mysql-connector 5.1.x
References: <AANLkTincEw+WrZXz89+cVCq9vjyiq0_WJ1xf9eqH7oBn@mail.gmail.com>
In-Reply-To: <AANLkTincEw+WrZXz89+cVCq9vjyiq0_WJ1xf9eqH7oBn@mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Checked: Checked by ClamAV on apache.org

Add in validationQuery and testOnBorrow as seen below

<Resource driverClassName="com.mysql.jdbc.Driver"
     logAbandoned="false"
     maxActive="35"
     maxIdle="2"
     maxWait="5000"
     name="jdbc/TheName"
     password="password"
     removeAbandoned="true"
     removeAbandonedTimeout="60"
     type="javax.sql.DataSource"
     url="jdbc:mysql://localhost:3306/schema"
     username="user"
     testOnBorrow="true"
     validationQuery="SELECT 1"/>



On 01/27/2011 12:46 AM, Ramon Garcia Alarcon wrote:
> Hi all,
>
> I have a problem with:
> Tomcat 6.0.x + MySQL 5.1 + mysql-connector.5.1.x
> And I test with Ubuntu 10.04, Windows 2003 and Mac OSX 10.6.6
>
> I configured the connection in tomcat like this:
>
> <Resource driverClassName="com.mysql.jdbc.Driver"
>      logAbandoned="false"
>      maxActive="35"
>      maxIdle="2"
>      maxWait="5000"
>      name="jdbc/TheName"
>      password="password"
>      removeAbandoned="true"
>      removeAbandonedTimeout="60"
>      type="javax.sql.DataSource"
>      url="jdbc:mysql://localhost:3306/schema"
>      username="user"/>
>
> In MySql I have good configured the wait_timeout and the interactive_timeout
> in 28800.
>
> The problem is that the pool never removes the connection and when the mysql
> closes it, I got this exception:
> java.sql.SQLException: Already closed
>
> Some idea?
>
> These configuration was worked properly in MySQL 4.1 and Tomcat 5.5..
>
> Thanks!
>
> Ramon Garcia
>
>    


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