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