1 Reply Latest reply on Sep 30, 2004 7:11 AM by Darran Lofthouse

    JBoss-3.2.5 - Error starting persistenceManager

    Raffaele Litto Newbie

      Hello, I'm new here and I would appreciate a little help about one problem we are experiencing:

      when starting JBoss and running the default server, we get this error:

      Could not create table with SQL: CREATE CACHED TABLE JMS_MESSAGES [...] "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 'CACHED TABLE JMS_MESSAGES ( MESSAGEID INTEGER NOT NULL, DESTINA"
      [..]
      ERROR [org.jboss.mq.pm.jdbc2.PersistenceManager] Starting failed jboss.mq:service=PersistenceManager
      org.jboss.mq.SpyJMSException: Could not resolve uncommited transactions. Message recovery may not be accurate; - nested throwable: (java.sql.SQLException: General error, message from server: "Table 'accounts.jms_messages' doesn't exist")

      We are using mySQL but, from the commands that JBoss tries to execute, it is clear to me that he tries to call on the configuration file:
      hsqldb-jdbc2-service.xml
      that uses HSQL

      Does anybody know where is the configuration problem? Where are the settings I have to change?
      Thank you

      Raffaele Litto