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-c...@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-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
