Problem with JBOSS3.21 and select JMS_TRANSACTIONS

epinfo May 12, 2003 3:36 AM

When jboss started the error :

ERROR [org.jboss.mq.pm.jdbc2.PersistenceManager] Starting failed
org.jboss.mq.SpyJMSException: Could not resolve uncommited transactions. Message recovery may not be accurate; - nested throwable: (java.sql.SQLException: Syntax error or access violation, message from server: "You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT TXID FROM JMS_TRANSACTIONS) AND TXOP='A'' at line 1")

What source file class who make the sentence.

Best regard

1. Re: Problem with JBOSS3.21 and select JMS_TRANSACTIONS

adrian.brock May 12, 2003 8:52 AM (in response to epinfo)

http://forums.devshed.com/archive/4/2002/11/4/47665

For the source file, the clue is in the question :-)
ERROR [org.jboss.mq.pm.jdbc2.PersistenceManager]

Regards,
Adrian
Actions
2. Re: Problem with JBOSS3.21 and select JMS_TRANSACTIONS

geirwilly Jan 30, 2004 3:50 AM (in response to epinfo)

I followed the link and end up on the problem with mysql 3.23 not supporting multitable delete statements.

This link
http://forums.devshed.com/archive/4/2002/11/4/47665

Workaround for subselect in delete query
The multitable delete you have there should work totally fine in MySQL 4.0, however 3.23 doesn't have multitable delete statements.
In 4.1 you could either use subselects or the left join (the left join being more efficient most likely). In 3.23, which I assume you are using since you got
a syntax error, you will have to do it client side. You could easily make MySQL return the actual select statements you need to run and just pipe them back to MySQL or something similar.
Actions

Go to original post