Connection Pool Overflow..Deadlock in Weblogic 8.1
Hi All,
I am working on an Application which is deployed on a clustered environment with 3 Weblogic Application Servers. The Number of connection pools for each Server is 5, hence in total of 15 connection pools are there for the Application, and the cache size is 10.
When a particular functionality of the Application is used for 5-6 times, it throws the following error..
weblogic.common.resourcepool.ResourceLimitException: No resources currently available in pool XYZ to allocate to applications, please increase the size of the pool and retry..@MyClass.mymethod()
After investigation, it was found that all the connections were in use and there was a deadlock, no more connections to allocate.
After resetting the connections, the same thing is repeating.
When i checked in the code, all the connections have been closed in the finally block. I also monitored the connections in the console (on the local environment), and that particular method was using a max of 2 connections and they were released, soon after the page returns back.
Can somebody help me out to resolve this issue?
Thanks in advance.
Rgds,
Aakash & Raju

