Tim Bunce wrote:
On Wed, Jun 17, 2009 at 01:53:36PM -0500, David Dooling wrote:
If any of the SQL fails, then all the DB transactions are rolled back.
If two databases are being used, and the commit to the first succeeds
and the commit to the second fails, how does it "rollback" the first commit?
Depending on the reason for failure, it could still be done when using something
like a two-phase commit protocol. This isn't a 100% solution, but for the
situations where it works you don't need to undo the succeeding databases. --
Darren Duncan
