0 Replies Latest reply on Oct 26, 2004 10:51 PM by wikey wikey

    JMS error

    wikey wikey Newbie

      Hi,

      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