Re: Tomcat JDBC pool - too many connections in TIME_WAIT state

2014-11-05 Thread Vasily Kukhta
/tcp_fin_timeout > > > On Wed, Nov 5, 2014 at 7:36 AM, Daniel Mikusa wrote: > > > On Wed, Nov 5, 2014 at 9:13 AM, Vasily Kukhta > > wrote: > > > > > Hello all! > > > > > > I have developed an application using Tomcat JDBC pool. Eve

Tomcat JDBC pool - too many connections in TIME_WAIT state

2014-11-05 Thread Vasily Kukhta
Hello all! I have developed an application using Tomcat JDBC pool. Everything is fine except that the pool leaves hundreds of TCP connections in TIME_WAIT state, which kills the server sooner or later... Could you please suggest what to fix, my configuration is below: PoolProperties p

Tomcat JDBC pool - auto reconnect

2014-10-10 Thread Vasily Kukhta
Best regards, Vasily Kukhta.

Re: Query timeouts using tomcat jdbc pool

2014-07-23 Thread Vasily Kukhta
; exception. > > > Filip > > > > > On Wed, Jul 23, 2014 at 10:04 AM, Vasily Kukhta > wrote: > > > Thank you, I have changed timeBetweenEvictionRunsMillis value and it is > > working properly now. Another problem has appeared: although the timeout > is >

Re: Query timeouts using tomcat jdbc pool

2014-07-23 Thread Vasily Kukhta
all in that situation? Than you! 2014-07-21 20:40 GMT+04:00 Daniel Mikusa : > On Mon, Jul 21, 2014 at 11:05 AM, Vasily Kukhta > wrote: > > > Hello, dear tomcat users! > > > > I am developing high-load application using tomcat jdbc connection pool > and > > O

Query timeouts using tomcat jdbc pool

2014-07-21 Thread Vasily Kukhta
Hello, dear tomcat users! I am developing high-load application using tomcat jdbc connection pool and Oracle database. It is very important to ensure my app to have very small DB query timeouts (no longer than 3 seconds) to prevent long-running queries or database slowness from blocking all my app