[rabbitmq-discuss] Transaction Dependencies

[Vaughn Vernon]

Hey,

How do you recommend handling the case where a local application 
database transaction may commit or rollback, and you don't want to 
publish the event unless it commits? In other words:

1 - application transaction begins
     2 - application writes to database
     3 - rmq message published (publish must succeed for application 
transaction to succeed)
4 - application transaction commits; however, issue occurs, transaction 
does not complete; must prevent rmq publish

Can't move #3 after #4 because the possibility exists that rmq publish 
will fail and message will never be published.

This points to 2pc of application and rmq, but unavailable for the 
application database. BTW, does rmq 2pc with other databases?

Vaughn

--

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.rabbitmq.com/pipermail/rabbitmq-discuss/attachments/20110411/746d8e5b/attachment.htm>