0 Replies Latest reply on Apr 7, 2005 5:14 PM by David Vestal

    Configuration of JBoss 4.0.1

    David Vestal Newbie

      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.