Change the following line in server/default/deploy/jms/hsqldb-jdbc2-service.xml (this is also where you probably changed the datasource from the DefaultDS to your MySqlDS) from: SELECT_MAX_TX = SELECT MAX(TXID) FROM (SELECT MAX(TXID) AS TXID FROM JMS_TRANSACTIONS UNION SELECT MAX(TXID) AS TXID FROM JMS_MESSAGES) to: SELECT_MAX_TX = SELECT MAX(TXID) FROM JMS_MESSAGES View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3967871#... Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...