ClassCastException in statement INSERT INTO JMS_TRANSACTIONS
isotope1145 Nov 12, 2003 3:02 PMI 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