Hi, Any body got any clues on 'org.jboss.mq.SpyJMSException: Cannot process a transaction' errors?
I am using Jboss 3.2.3 with 'out the box' JMS configurtion. Stack trace... 004-04-14 01:06:19,650 ERROR [STDERR] java.lang.ClassCastException 2004-04-14 01:06:19,650 ERROR [STDERR] at org.hsqldb.Column.compare(Unknown Source) 2004-04-14 01:06:19,650 ERROR [STDERR] at org.hsqldb.Index.compareRow(Unknown Source) 2004-04-14 01:06:19,650 ERROR [STDERR] at org.hsqldb.Index.insert(Unknown Source) 2004-04-14 01:06:19,650 ERROR [STDERR] at org.hsqldb.Table.indexRow(Unknown Source) 2004-04-14 01:06:19,650 ERROR [STDERR] at org.hsqldb.Table.insertNoCheck(Unknown Source) 2004-04-14 01:06:19,650 ERROR [STDERR] at org.hsqldb.Table.insert(Unknown Source) 2004-04-14 01:06:19,650 ERROR [STDERR] at org.hsqldb.Parser.processInsert(Unknown Source) 2004-04-14 01:06:19,650 ERROR [STDERR] at org.hsqldb.Database.execute(Unknown Source) 2004-04-14 01:06:19,650 ERROR [STDERR] at org.hsqldb.jdbcConnection.executeStandalone(Unknown Source) 2004-04-14 01:06:19,650 ERROR [STDERR] at org.hsqldb.jdbcConnection.execute(Unknown Source) 2004-04-14 01:06:19,650 ERROR [STDERR] at org.hsqldb.jdbcStatement.fetchResult(Unknown Source) 2004-04-14 01:06:19,650 ERROR [STDERR] at org.hsqldb.jdbcStatement.executeUpdate(Unknown Source) 2004-04-14 01:06:19,650 ERROR [STDERR] at org.hsqldb.jdbcPreparedStatement.executeUpdate(Unknown Source) 2004-04-14 01:06:19,650 ERROR [STDERR] at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUpdate(Wrapp edPreparedStatement.java:324) 2004-04-14 01:06:19,650 ERROR [STDERR] at org.jboss.mq.pm.jdbc2.PersistenceManager.createPersistentTx(PersistenceManag er.java:660) 2004-04-14 01:06:19,650 ERROR [STDERR] at org.jboss.mq.pm.TxManager.createTx(TxManager.java:79) 2004-04-14 01:06:19,650 ERROR [STDERR] at org.jboss.mq.server.JMSDestinationManager.transact(JMSDestinationManager.jav a:424) 2004-04-14 01:06:19,650 ERROR [STDERR] at org.jboss.mq.server.JMSServerInterceptorSupport.transact(JMSServerIntercepto rSupport.java:186) 2004-04-14 01:06:19,650 ERROR [STDERR] at org.jboss.mq.server.TracingInterceptor.transact(TracingInterceptor.java:438) 2004-04-14 01:06:19,665 ERROR [STDERR] at org.jboss.mq.server.JMSServerInvoker.transact(JMSServerInvoker.java:186) 2004-04-14 01:06:19,665 ERROR [STDERR] at org.jboss.mq.il.jvm.JVMServerIL.transact(JVMServerIL.java:328) 2004-04-14 01:06:19,665 ERROR [STDERR] at org.jboss.mq.Connection.send(Connection.java:928) 2004-04-14 01:06:19,665 ERROR [STDERR] at org.jboss.mq.SpyXAResourceManager.commit(SpyXAResourceManager.java:127) 2004-04-14 01:06:19,665 ERROR [STDERR] at org.jboss.mq.SpyXAResource.commit(SpyXAResource.java:103) 2004-04-14 01:06:19,665 ERROR [STDERR] at org.jboss.jms.asf.StdServerSession.onMessage(StdServerSession.java:307) 2004-04-14 01:06:19,665 ERROR [STDERR] at org.jboss.mq.SpyMessageConsumer.sessionConsumerProcessMessage(SpyMessageCons umer.java:633) 2004-04-14 01:06:19,665 ERROR [STDERR] at org.jboss.mq.SpyMessageConsumer.addMessage(SpyMessageConsumer.java:433) 2004-04-14 01:06:19,665 ERROR [STDERR] at org.jboss.mq.SpySession.run(SpySession.java:298) 2004-04-14 01:06:19,665 ERROR [STDERR] at org.jboss.jms.asf.StdServerSession.run(StdServerSession.java:180) 2004-04-14 01:06:19,665 ERROR [STDERR] at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(PooledExecutor.ja va:727) 2004-04-14 01:06:19,665 ERROR [STDERR] at java.lang.Thread.run(Thread.java:534) 2004-04-14 01:06:19,681 WARN [org.jboss.util.NestedThrowable] Duplicate throwable nesting of same base type: class org.jboss.mq.SpyJMSException is assignable from: class org.jboss.mq.SpyJMSException 2004-04-14 01:06:19,681 ERROR [org.jboss.jms.asf.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: 77; - nested throwable: (java.sql.SQLException: S1000 General error java.lang.ClassCastException in statement [INSERT INTO JMS_TRANSACTIONS (TXID) values(77)]))) 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(SpyMessageCons umer.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.ja va: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: 77; - nested throwable: (java.sql.SQLException: S1000 General error java.lang.ClassCastException in statement [INSERT INTO JMS_TRANSACTIONS (TXID) values(77)])) 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: 77; - nested throwable: (java.sql.SQLException: S1000 General error java.lang.ClassCastException in statement [INSERT INTO JMS_TRANSACTIONS (TXID) values(77)]) at org.jboss.mq.pm.jdbc2.PersistenceManager.createPersistentTx(PersistenceManag er.java:666) at org.jboss.mq.pm.TxManager.createTx(TxManager.java:79) at org.jboss.mq.server.JMSDestinationManager.transact(JMSDestinationManager.jav a:424) at org.jboss.mq.server.JMSServerInterceptorSupport.transact(JMSServerIntercepto rSupport.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(77)] at org.hsqldb.Trace.getError(Unknown Source) at org.hsqldb.jdbcResultSet.<init>(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(Wrapp edPreparedStatement.java:324) at org.jboss.mq.pm.jdbc2.PersistenceManager.createPersistentTx(PersistenceManag er.java:660) ... 16 more -- Discover a lost art - play Marbles May 2004 www.marillion.com ICQ: 760757 | AIM: pjshrimpton | Y!: pjshrimpton | [EMAIL PROTECTED] ------------------------------------------------------- This SF.Net email is sponsored by: IBM Linux Tutorials Free Linux tutorial presented by Daniel Robbins, President and CEO of GenToo technologies. Learn everything from fundamentals to system administration.http://ads.osdn.com/?ad_id70&alloc_id638&op=click _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user