Re: How to selectively save EO
Re: How to selectively save EO
- Subject: Re: How to selectively save EO
- From: Ondra Cada <email@hidden>
- Date: Sat, 22 Apr 2006 17:17:03 +0200
Ken,
On Apr 21, 2006, at 9:57 PM, Ken Anderson wrote:
Also, I highly suggest never, ever, using hackery in EOF to
partially save an EC... and I speak from experience :)
Well... in, how long it is this project runs? Four-odd years, and I
am yet to encounter the first runtime problem caused by that :)
Truth is, my hackery is *extensive* (which actually helps somewhat,
since there remains little EOF low-level code to clash with :)), and
I would *not* recommend anyone to do that unless necessary.
(Which it is for me: far as I know, there is no other way than to
essentially replace the complete adaptor level functionality by my
own code if, as alas it is in this case, the customer insists on
(a) using IDENTITY columns for all keys;
(b) having the client code *always* do *complete* saving in one SQL
batch (I don't see any problem in batch-spanning transactions myself,
but well, he is the customer);
(c) using the MS-SQL stuff with all its quirks, particularly using
its TIMESTAMPs for optimistic locking (there is roughly the same
problem with the stuff as with IDENTITY: they are server-generated,
and with standard SQL the client code has not their values so can't
cache them);
(d) (and there is a number of other minor demands on the generated
SQL, some reasonable, some not quite--like that NULL should be
checked for by "isnull(x)", whilst the standard stack uses "x==NULL" :))
Luckily the customer still holds some old licences to WO4.5 and the
app is in-house, so I can do it in ObjC: I do fear in Java it would
be plain impossible, and I would have to do without EOF at all (even
though I am /more or less/ not using adaptor level, the control level
alone is very much worth the effort).
Well perhaps I could solve it by leaving the SQL stack intact and
implementing my own adaptor, but I don't think so, at least I don't
think it would be easier.)
---
Ondra Čada
OCSoftware: email@hidden http://www.ocs.cz
private email@hidden http://www.ocs.cz/oc
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden