Tomcat JDBC pool - too many connections in TIME_WAIT state

[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 pp = new PoolProperties();

            String connprops =
"oracle.net.CONNECT_TIMEOUT=3000;oracle.jdbc.ReadTimeout=3000;oracle.net.READ_TIMEOUT=3000";

            pp.setUsername(user);
            pp.setPassword(pass);
            pp.setConnectionProperties(connprops);

            pp.setDriverClassName("oracle.jdbc.OracleDriver");

            pp.setTestOnBorrow(true);
            pp.setTestOnConnect(true);

            pp.setTestWhileIdle(true);

            pp.setMaxWait(1000);
            pp.setMinEvictableIdleTimeMillis(10000);
            pp.setTimeBetweenEvictionRunsMillis(5000);

            pp.setValidationInterval(10000);
            pp.setValidationQuery("SELECT 1 FROM DUAL");

            pp.setRemoveAbandoned(true);
            pp.setRemoveAbandonedTimeout(5);

pp.setJdbcInterceptors("org.apache.tomcat.jdbc.pool.interceptor.QueryTimeoutInterceptor(queryTimeout=3)");
            dataSource = new DataSource();
            dataSource.setPoolProperties(pp);

Thank you in advance!