I'm using Tomcat 5.5, MySQL 4.1 and SwiftMQ HA 6.1.0 and I would like managing global XA transactions including SwiftMQ + MySQL processing (consume message from SwiftMQ and insert data into MySQL in a single global transaction).
Is there a way to achieve that considering that SwiftMQ HA includes the XA extension swiflet ?
Yes. Either drive the XA stuff yourself by using our XAResouce or (better) use the Atomikos Transaction Manager. It's standalone and should work with SwiftMQ. I remember they tested it with SwiftMQ (though we did not).