ResourceLimitException and JBO-36061: Error while opening JDBC connection. (Doc ID 1218335.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle JDeveloper - Version 11.1.1.0.0 to 11.1.1.3.0
Information in this document applies to any platform.
***Checked for relevance on 22-FEB-2013***

Symptoms

You created an ADF Faces/BC (Business Application) in JDeveloper 11g.
The first users who connect to the application can work without any problem, but when the load increases, users get the following errors:

weblogc.common.resourcepool.ResourceLimitException: No resources currently available in pool <pool-name> to allocate to applications, please increase the size of the pool and retry..

and

JBO-36061: Error while opening JDBC connection.
For more information, please see the server's error log, for an entry beginning with Server Exception during PPR, #2

displayed in 2 different browser dialogs.

The connection pool seems to fail to reuse connections.

The WLS log files includes the following error:

Reached maximum capacity of pool "<pool-name>", making "0" new resource instances instead of "1".

but it doesn't include the JBO:36061 error.

This happens when using ADF Faces pages with backing beans using the  createRootApplicationModule() API (in the oracle.jbo.client.Configuration class) to acquire a new application module from the pool.
This is done to call DB stored procedures.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms