2 Replies Latest reply on Jan 30, 2004 3:50 AM by geirwilly

    Problem with JBOSS3.21 and select JMS_TRANSACTIONS

    eric PAPET Newbie

      When jboss started the error :

      ERROR [org.jboss.mq.pm.jdbc2.PersistenceManager] Starting failed
      org.jboss.mq.SpyJMSException: Could not resolve uncommited transactions. Message recovery may not be accurate; - nested throwable: (java.sql.SQLException: Syntax error or access violation, message from server: "You have 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) AND TXOP='A'' at line 1")

      What source file class who make the sentence.

      Best regard