Few moths back I have started facing problem with my connection pool, where intermittent message like “pool out of resource.. increase the pool size…” started coming in app UI, logs, causing issues with application functionality. To avoid that we thought of connection validation on Weblogic, by enabling “Test Connection on Reserve” but the real problem came just right after that when we started facing below error message in server logs.
<BEA-001112> <Test “SELECT 1 FROM DUAL” set up for pool “MyPool” failed with exception: “java.sql.SQLException: Closed Statement”.>
In our application we were using Oracle proxy connections. and then I came to know about one real fact of using Proxy connections on Weblogic. So i would like to share the same discussion with you all, hope this helps in case if you are struggling with the same.