aspose file tools*
The moose likes BEA/Weblogic and the fly likes weblogic.jdbc.extensions.PoolLimitSQLException:  No resources currently available in pool Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » BEA/Weblogic
Bookmark "weblogic.jdbc.extensions.PoolLimitSQLException:  No resources currently available in pool " Watch "weblogic.jdbc.extensions.PoolLimitSQLException:  No resources currently available in pool " New topic
Author

weblogic.jdbc.extensions.PoolLimitSQLException: No resources currently available in pool

Ash Kondhalkar
Ranch Hand

Joined: Jun 14, 2006
Posts: 43
Hi,

I am using Oracle driver for connection in datasource in Weblogic 10.3 in my application. I am getting the below exception after I do the search activity number of times ,which uses the connection in this datasource to run a Stored procedure.

weblogic.jdbc.extensions.PoolLimitSQLException: weblogic.common.resourcepool.ResourceLimitException: No resources currently available in pool

I have checked my code thouroughly and there is no connection leak. The connection is closed properly in all possible scneario's. I have verified the same by running the application and then checking the log file immediately.
The initialcapacity and maxcapacity of the datasource is 1 and 15 respectively. After I get the above exception, if I check the weblogic console, I find in the left bottom corner a window "System status", which has links like "Failed", "Critical", "Overloaded", "Warning" and "Ok". When I clicked on the "Overloaded" link it shown below,

"JDBC Overloaded Connection Pool Name = null:null:OracleCSIDataSource, State = Overloaded "!

Thanks & Regards
Ashwin
Joseph Antoine Raja
Ranch Hand

Joined: Feb 01, 2010
Posts: 32
Hi Ashwin,

when the application is making too much call to DB and the DB connections are not released then comes the OVERLOADED issue.

But WL 9 and above versions of the servers having some control functions to connection pools

So you can stop the connection pool, refresh it and restart it again

to do this

go to

Services->Data Sources-><select the particular Data source> -> Control

this will shows the conditions of the Data source in all servers it has been targeted. Now check the respective server with overloaded issue and do STOP - CLEAR THE CONNECTION CACHE -- START

this is only a workaround. for complete resolution you have to monitor the DB usage and according to that you have to tune the connection pool parameters.


 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: weblogic.jdbc.extensions.PoolLimitSQLException: No resources currently available in pool