AnsweredAssumed Answered

Transaction between Oracle and WebSphere MQ (with JTA?)

Question asked by SimoneAvogadro2271 on Jul 16, 2014
Latest reply on Jul 22, 2014 by SimoneAvogadro2271
A prospect is asking us a PoC where he would like to test a distributed transaction which involves an MQ (WebSphere MQ) and a database (Oracle).
How can we achieve this?
My idea is that maybe we could use Groovy scripts to start a JTA transaction righer after the first shape, in the second one we read the message from the MQ, then map it to XML and write to Oracle. If anything goies wrond we put a try-catch and performa JTA rollback, otherwise we perform a JTA commit.

However this is just an hipotesys based on some assumptions:
 - Boomi will execute each process run within a single thread
 - Boomi will execute the MQ fetch without fiddling withint JTA/XA transation state
 - Boomi will execute the DB Write without fiddling withint JTA/XA transation state
 - Boomi groovy scripts have access to the relevant JTA classes
 - The Oracle drivers and stack used from Boomi are enabled for using JTA/XA transactions
 - The JMS drivers and stack used from Boomi are enabled for using JTA/XA transactions

that's quite a lot of assumptions.....

 - did anyone already test such a scenario (even with different MQ and/or DB)?
 - any feedback from the Boomi tech team? should we try this ourselves before meeting the customer or is it just a waste of time as it will definitively not work?
 - anyone has a different strategy on how to accomplish this?

Outcomes