I am using Apache-Tomcat integration using mod_jk2 and using common DBCP for the database connection pool. I am running a java application on the Tomcat server. Apache server just routes request to Tomcat. All application code runs on Tomcat server. It runs fine for couple of day but after that my application stops responding to any requests. This means that when I try to access servlet on my application, it takes forever to process the request which never comes back. I see following errors in my custom logs
ConnectionBean.releaseConnection Error: java.sql.SQLException: Connection is closed.
My data source properties for commons DB CP are
JdBC Driver Class = oracle.jdbc.driver.OracleDriver
Maximum Active Connection = 20
Maximum Idle connection = 10
Max wait for Connection = -1
I have made sure than I am closing a connection after opening it. Could you please advise what could be wrong? Is it a configuration issue or coding issue?