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#3967871 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3967871 _______________________________________________ jboss-user mailing list [email protected] https://lists.jboss.org/mailman/listinfo/jboss-user
