title: Oracle Connection closed
body: <p>I have a Java web application, that uses Apache DBCP to connect to an Oracle DB. The connection is done using JNDI. In my application, I need to run a a query to the database, process the results and then save the updates. <br/>
  The problem is that no matter what properties I set for the db connection parameters (maxWait, minEvictableIdleTimeMillis, testOnBorrow, etc - I have tried all of them with different values), I always receive back a "connection closed" error, after aprox. 2.5 min. The result set I process is large, and the execution takes longer than 2.5 mins, but even if I do the paginated query, to hit the database often, I still get the same error. 
  Another strange thing is that, no matter what value I set for the connection pool size (with maxActive, maxIdle, initialSize), if I log the max physical open connections the value is 1. 
  Do you have any idea why this happens? Could this be caused by a setting on DB / network side? </p>