MySQL Jboss MQ SQL creation script

[tnine]

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

[tnine]

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!