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

[Ash Kondhalkar]

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]

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.