1 Reply Latest reply on Jun 13, 2007 2:09 PM by tnine

    MySQL Jboss MQ SQL creation script

    tnine Newbie

      Hi all,
      I'm trying to change my datasource to a clustered MySQL database. I have everything ready to go except the tables! I depolyed MQ a year ago, and the SQL create srcipt was on the Wiki. I can't seem to find it anywhere. Can anyone point me in the right direction?

      Thanks,
      Todd

      FYI, this is the error I'm receiving for anyone else who sees this post

      ObjectName: jboss.mq:service=PersistenceManager
       State: FAILED
       Reason: org.jboss.mq.SpyJMSException: Could not resolve uncommited transactions. Message recovery may not be accurate; - nested throwable: (com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Tablejbossmq.jms_messages' doesn't exist)
       I Depend On:
       jboss.jca:service=DataSourceBinding,name=MySqlJmsDS
       Depends On Me:
       jboss.mq:service=DestinationManager
      
      


        • 1. Re: MySQL Jboss MQ SQL creation script
          tnine Newbie

          To answer myself, the issue seems to be that I was attempting to re-use an XA data source I had used for a different database. I used the example from the doc directory and this fixed my issue. As a side note, I thought the destination manager would have already been configured, however this is not the case. The Wiki doesn't explicitly say to, but I'm assuming the destination manager should have the same data source as the messages. So I modified the hsqldb-jdbc-state-service.xml to also point to the new data source. Hopefully this helps someone else out!