4 Replies Latest reply on Nov 20, 2003 12:58 AM by Elias Ross

    ClassCastException in statement INSERT INTO JMS_TRANSACTIONS

    isotope1145 Newbie

      I am getting the exception below from the JMSServer. I think it happens after the message has been processed.

      I am running jboss-3.2.2 with JDK 1.4.2

      Any ideas? How do I debug this?

      java.lang.ClassCastException
      at org.hsqldb.Column.compare(Unknown Source)
      at org.hsqldb.Index.compareRow(Unknown Source)
      at org.hsqldb.Index.insert(Unknown Source)
      at org.hsqldb.Table.indexRow(Unknown Source)
      at org.hsqldb.Table.insertNoCheck(Unknown Source)
      at org.hsqldb.Table.insert(Unknown Source)
      at org.hsqldb.Parser.processInsert(Unknown Source)
      at org.hsqldb.Database.execute(Unknown Source)
      at org.hsqldb.jdbcConnection.executeStandalone(Unknown Source)
      at org.hsqldb.jdbcConnection.execute(Unknown Source)
      at org.hsqldb.jdbcStatement.fetchResult(Unknown Source)
      at org.hsqldb.jdbcStatement.executeUpdate(Unknown Source)
      at org.hsqldb.jdbcPreparedStatement.executeUpdate(Unknown Source)
      at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:321)
      at org.jboss.mq.pm.jdbc2.PersistenceManager.createPersistentTx(PersistenceManager.java:660)
      at org.jboss.mq.pm.TxManager.createTx(TxManager.java:79)
      at org.jboss.mq.server.JMSDestinationManager.transact(JMSDestinationManager.java:424)
      at org.jboss.mq.server.JMSServerInterceptorSupport.transact(JMSServerInterceptorSupport.java:186)
      at org.jboss.mq.server.TracingInterceptor.transact(TracingInterceptor.java:438)
      at org.jboss.mq.server.JMSServerInvoker.transact(JMSServerInvoker.java:186)
      at org.jboss.mq.il.jvm.JVMServerIL.transact(JVMServerIL.java:328)
      at org.jboss.mq.Connection.send(Connection.java:928)
      at org.jboss.mq.SpyXAResourceManager.commit(SpyXAResourceManager.java:127)
      at org.jboss.mq.SpyXAResource.commit(SpyXAResource.java:103)
      at org.jboss.jms.asf.StdServerSession.onMessage(StdServerSession.java:307)
      at org.jboss.mq.SpyMessageConsumer.sessionConsumerProcessMessage(SpyMessageConsumer.java:633)
      at org.jboss.mq.SpyMessageConsumer.addMessage(SpyMessageConsumer.java:433)
      at org.jboss.mq.SpySession.run(SpySession.java:298)
      at org.jboss.jms.asf.StdServerSession.run(StdServerSession.java:180)
      at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(PooledExecutor.java:727)
      14:22:27,148 WARN [NestedThrowable] Duplicate throwable nesting of same base type: class org.jboss.mq.SpyJMSException is assignable from: class org.jboss.mq.SpyJMSException
      14:22:27,148 ERROR [StdServerSession] failed to commit/rollback
      org.jboss.mq.SpyXAException: - nested throwable: (org.jboss.mq.SpyJMSException: Cannot process a transaction; - nested throwable: (org.jboss.mq.SpyJMSException: Could not crate tx: 3; - nested throwable: (java.sql.SQLException: S1000 General error java.lang.ClassCastException in statement [INSERT INTO JMS_TRANSACTIONS (TXID) values(3)])))
      at org.jboss.mq.SpyXAResource.commit(SpyXAResource.java:105)
      at org.jboss.jms.asf.StdServerSession.onMessage(StdServerSession.java:307)
      at org.jboss.mq.SpyMessageConsumer.sessionConsumerProcessMessage(SpyMessageConsumer.java:633)
      at org.jboss.mq.SpyMessageConsumer.addMessage(SpyMessageConsumer.java:433)
      at org.jboss.mq.SpySession.run(SpySession.java:298)
      at org.jboss.jms.asf.StdServerSession.run(StdServerSession.java:180)
      at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(PooledExecutor.java:727)
      at java.lang.Thread.run(Thread.java:534)
      Caused by: org.jboss.mq.SpyJMSException: Cannot process a transaction; - nested throwable: (org.jboss.mq.SpyJMSException: Could not crate tx: 3; - nested throwable: (java.sql.SQLException: S1000 General error java.lang.ClassCastException in statement [INSERT INTO JMS_TRANSACTIONS (TXID) values(3)]))
      at org.jboss.mq.Connection.send(Connection.java:932)
      at org.jboss.mq.SpyXAResourceManager.commit(SpyXAResourceManager.java:127)
      at org.jboss.mq.SpyXAResource.commit(SpyXAResource.java:103)
      ... 7 more
      Caused by: org.jboss.mq.SpyJMSException: Could not crate tx: 3; - nested throwable: (java.sql.SQLException: S1000 General error java.lang.ClassCastException in statement [INSERT INTO JMS_TRANSACTIONS (TXID) values(3)])
      at org.jboss.mq.pm.jdbc2.PersistenceManager.createPersistentTx(PersistenceManager.java:666)
      at org.jboss.mq.pm.TxManager.createTx(TxManager.java:79)
      at org.jboss.mq.server.JMSDestinationManager.transact(JMSDestinationManager.java:424)
      at org.jboss.mq.server.JMSServerInterceptorSupport.transact(JMSServerInterceptorSupport.java:186)
      at org.jboss.mq.server.TracingInterceptor.transact(TracingInterceptor.java:438)
      at org.jboss.mq.server.JMSServerInvoker.transact(JMSServerInvoker.java:186)
      at org.jboss.mq.il.jvm.JVMServerIL.transact(JVMServerIL.java:328)
      at org.jboss.mq.Connection.send(Connection.java:928)
      ... 9 more
      Caused by: java.sql.SQLException: S1000 General error java.lang.ClassCastException in statement [INSERT INTO JMS_TRANSACTIONS (TXID) values(3)]
      at org.hsqldb.Trace.getError(Unknown Source)
      at org.hsqldb.jdbcResultSet.(Unknown Source)
      at org.hsqldb.jdbcConnection.executeStandalone(Unknown Source)
      at org.hsqldb.jdbcConnection.execute(Unknown Source)
      at org.hsqldb.jdbcStatement.fetchResult(Unknown Source)
      at org.hsqldb.jdbcStatement.executeUpdate(Unknown Source)
      at org.hsqldb.jdbcPreparedStatement.executeUpdate(Unknown Source)
      at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:321)
      at org.jboss.mq.pm.jdbc2.PersistenceManager.createPersistentTx(PersistenceManager.java:660)
      ... 16 more