[jboss-user] [Messaging, JMS & JBossMQ] - error when using persistent JBossMQ with MSSql
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#...
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...