Connection Pool issue on weblogic…

Hi All,

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.

R Vashi

2 thoughts on “Connection Pool issue on weblogic…

Leave a Reply

Please log in using one of these methods to post your comment: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.