[jboss-user] [Installation, Configuration & Deployment] - Re: Error using MySQL 4.1 with JBoss AS 4.0.4GA

[georgesberscheid]

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