Mailing-List: contact users-help@tomcat.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Tomcat Users List" <users@tomcat.apache.org>
Received-SPF: pass (nike.apache.org: domain of demablogia@gmail.com designates
 209.85.219.52 as permitted sender)
MIME-Version: 1.0
In-Reply-To: <C3CE3C9461724341BB14DD344A03003410122F@exgtmb27.nam.nsroot.net>
References: <515E9B5A.3060909@medifirst.fr>
 <CABzHfV=AdVnSarxbNQZZ+CUSFRmZdxX_MuciaeLrvgcvdeXRug@mail.gmail.com>
 <515EEFC8.7090108@medifirst.fr>
 <C3CE3C9461724341BB14DD344A03003410122F@exgtmb27.nam.nsroot.net>
From: =?ISO-8859-1?Q?Jose_Mar=EDa_Zaragoza?= <demablogia@gmail.com>
Date: Fri, 5 Apr 2013 22:44:03 +0200
Message-ID: 
 <CABOBwRhoMBwSwrfbvb6AGp64oFgoXFikKd2-qp+8Wx3MV39h-A@mail.gmail.com>
Subject: Re: Tomcat7 - ajax and connection pool : "connection closed" despite
 the use of "validationQuery" and "testOnBorrow"
To: Tomcat Users List <users@tomcat.apache.org>
Content-Type: multipart/alternative; boundary=e89a8fb20334005d2304d9a32790

--e89a8fb20334005d2304d9a32790
Content-Type: text/plain; charset=ISO-8859-1

'select 1 from dual' works in Oracle DB

In MySQL, "select 1"


2013/4/5 Propes, Barry L <barry.l.propes@citi.com>

>  I could be wrong, but is that validationQuery attribute correct?
>
> "SELECT 1"  ? - I have validationQuery="select 1 from dual" in mine, and
> my doc states it has to be a valid SQL statement returning at least one row.
>
> That may not factor in at all, just noticed it. Looked maybe out of kilter.
>
> -----Original Message-----
> From: Jean-Claude Haw-King-Chon [mailto:JChaw-king-chon@medifirst.fr]
> Sent: Friday, April 05, 2013 10:38 AM
> To: Tomcat Users List
> Subject: Re: Tomcat7 - ajax and connection pool : "connection closed"
> despite the use of "validationQuery" and "testOnBorrow"
>
> ..
>
> My configuration :
>
> <Resource
>          name="jdbc/607"
>          auth="Container"
>          type="javax.sql.DataSource"
>          username="xxxxx"
>          password="xxxxx"
>          driverClassName="com.mysql.jdbc.Driver"
>          url="jdbc:mysql://localhost:3306/XXXXX"
>          removeAbandoned="true"
>          removeAbandonedTimeout="300"
>          testOnBorrow="true"
>          validationQuery="SELECT 1"
>          logAbandoned="true"
> />
> Tomcat 7.0.29
> Linux Fedora Core 12
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
> For additional commands, e-mail: users-help@tomcat.apache.org
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
> For additional commands, e-mail: users-help@tomcat.apache.org
>
>

--e89a8fb20334005d2304d9a32790--