Re: OO and relation "impedance mismatch"

From: Laconic2 <laconic2_at_comcast.net>
Date: Wed, 6 Oct 2004 13:59:34 -0400
Message-ID: <JOednV5EgtEHr_ncRVn-pw@comcast.com>

"Kenneth Downs"

> The rollback is server-controlled, it has to be. Otherwise, as you point
> out, there is no assured integrity. The rollback code is in the trigger
> code I posted.

I haven't done all that much with triggers, but it strikes me that you can let the application do the rollback.

What you do is put a trigger on the commit. The commit trigger checks to see if any errors have been caught by the other triggers. If so, the commit trigger returns an error, and skips the commit. Now the application is stuck. The only way out, if commit won't work, is with a rollback. I certainly would try this on my DBMS. YMMV. Received on Wed Oct 06 2004 - 12:59:34 CDT