[jboss-user] [Messaging, JMS & JBossMQ] - JBossMQ message persistence with SQLServer (Urgent help)

[chen7058]

Sorry to bring it up again, I have not been able to resolved it.

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)

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3984664#3984664

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3984664