RE: Tomcat7 - ajax and connection pool : "connection closed" despite the use of "validationQuery" and "testOnBorrow"

2013-04-08 Thread Propes, Barry L
; 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

Re: Tomcat7 - ajax and connection pool : "connection closed" despite the use of "validationQuery" and "testOnBorrow"

2013-04-05 Thread Jose María Zaragoza
t it had to be "from some faux table > or object." > > > -Original Message- > From: Jose María Zaragoza [mailto:demablo...@gmail.com] > Sent: Friday, April 05, 2013 3:44 PM > To: Tomcat Users List > Subject: Re: Tomcat7 - ajax and connection pool : "

RE: Tomcat7 - ajax and connection pool : "connection closed" despite the use of "validationQuery" and "testOnBorrow"

2013-04-05 Thread Propes, Barry L
- > 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" an

Re: Tomcat7 - ajax and connection pool : "connection closed" despite the use of "validationQuery" and "testOnBorrow"

2013-04-05 Thread Jose María Zaragoza
013 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 : > > name="

RE: Tomcat7 - ajax and connection pool : "connection closed" despite the use of "validationQuery" and "testOnBorrow"

2013-04-05 Thread Propes, Barry L
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 "validati

Re: Tomcat7 - ajax and connection pool : "connection closed" despite the use of "validationQuery" and "testOnBorrow"

2013-04-05 Thread Jose María Zaragoza
Hi Konstantin: About this link http://commons.apache.org/proper/commons-dbcp/configuration.html If you have enabled "removeAbandoned" then it is possible that a connection is reclaimed by the pool because it is considered to be abandoned. This mechanism is triggered when (getNumIdle() < 2) and (

Re: Tomcat7 - ajax and connection pool : "connection closed" despite the use of "validationQuery" and "testOnBorrow"

2013-04-05 Thread Konstantin Kolinko
2013/4/5 Jean-Claude Haw-King-Chon : > Le 05/04/2013 13:09, Konstantin Kolinko a écrit : >> >> 2013/4/5 Jean-Claude Haw-King-Chon : >>> >>> Hi, >>> >>> I use the connection pool of tomcat7 and set a connection in a >>> ThreadLocal. >>> The context is a web application : the threadLocal is configure

Re: Tomcat7 - ajax and connection pool : "connection closed" despite the use of "validationQuery" and "testOnBorrow"

2013-04-05 Thread Jean-Claude Haw-King-Chon
Le 05/04/2013 13:09, Konstantin Kolinko a écrit : 2013/4/5 Jean-Claude Haw-King-Chon : Hi, I use the connection pool of tomcat7 and set a connection in a ThreadLocal. The context is a web application : the threadLocal is configured when the http request is initialized. The jdbc connection is cl

Re: Tomcat7 - ajax and connection pool : "connection closed" despite the use of "validationQuery" and "testOnBorrow"

2013-04-05 Thread Michael-O
Fist of all, do NOT top post. Use the power of your wondeful mail client. Am 2013-04-05 13:05, schrieb Jean-Claude Haw-King-Chon: I wish to avoid passing the connection through the layers of the application (from controller to DAO). The controller initialize the connection and must pass it to th

Re: Tomcat7 - ajax and connection pool : "connection closed" despite the use of "validationQuery" and "testOnBorrow"

2013-04-05 Thread Konstantin Kolinko
2013/4/5 Jean-Claude Haw-King-Chon : > Hi, > > I use the connection pool of tomcat7 and set a connection in a ThreadLocal. > The context is a web application : the threadLocal is configured when the > http request is initialized. The jdbc connection is closed and removed from > the threadLocal when

Re: Tomcat7 - ajax and connection pool : "connection closed" despite the use of "validationQuery" and "testOnBorrow"

2013-04-05 Thread Jean-Claude Haw-King-Chon
I wish to avoid passing the connection through the layers of the application (from controller to DAO). The controller initialize the connection and must pass it to the Dao layer. I don't want to pass the datasource or connection to the business layer as a parameter. Futher, the data source can

Re: Tomcat7 - ajax and connection pool : "connection closed" despite the use of "validationQuery" and "testOnBorrow"

2013-04-05 Thread Michael-O
Am 2013-04-05 11:37, schrieb Jean-Claude Haw-King-Chon: Hi, I use the connection pool of tomcat7 and set a connection in a ThreadLocal. The context is a web application : the threadLocal is configured when the http request is initialized. The jdbc connection is closed and removed from the thread

Tomcat7 - ajax and connection pool : "connection closed" despite the use of "validationQuery" and "testOnBorrow"

2013-04-05 Thread Jean-Claude Haw-King-Chon
Hi, I use the connection pool of tomcat7 and set a connection in a ThreadLocal. The context is a web application : the threadLocal is configured when the http request is initialized. The jdbc connection is closed and removed from the threadLocal when the resquest is destroyed. If I'm not mi