I am getting errors during the startup of JBoss 4.0.3RC2.
...
--- MBEANS THAT ARE THE ROOT CAUSE OF THE PROBLEM ---
ObjectName: jboss.mq:service=PersistenceManager
State: FAILED
Reason: org.jboss.mq.SpyJMSException: Could not resolve uncommited transactions. Message recovery may not be accurate; - nested throwable: (java.sql.SQLException: Every derived table must have its own alias)
...
The Persistence Manager is described in the file jms/mysql-jdbc2-service.xml. I copied it from the examples, and removed three lines that were identical defining (UPDATE_MESSAGE, UPDATE_MARKED_MESSAGES, and UPDATE_MARKED_MESSAGES_WITH_TX).
Thanks for any help.
Would it be possible for you to explain further why you have taken the steps you have.
All I can see is that you have taken an example configuration file and deleted some of the required content, now you are asking why it does not work.