[jboss-user] [Messaging, JMS & JBossMQ] - error when using persistent JBossMQ with MSSql

[chen7058]

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)

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

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