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
