Re: Debugging Tomcat JDBC pool disconnects.

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

Re: Debugging Tomcat JDBC pool disconnects.

On Tue, Oct 7, 2014 at 8:41 PM, Todd Chapman t...@chaka.net 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

Re: Debugging Tomcat JDBC pool disconnects.

Aniket, That change had not been committed yet. -Todd On Tuesday, October 7, 2014, Aniket Bhoi aniket.b...@gmail.com wrote: On Tue, Oct 7, 2014 at 8:41 PM, Todd Chapman t...@chaka.net javascript:; wrote: Chris, Thank you for the detailed reply and sorry for my delayed response. We

Re: Debugging Tomcat JDBC pool disconnects.

-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. That

Re: Debugging Tomcat JDBC pool disconnects.

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 t...@chaka.net wrote: Hi, My application

Debugging Tomcat JDBC pool disconnects.

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);