-
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 -
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.