JMS error
wikey Oct 26, 2004 10:51 PMHi,
I'm getting this error after change my hypersonic db connection to MS SQL. And i'm using jboss 4.0.0
I've search the forum for hours but no luck found. Pls help
MS SQL data source Snipet
=================
<local-tx-datasource>
<jndi-name>MSSQLDS</jndi-name>
<connection-url>jdbc:microsoft:sqlserver://192.168.0.11:1433;SelectMethod=cursor;DatabaseName=JMS_MESSAGES</connection-url>
<driver-class>com.microsoft.jdbc.sqlserver.SQLServerDriver</driver-class>
<user-name>sa</user-name>
boogiewoogiedd
<!-- sql to call when connection is created
<new-connection-sql>some arbitrary sql</new-connection-sql>
-->
<!-- sql to call on an existing pooled connection when it is obtained from pool
<check-valid-connection-sql>some arbitrary sql</check-valid-connection-sql>
-->
<!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml (optional) -->
<type-mapping>MS SQLSERVER2000</type-mapping>
</local-tx-datasource>
Error
===
10:42:06,203 ERROR [StdServerSession] failed to commit/rollback
org.jboss.tm.JBossRollbackException: Unable to commit, tx=TransactionImpl:XidImp
l[FormatId=257, GlobalId=n2nalliancetest/18, BranchQual=, localId=18] status=STA
TUS_NO_TRANSACTION; - nested throwable: (org.jboss.mq.SpyXAException: - nested t
hrowable: (org.jboss.mq.SpyTransactionRolledBackException: Transaction was rolle
d back.; - nested throwable: (org.jboss.mq.SpyJMSException: Could not mark the m
essage as deleted in the database: update affected 0 rows)))
at org.jboss.tm.TransactionImpl.commit(TransactionImpl.java:344)
at org.jboss.tm.TxManager.commit(TxManager.java:200)
at org.jboss.jms.asf.StdServerSession.onMessage(StdServerSession.java:34
1)
at org.jboss.mq.SpyMessageConsumer.sessionConsumerProcessMessage(SpyMess
ageConsumer.java:877)
at org.jboss.mq.SpyMessageConsumer.addMessage(SpyMessageConsumer.java:15
9)
at org.jboss.mq.SpySession.run(SpySession.java:351)
at org.jboss.jms.asf.StdServerSession.run(StdServerSession.java:180)
at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(PooledExec
utor.java:743)
at java.lang.Thread.run(Thread.java:595)
Caused by: org.jboss.mq.SpyXAException: - nested throwable: (org.jboss.mq.SpyTra
nsactionRolledBackException: Transaction was rolled back.; - nested throwable: (
org.jboss.mq.SpyJMSException: Could not mark the message as deleted in the datab
ase: update affected 0 rows))
at org.jboss.mq.SpyXAResource.prepare(SpyXAResource.java:135)
at org.jboss.tm.TransactionImpl$Resource.prepare(TransactionImpl.java:21
00)
at org.jboss.tm.TransactionImpl.prepareResources(TransactionImpl.java:15
52)
at org.jboss.tm.TransactionImpl.commit(TransactionImpl.java:319)
... 8 more
Caused by: org.jboss.mq.SpyTransactionRolledBackException: Transaction was rolle
d back.; - nested throwable: (org.jboss.mq.SpyJMSException: Could not mark the m
essage as deleted in the database: update affected 0 rows)
at org.jboss.mq.server.JMSDestinationManager.transact(JMSDestinationMana
ger.java:478)
at org.jboss.mq.server.JMSServerInterceptorSupport.transact(JMSServerInt
erceptorSupport.java:186)
at org.jboss.mq.security.ServerSecurityInterceptor.transact(ServerSecuri
tyInterceptor.java:182)
at org.jboss.mq.server.TracingInterceptor.transact(TracingInterceptor.ja
va:438)
at org.jboss.mq.server.JMSServerInvoker.transact(JMSServerInvoker.java:1
86)
at org.jboss.mq.il.jvm.JVMServerIL.transact(JVMServerIL.java:327)
at org.jboss.mq.Connection.send(Connection.java:1213)
at org.jboss.mq.SpyXAResourceManager.prepare(SpyXAResourceManager.java:2
08)
at org.jboss.mq.SpyXAResource.prepare(SpyXAResource.java:131)
... 11 more
Caused by: org.jboss.mq.SpyJMSException: Could not mark the message as deleted i
n the database: update affected 0 rows
at org.jboss.mq.pm.jdbc2.PersistenceManager.remove(PersistenceManager.ja
va:1062)
at org.jboss.mq.server.BasicQueue.acknowledge(BasicQueue.java:536)
at org.jboss.mq.server.JMSTopic.acknowledge(JMSTopic.java:290)
at org.jboss.mq.server.ClientConsumer.acknowledge(ClientConsumer.java:32
2)
at org.jboss.mq.server.JMSDestinationManager.acknowledge(JMSDestinationM
anager.java:524)
at org.jboss.mq.server.JMSDestinationManager.transact(JMSDestinationMana
ger.java:469)
... 19 more
10:42:09,171 WARN [TransactionImpl] XAException: tx=TransactionImpl:XidImpl[For
matId=257, GlobalId=n2nalliancetest/17, BranchQual=, localId=17] errorCode=XAER_
RMERR
org.jboss.mq.SpyXAException: - nested throwable: (org.jboss.mq.SpyTransactionRol
ledBackException: Transaction was rolled back.; - nested throwable: (org.jboss.m
q.SpyJMSException: Could not mark the message as deleted in the database: update
affected 0 rows))
at org.jboss.mq.SpyXAResource.prepare(SpyXAResource.java:135)
at org.jboss.tm.TransactionImpl$Resource.prepare(TransactionImpl.java:21
00)
at org.jboss.tm.TransactionImpl.prepareResources(TransactionImpl.java:15
52)
at org.jboss.tm.TransactionImpl.commit(TransactionImpl.java:319)
at org.jboss.tm.TxManager.commit(TxManager.java:200)
at org.jboss.jms.asf.StdServerSession.onMessage(StdServerSession.java:34
1)
at org.jboss.mq.SpyMessageConsumer.sessionConsumerProcessMessage(SpyMess
ageConsumer.java:877)
at org.jboss.mq.SpyMessageConsumer.addMessage(SpyMessageConsumer.java:15
9)
at org.jboss.mq.SpySession.run(SpySession.java:351)
at org.jboss.jms.asf.StdServerSession.run(StdServerSession.java:180)
at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(PooledExec
utor.java:743)
at java.lang.Thread.run(Thread.java:595)
Caused by: org.jboss.mq.SpyTransactionRolledBackException: Transaction was rolle
d back.; - nested throwable: (org.jboss.mq.SpyJMSException: Could not mark the m
essage as deleted in the database: update affected 0 rows)
at org.jboss.mq.server.JMSDestinationManager.transact(JMSDestinationMana
ger.java:478)
at org.jboss.mq.server.JMSServerInterceptorSupport.transact(JMSServerInt
erceptorSupport.java:186)
at org.jboss.mq.security.ServerSecurityInterceptor.transact(ServerSecuri
tyInterceptor.java:182)
at org.jboss.mq.server.TracingInterceptor.transact(TracingInterceptor.ja
va:438)
at org.jboss.mq.server.JMSServerInvoker.transact(JMSServerInvoker.java:1
86)
at org.jboss.mq.il.jvm.JVMServerIL.transact(JVMServerIL.java:327)
at org.jboss.mq.Connection.send(Connection.java:1213)
at org.jboss.mq.SpyXAResourceManager.prepare(SpyXAResourceManager.java:2
08)
at org.jboss.mq.SpyXAResource.prepare(SpyXAResource.java:131)
... 11 more
Caused by: org.jboss.mq.SpyJMSException: Could not mark the message as deleted i
n the database: update affected 0 rows
at org.jboss.mq.pm.jdbc2.PersistenceManager.remove(PersistenceManager.ja
va:1062)
at org.jboss.mq.server.BasicQueue.acknowledge(BasicQueue.java:536)
at org.jboss.mq.server.JMSTopic.acknowledge(JMSTopic.java:290)
at org.jboss.mq.server.ClientConsumer.acknowledge(ClientConsumer.java:32
2)
at org.jboss.mq.server.JMSDestinationManager.acknowledge(JMSDestinationM
anager.java:524)
at org.jboss.mq.server.JMSDestinationManager.transact(JMSDestinationMana
ger.java:469)
... 19 more
10:42:09,171 ERROR [StdServerSession] failed to commit/rollback
org.jboss.tm.JBossRollbackException: Unable to commit, tx=TransactionImpl:XidImp
l[FormatId=257, GlobalId=n2nalliancetest/17, BranchQual=, localId=17] status=STA
TUS_NO_TRANSACTION; - nested throwable: (org.jboss.mq.SpyXAException: - nested t
hrowable: (org.jboss.mq.SpyTransactionRolledBackException: Transaction was rolle
d back.; - nested throwable: (org.jboss.mq.SpyJMSException: Could not mark the m
essage as deleted in the database: update affected 0 rows)))
at org.jboss.tm.TransactionImpl.commit(TransactionImpl.java:344)
at org.jboss.tm.TxManager.commit(TxManager.java:200)
at org.jboss.jms.asf.StdServerSession.onMessage(StdServerSession.java:34
1)
at org.jboss.mq.SpyMessageConsumer.sessionConsumerProcessMessage(SpyMess
ageConsumer.java:877)
at org.jboss.mq.SpyMessageConsumer.addMessage(SpyMessageConsumer.java:15
9)
at org.jboss.mq.SpySession.run(SpySession.java:351)
at org.jboss.jms.asf.StdServerSession.run(StdServerSession.java:180)
at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(PooledExec
utor.java:743)
at java.lang.Thread.run(Thread.java:595)
Caused by: org.jboss.mq.SpyXAException: - nested throwable: (org.jboss.mq.SpyTra
nsactionRolledBackException: Transaction was rolled back.; - nested throwable: (
org.jboss.mq.SpyJMSException: Could not mark the message as deleted in the datab
ase: update affected 0 rows))
at org.jboss.mq.SpyXAResource.prepare(SpyXAResource.java:135)
at org.jboss.tm.TransactionImpl$Resource.prepare(TransactionImpl.java:21
00)
at org.jboss.tm.TransactionImpl.prepareResources(TransactionImpl.java:15
52)
at org.jboss.tm.TransactionImpl.commit(TransactionImpl.java:319)
... 8 more
Caused by: org.jboss.mq.SpyTransactionRolledBackException: Transaction was rolle
d back.; - nested throwable: (org.jboss.mq.SpyJMSException: Could not mark the m
essage as deleted in the database: update affected 0 rows)
at org.jboss.mq.server.JMSDestinationManager.transact(JMSDestinationMana
ger.java:478)
at org.jboss.mq.server.JMSServerInterceptorSupport.transact(JMSServerInt
erceptorSupport.java:186)
at org.jboss.mq.security.ServerSecurityInterceptor.transact(ServerSecuri
tyInterceptor.java:182)
at org.jboss.mq.server.TracingInterceptor.transact(TracingInterceptor.ja
va:438)
at org.jboss.mq.server.JMSServerInvoker.transact(JMSServerInvoker.java:1
86)
at org.jboss.mq.il.jvm.JVMServerIL.transact(JVMServerIL.java:327)
at org.jboss.mq.Connection.send(Connection.java:1213)
at org.jboss.mq.SpyXAResourceManager.prepare(SpyXAResourceManager.java:2
08)
at org.jboss.mq.SpyXAResource.prepare(SpyXAResource.java:131)
... 11 more
Caused by: org.jboss.mq.SpyJMSException: Could not mark the message as deleted i
n the database: update affected 0 rows
at org.jboss.mq.pm.jdbc2.PersistenceManager.remove(PersistenceManager.ja
va:1062)
at org.jboss.mq.server.BasicQueue.acknowledge(BasicQueue.java:536)
at org.jboss.mq.server.JMSTopic.acknowledge(JMSTopic.java:290)
at org.jboss.mq.server.ClientConsumer.acknowledge(ClientConsumer.java:32
2)
at org.jboss.mq.server.JMSDestinationManager.acknowledge(JMSDestinationM
anager.java:524)
at org.jboss.mq.server.JMSDestinationManager.transact(JMSDestinationMana
ger.java:469)
... 19 more