3 Replies Latest reply on Aug 19, 2002 4:08 AM by pindakaas

    'No ManagedConnections Available' MySQL/JBoss2.4.8

    pindakaas

      A verrry frustrating problem. I'm a newby concerning JBoss by the way. I get the following error when trying to startup JBoss (for an EJB app):

      [snippet]
      ...
      java.lang.RuntimeException: No ManagedConnections Available!
      ...

      [some more]
      [14:48:41,553,JdbcProvider] Starting
      [14:48:41,553,JdbcProvider] Started
      [14:48:41,553,mySportlifePool] Starting
      [14:48:41,569,XAPoolDataSource] Creating XA Pool
      [14:48:41,631,mySportlifePool] setGCInterval(0)
      [14:48:41,662,mySportlifePool] setGCMinIdleTime(0)
      [14:48:41,662,mySportlifePool] setIdleTimeout(0)
      [14:48:41,662,mySportlifePool] setTimestampUsed(false)
      [14:48:41,662,XAConnectionFactory] Starting
      [14:48:41,662,ObjectPool] Adding pool: mySportlifePool, GC enabled: false
      [14:48:41,678,mySportlifePool] XA Connection pool mySportlifePool bound to java:/mySportlifePool
      [14:48:41,678,XAPoolDataSource] Closing DataSource
      [14:48:41,678,XAPoolDataSource] Binding to JNDI name null
      [14:48:41,678,ObjectPool] Removing pool: mySportlifePool
      [14:48:41,678,mySportlifePool] Stopped
      java.lang.RuntimeException: No ManagedConnections Available!
      at org.jboss.pool.ObjectPool.getObject(ObjectPool.java:687)
      at org.jboss.pool.jdbc.xa.XAPoolDataSource.getConnection(XAPoolDataSource.java:227)
      at org.jboss.jdbc.XADataSourceLoader.startService(XADataSourceLoader.java:415)
      at org.jboss.util.ServiceMBeanSupport.start(ServiceMBeanSupport.java:103)
      at java.lang.reflect.Method.invoke(Native Method)
      at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)
      at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
      at org.jboss.configuration.ConfigurationService$ServiceProxy.invoke(ConfigurationService.java:967)
      at $Proxy0.start(Unknown Source)
      at org.jboss.util.ServiceControl.start(ServiceControl.java:79)
      at java.lang.reflect.Method.invoke(Native Method)
      at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)
      at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
      at org.jboss.Main.(Main.java:209)
      at org.jboss.Main$1.run(Main.java:110)
      at java.security.AccessController.doPrivileged(Native Method)
      at org.jboss.Main.main(Main.java:106)
      [14:48:41,678,ConfigurationService] Unexpected error
      java.lang.RuntimeException: No ManagedConnections Available!

      Does anyone know what I did wrong or forgot to do?

      Grtz

      Coen

        • 1. Re: 'No ManagedConnections Available' MySQL/JBoss2.4.8
          gsuzor

          I'm also getting the exact same exception with 2.4.8. However the datasource (JSQLXADataSource) I'm using works fine with 2.4.7. The development team I'm on has been using JBoss since version 2.4.4, and we haven't encountered this problem until now. Any ideas of what's going on?

          • 2. Re: 'No ManagedConnections Available' MySQL/JBoss2.4.8
            gsuzor

            It appears that setting the "MaxSize" attribute of the datasource to something other than the default value of 0 fixes this problem for JBoss-2.4.8. According to the documentation for JBoss-2.4.5, so this may be outdated, a MaxSize of 0 indicates an unlimited pool size. It appears that this doesn't hold anymore. Is this expected behavior or a bug?

            • 3. Re: 'No ManagedConnections Available' MySQL/JBoss2.4.8
              pindakaas

              It worked! No more exceptions...

              I suppose it's a bug: a default value should not create an error, if it's expected I, in turn, expect a clear error message and not an exception. But,that's just me, I'm happy enough to have this cleared...