Cannot Allocate a Connection From The GlassFish Server JDBC Connection Pool Due To In-use Connections Equal max-pool-size (Doc ID 1473945.1)

Symptoms

The application server log contains errors similar to the following, though the error stacks will be application/customer specific and they have been truncated for clarity:

In the above error stack the highlighted lines indicate where in the application's code the connection is being allocated from.  The top of the stack is not relevant as that simply shows the steps in the application server needed to find and return a connection to the application.  Therefore, in this example, the application/customer specific code in the com.acme.jdbc.common.DBManager.establishConnection() and com.acme.jdbc.common.DBManager.deleteOldDetails() methods would need to be investigated to determine if there is any problems with the JDBC resource handling. 

If no "potential connection leak" messages are seen then the likelihood is you have insufficient capacity configured for your workload.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.