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 (athena.apache.org: domain of demablogia@gmail.com
 designates 209.85.214.181 as permitted sender)
MIME-Version: 1.0
In-Reply-To: <C3CE3C9461724341BB14DD344A030034101313@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>
 <CABOBwRhoMBwSwrfbvb6AGp64oFgoXFikKd2-qp+8Wx3MV39h-A@mail.gmail.com>
 <C3CE3C9461724341BB14DD344A030034101313@exgtmb27.nam.nsroot.net>
From: =?ISO-8859-1?Q?Jose_Mar=EDa_Zaragoza?= <demablogia@gmail.com>
Date: Sat, 6 Apr 2013 00:06:54 +0200
Message-ID: 
 <CABOBwRjX6j8gu2nk0sy+KHnnLvSWW0e2BkHM3AgBtAhB=3whuQ@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=e89a8fb203343d925304d9a44f1f

--e89a8fb203343d925304d9a44f1f
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

And that's right . You can define any SQL , but you prefer the easiest (
and fastest )

Indeed , you could use SELECT 1 FROM DUAL in MySQL, but it's not required
by using FROM DUAL
>From MySQL doc

"DUAL is purely for the convenience of people who require that all SELECT
statements should have FROM and possibly other clauses. MySQL may ignore
the clauses. MySQL does not require FROM DUAL if no tables are referenced."

I think that Oracle requires "FROM" word in queries ( I think )


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

> Ok, thanks for clarification. I thought it had to be "from some faux tabl=
e
> or object."
>
>
> -----Original Message-----
> From: Jose Mar=EDa Zaragoza [mailto:demablogia@gmail.com]
> Sent: Friday, April 05, 2013 3:44 PM
> To: Tomcat Users List
> Subject: Re: Tomcat7 - ajax and connection pool : "connection closed"
> despite the use of "validationQuery" and "testOnBorrow"
>
> '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=3D"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=3D"jdbc/607"
> >          auth=3D"Container"
> >          type=3D"javax.sql.DataSource"
> >          username=3D"xxxxx"
> >          password=3D"xxxxx"
> >          driverClassName=3D"com.mysql.jdbc.Driver"
> >          url=3D"jdbc:mysql://localhost:3306/XXXXX"
> >          removeAbandoned=3D"true"
> >          removeAbandonedTimeout=3D"300"
> >          testOnBorrow=3D"true"
> >          validationQuery=3D"SELECT 1"
> >          logAbandoned=3D"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
> >
> >
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
> For additional commands, e-mail: users-help@tomcat.apache.org
>
>

--e89a8fb203343d925304d9a44f1f--