Hi,

I am posting this message to pre-check the feasibility of what follows
before wasting time configuring/testing it.

I'd like to know if with this platform:
- Tomee+ 1.7.2
- ActiveMQ 5.12.1
- MySql 5.7

something like this is possible or not:
<http://tomee-openejb.979440.n4.nabble.com/file/n4676680/XATransaction.png> 

In words, the flow is:
- A message reader (i.e. a MessageDriven bean) *reads from a queue* (1) and
processes one message triggering:
   - *one or more inserts/updates on a database* (2)
   - a *put of a message to another queue* (3)

(1)(2)(3) operations are all part of the same XA transaction controlled by
Tomee, so under any circumstances they either all fail or all succeed.

After a bit of searching I see that both MySql and ActiveMQ provide XA
drivers and that tomee seems to be able to create transacted resources (via
configuration in tomee.xml) made available, together with the
transactionManager, to the JEE application via JNDI.
So, on paper, it sounds feasible.. I'd just like someone with experience on
this kind of things to confirm.

Thanks!



--
View this message in context: 
http://tomee-openejb.979440.n4.nabble.com/Tomee-MySql-ActiveMQ-XA-Distributed-Transactions-tp4676680.html
Sent from the TomEE Users mailing list archive at Nabble.com.

Reply via email to