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.

http://forums.oracle.com/forums/message.jspa?messageID=4144460#4144460

Thanks
R Vashi


2 thoughts on “Connection Pool issue on weblogic…

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s