[jboss-user] [JBoss Messaging] - Re: MQ migration help

[tnine]

Also, its creating all tables using the MyISAM engine.  MySQL doesn't support transactions in MyISAM tables.

http://dev.mysql.com/doc/refman/5.0/en/ansi-diff-transactions.html

I had to use the ALTER TABLE command to set the engine to InnoDB.  My default storange engine is InnoDB.  Should the create SQL set the storage engine?  

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

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