Re: Debugging Tomcat JDBC pool disconnects.

2014-10-07 Thread Todd Chapman
Aniket, That change had not been committed yet. -Todd On Tuesday, October 7, 2014, Aniket Bhoi wrote: > On Tue, Oct 7, 2014 at 8:41 PM, Todd Chapman > wrote: > > > Chris, > > > > Thank you for the detailed reply and sorry for my delayed response. We > > located the problem. > > > > We had set

Re: Debugging Tomcat JDBC pool disconnects.

2014-10-07 Thread Aniket Bhoi
On Tue, Oct 7, 2014 at 8:41 PM, Todd Chapman wrote: > Chris, > > Thank you for the detailed reply and sorry for my delayed response. We > located the problem. > > We had setTestOnBorrow(true) but had not set the validation query. When the > validation query is null the validation fails causing th

Re: Debugging Tomcat JDBC pool disconnects.

2014-10-07 Thread Todd Chapman
Chris, Thank you for the detailed reply and sorry for my delayed response. We located the problem. We had setTestOnBorrow(true) but had not set the validation query. When the validation query is null the validation fails causing the connection to be re-opened. -Todd On Wed, Sep 24, 2014 at 9:36

Re: Debugging Tomcat JDBC pool disconnects.

2014-09-24 Thread Filip Hanik
If you implement a JdbcInterceptor, the method JdbcInterceptor.disconnected will always be called. If the disconnect is permanent, then JdbcInterceptor.reset(null,null) will be called after disconnected On Tue, Sep 23, 2014 at 9:41 AM, Todd Chapman wrote: > Hi, > > My application uses the Tomcat

Re: Debugging Tomcat JDBC pool disconnects.

2014-09-24 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA256 Todd, On 9/23/14 11:41 AM, Todd Chapman wrote: > My application uses the Tomcat JDBC pool. While using netstat and > tcpdump to diagnose connection problems I noticed that the client > side occasionally closes a DB connection and opens a new one. Th

Debugging Tomcat JDBC pool disconnects.

2014-09-23 Thread Todd Chapman
Hi, My application uses the Tomcat JDBC pool. While using netstat and tcpdump to diagnose connection problems I noticed that the client side occasionally closes a DB connection and opens a new one. That is unexpected based on my configuration. poolProperties.setInitialSize(10); po