users@glassfish.java.net

connection pool issues

From: Steve Black <seb_at_zmobilev.com>
Date: Sat, 16 Apr 2011 16:47:08 -0500

I have an application that has just recently moved to a distributed
environment. Since this has happened the application has been experiencing
connection pool issues.

I have gone through every DAO and verified the connection is closed, and
have tried the autoReconnectForPools option to attempt resolve the issue,
but with no result.

Below is a piece of the log from a point in time where one of the boxes got
into an error state.

Thank you in advance.

Steve

[#|2011-04-16T09:36:28.536-0500|WARNING|glassfish3.0.1|javax.enterprise.resource.resourceadapter.com.sun.enterprise.connectors|_ThreadID=99;_ThreadName=Thread-1;|RAR5117
: Failed to obt
ain/create connection from connection pool [ WowponMySQLPool ]. Reason :
com.sun.appserv.connectors.internal.api.PoolingException: In-use connections
equal max-pool-size and expired max
-wait-time. Cannot allocate more connections.|#]

[#|2011-04-16T09:36:28.536-0500|WARNING|glassfish3.0.1|javax.enterprise.resource.resourceadapter.com.sun.gjc.spi|_ThreadID=99;_ThreadName=Thread-1;|RAR5114
: Error allocating connection
 : [Error in allocating a connection. Cause: In-use connections equal
max-pool-size and expired max-wait-time. Cannot allocate more
connections.]|#]
[#|2011-04-16T09:36:30.131-0500|WARNING|glassfish3.0.1|javax.enterprise.resource.resourceadapter.com.sun.enterprise.connectors|_ThreadID=98;_ThreadName=Thread-1;|RAR5117
: Failed to obt
ain/create connection from connection pool [ WowponMySQLPool ]. Reason :
com.sun.appserv.connectors.internal.api.PoolingException: In-use connections
equal max-pool-size and expired max
-wait-time. Cannot allocate more connections.|#]
[#|2011-04-16T09:36:30.131-0500|WARNING|glassfish3.0.1|javax.enterprise.resource.resourceadapter.com.sun.gjc.spi|_ThreadID=98;_ThreadName=Thread-1;|RAR5114
: Error allocating connection
 : [Error in allocating a connection. Cause: In-use connections equal
max-pool-size and expired max-wait-time. Cannot allocate more
connections.]|#]