users@glassfish.java.net

Problem allocating db connection - max connections in use

From: <glassfish_at_javadesktop.org>
Date: Thu, 04 Dec 2008 13:14:49 PST

I have an installed production system and it got into a state where it could not allocate more database connections. The application is a J2EE application as an EAR file. It uses Derby as the database and uses only JPA access to the database in a CMT. Here is the message from the server:

[#|2008-12-04T06:13:57.800-0500|WARNING|sun-appserver9.1|javax.enterprise.resource.resourceadapter|_ThreadID=33;_ThreadName=RDPConnectionEngineUDP;csemDatabasePool;In-use connections equal max-pool-size and expired max-wait-time. Cannot allocate more connections.;_RequestID=65d87038-0d81-4725-b4d8-7649f5af72d4;|RAR5117 : Failed to obtain/create connection from connection pool [ csemDatabasePool ]. Reason : In-use connections equal max-pool-size and expired max-wait-time. Cannot allocate more connections.|#]

I am not sure I understand the message or when this problem will occur so any help will be greatly appreciated.
[Message sent by forum member 'bbergquist' (bbergquist)]

http://forums.java.net/jive/thread.jspa?messageID=320149