0 Replies Latest reply on Mar 12, 2003 7:59 AM by Bobby

    Database connections not closing for 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.
      Thanks

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

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

      0
      20
      5000
      15
      ByContainer



      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