<br /><font face="sans-serif" size="2">On 11/05/2002 04:42:55 AM Neil Conway wrote:<br /> > Mike Mascari
<mascarm@mascari.com>writes:<br /> > > Is there any thought about changing the protocol to support<br />
>> two-phase commit? Not that 2PC and distributed transactions would be<br /> > > implemented in 7.4, but
toprevent another protocol change in the<br /> > > future?<br /> > <br /> > My understanding is that 2PC is
oneway to implement multi-master<br /> > replication. If that's what you're referring to, then I'm not sure I<br
/></font><br/><font face="sans-serif" size="2">Another use of two-phase commit is in messaging middleware (MOM, message
orientedmiddleware), were both the middleware and the database participate in the same transaction. Consider:</font><br
/><br/><font face="sans-serif" size="2">- DB: begin</font><br /><font face="sans-serif" size="2">- MOM: begin</font><br
/><fontface="sans-serif" size="2">- DB: insert</font><br /><font face="sans-serif" size="2">- MOM: send
message</font><br/><font face="sans-serif" size="2">- DB: prepare</font><br /><font face="sans-serif" size="2">- MOM:
prepare==> fails</font><br /><font face="sans-serif" size="2">- DB: rollback</font><br /><font face="sans-serif"
size="2">-MOM: rollback</font><br /><br /><font face="sans-serif" size="2">just a simple example...</font><br /><br
/><fontface="sans-serif" size="2">Maarten</font> <code><font size="3"><br /><br />
----------------------------------------------------------------<br /> Visit our Internet site at
http://www.reuters.com<br/><br /> Get closer to the financial markets with Reuters Messaging - for more<br />
informationand to register, visit http://www.reuters.com/messaging<br /><br /> Any views expressed in this message are
thoseof the individual<br /> sender, except where the sender specifically states them to be<br /> the views of Reuters
Ltd.<br/></font></code>