[jboss-user] [Messaging, JMS & JBossMQ] - 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
  | 
  | 

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4054083#4054083

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4054083