1 Reply Latest reply on Dec 2, 2003 11:00 PM by ace750usa

    MSSQL DS on jboss 2.4.3

    ace750usa

      Hello Everyone,

      I relize that i am talking about a really old version of JBOSS, however, i was hoping that someone would be be able to help me out.

      this is my setting in jboss.jcml


      <!--com.microsoft.jdbc.sqlserver.SQLServerDriver -->
      com.microsoft.jdbcx.sqlserver.SQLServerDataSource


      <!-- org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl -->
      org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl
      jdbc/WBTPCDataSource
      jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=db_name;SelectMethod=Cursor
      user
      password
      3


      this is the error that i get:

      [INFO,jdbc/WBTPCDataSource] Starting
      [INFO,jdbc/WBTPCDataSource] XA Connection pool jdbc/WBTPCDataSource bound to java:/jdbc/WBTPCDataSource
      [ERROR,jdbc/WBTPCDataSource] 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:242)
      at org.jboss.jdbc.XADataSourceLoader.startService(XADataSourceLoader.java:445)
      at org.jboss.util.ServiceMBeanSupport.start(ServiceMBeanSupport.java:103)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
      at java.lang.reflect.Method.invoke(Unknown Source)
      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 sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
      at java.lang.reflect.Method.invoke(Unknown Source)
      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)
      [ERROR,ConfigurationService] Unexpected error
      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:242)
      at org.jboss.jdbc.XADataSourceLoader.startService(XADataSourceLoader.java:445)
      at org.jboss.util.ServiceMBeanSupport.start(ServiceMBeanSupport.java:103)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
      at java.lang.reflect.Method.invoke(Unknown Source)
      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 sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
      at java.lang.reflect.Method.invoke(Unknown Source)
      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


      what does this mean?