I've installed and used 3.2.x versions on Linux and Windows before without any problems. I've also installed and configured 4.0.1 on Windows XP with MySQL 4.1.0 database without any issues. I've been trying to get 4.0.1 to work with MySQL 4.0.21 on SUSE 9.2 and I get an error. JBoss starts up and runs, but the PersistenceManager fails.
MBEANS THAT ARE THE ROOT CAUSE OF THE PROBLEM:
ObjectName: jboss.mq:service=PersistenceManager
state: FAILED
I Depend On: jboss.jca:name=DefaultDS,service=DataSourceBinding
Depends On Me: jboss.mq:service=DestinationManager
org.jboss.mq.SpyJMSException: Could not resolve uncommited transactions. Message recovery may not be accurate; - nested throwable: (java.sql.SQLException: Youhave an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT TXID FROM JMS_TRANSACTIONS)' at line 1)
However, if i connect to MySQL and the jboss DB from the command line, running the query SELECT TXID FROM JMS_TRANSACTIONS; runs fine.
Any ideas would be helpful.