The problems with 2-phase-commit have already been mentioned in response my
feature request.
Most notably, 2-phase commit does NOT ensure that the sequences are called
in the same order on all databases. This can cause huge problems! For
example invoices might point to different customers in different databases.
There are other problems that exist as well (deadlocks and the like) but I
am not as worried about them. The sequence issue IS a showstopper.
Best Wishes,
Chris Travers