For purposes of showing up on a search, here is the trace I get:
Caused by: org.jboss.mq.SpyJMSException: Could not crate tx: 97107; - nested
throwable: (java.sql.SQLException: Violation of unique index: SYS_PK_JMS_TRANSACTIONS
in statement [INSERT INTO JMS_TRANSACTIONS (TXID) values(97107)])
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.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)
... 12 more
Caused by: java.sql.SQLException: Violation of unique index: SYS_PK_JMS_TRANSACTIONS
in statement [INSERT INTO JMS_TRANSACTIONS (TXID) values(97107)]
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:324)
at
org.jboss.mq.pm.jdbc2.PersistenceManager.createPersistentTx(PersistenceManager.java:660)
... 17 more
View the original post :
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3831828#3831828
Reply to the post :
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3831828
-------------------------------------------------------
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_id=1470&alloc_id=3638&op=click
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user
