tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Propes, Barry L " <barry.l.pro...@citi.com>
Subject RE: Tomcat7 - ajax and connection pool : "connection closed" despite the use of "validationQuery" and "testOnBorrow"
Date Fri, 05 Apr 2013 20:40:28 GMT
 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


Mime
View raw message