JBoss + MySQL 5 as message persistent storage

[bloodasp]

Hi,

I would just like to ask if anyone has successfully used MySQL 5 with JBoss for both data storage and JMS message persistence as well. I'd like to get some feedback before I seriously start considering an upgrade from MySQL 4 to 5. Thanks a lot. :)

[oglueck]

Does MySQL 5 support transactions? You need this when you use the JMS resource adapter and want your messages be sent on commit and forgotten on rollback.

[bloodasp]

InnoDB supports transactions