Issue:
weblogic.jdbc.extensions.PoolLimitSQLException: weblogic.common.resourcepool.ResourceLimitException: No resources currently available in pool <POOL_NAME> to allocate to applications, please increase the size of the pool and retry..
Cause:
This issue is due to leaked connection that was not properly returned to the connection pool in the data source.
Solution:
Please follow the below step to fix this issue.
1. Login to WLS Admin Console.
2. Go to “Data Sources”
3. Search the Data Source Name (you want to change for) and click on Data Source.
4.Click on “Configure a Connection Pool”.
5. Expand the “Advanced” Tab.
6. Update the “Inactive Connection Timeout” to the desired value.
For example: Inactive Connection Timeout = 900 (15 minutes)
Note:
This requires a restart of the servers after making changes to “Inactive Connection Timeout”.
Restart is required for only those specific servers where this data source is targeted to.
