Re: OO and relation "impedance mismatch"

From: Kenneth Downs <firstinit.lastname_at_lastnameplusfam.net>
Date: Wed, 06 Oct 2004 13:35:56 -0400
Message-ID: <rda1kc.7va.ln@mercury.downsfam.net>

Tony Andrews wrote:

> Kenneth Downs wrote:

>> Troels Arvin wrote:
>>
>> > On Mon, 04 Oct 2004 18:40:56 -0400, Kenneth Downs wrote:
>> >
>> >> But if you use a trigger, you can do

> tell-me-everything-I-did-wrong.

>> >
>> > I don't quite understand this: How can the trigger overcome

> fail-on-first

>> > error handling?
>>
>> The trigger records each error that it finds, but instead of stopping

> it

>> keeps going.  So the more you have, the more that are recorded.  It
>> actually never raises an error in the strict sense, you might say it

> always

>> "returns true".

>
> Sorry to keep bugging you, but what do you mean by this? If the
> trigger "returns true", then who is responsible for aborting the
> triggering statement - the application? In that case, you don't have
> assured integrity at all: it is optional.

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.

-- 
Kenneth Downs
Use first initial plus last name at last name plus literal "fam.net" to
email me

Received on Wed Oct 06 2004 - 12:35:56 CDT