2 Replies Latest reply on Mar 13, 2003 11:34 PM by David Jencks

    Database connections not closing for MDB -> CMP

    Bobby Newbie

      Help, I'm using JBOSS 3.0.4 with Sybase, Using CMP my database connections are not being closed. One is opened for every CMP bean that I use during method call, and stays open causing the number of connections to hit the maxSize too quickly. One method uses 10 CMP beans, I would expect JBoss to use one connection for the one call, or atleast put the connections back into the pool when done. The CMP beans are being accessed through session beans who are being accessed through a MessageDrivenBean. Any help is appreciated.

      Below is the pool's configuration and the top piece of a stack trace:

      <depends optional-attribute-name="ManagedConnectionPool">
      <!--embedded mbean-->


      18:24:16,042 ERROR [STDERR] org.jboss.util.NestedSQLException: No ManagedConnections Available!; - nested throwable: (javax.resource.ResourceException: No ManagedConnections Available!)
      18:24:16,042 ERROR [STDERR] at org.jboss.resource.adapter.jdbc.local.LocalDataSource.getConnection(LocalDataSource.java:106)
      18:24:16,052 ERROR [STDERR] at navy.edss.server.ServerUtilities.getConnection