1 Reply Latest reply on Oct 26, 2006 1:59 PM by Elias Ross

    error when using persistent JBossMQ with MSSql

    John Chen Newbie

      Hi,

      I am trying to use SQLServer as the persistent storage for JBossMQ. At the very first time, I could start my JBoss server without problem, and I saw JMS_Message and other table created in my database and messages persisted in the table. But when I shut down JBoss server and tried to restart it again, I got the following error, anybody can help me please ?

      Thanks

      John

      2006-10-25 22:07:20,156 WARN [org.jboss.tm.TransactionImpl] XAException: tx=TransactionImpl:XidImpl[FormatId=257, GlobalId=JohnChen/1, BranchQual=, localId=1] errorCode=XA_UNKNOWN(0)
      org.jboss.resource.connectionmanager.JBossLocalXAException: could not commit local tx; - nested throwable: (org.jboss.resource.JBossResourceException: SQLException; - nested throwable: (com.microsoft.sqlserver.jdbc.SQLServerException: The COMMIT TRANSACTION request has no corresponding BEGIN TRANSACTION.))
      at org.jboss.resource.connectionmanager.TxConnectionManager$LocalXAResource.commit(TxConnectionManager.java:947)
      at org.jboss.tm.TransactionImpl$Resource.commit(TransactionImpl.java:2233)
      at org.jboss.tm.TransactionImpl.commitResources(TransactionImpl.java:1764)
      at org.jboss.tm.TransactionImpl.commit(TransactionImpl.java:322)
      at org.jboss.tm.TxManager.commit(TxManager.java:224)
      at org.jboss.mq.pm.jdbc2.PersistenceManager$TransactionManagerStrategy.endTX(PersistenceManager.java:196)
      at org.jboss.mq.pm.jdbc2.PersistenceManager.createSchema(PersistenceManager.java:358)
      at org.jboss.mq.pm.jdbc2.PersistenceManager.startService(PersistenceManager.java:1491)
      at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:274)
      at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:230)
      at sun.reflect.GeneratedMethodAccessor2.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:324)
      at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
      at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
      at org.jboss.mx.server.Invocation.invoke(Invocation.java:72)
      at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:245)
      at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644)
      at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:943)
      at $Proxy0.start(Unknown Source)