Re: an interesting lockRowComparingAttributes:
Re: an interesting lockRowComparingAttributes:
- Subject: Re: an interesting lockRowComparingAttributes:
- From: Lachlan Deck <email@hidden>
- Date: Thu, 3 Apr 2008 08:57:27 +1100
On 03/04/2008, at 4:55 AM, Chuck Hill wrote:
On Apr 2, 2008, at 10:38 AM, David Avendasora wrote:
If the SELECT ... FOR LOCK can't find any rows that have fields
with values that match exactly with what the DB has, then it
wouldn't get any rows either. No?
Yes, but... SELECT ... FOR LOCK is _pessimistic_ locking and EOF
should be using optimistic locking. If EOF is issuing pessimistic
locking SQL, then something has gone wrong.
Maybe log the SQL and then compare what WO is looking for with what
is actually in the DB?
That is not the issue. The important symptom is that EOF is doing a
SELECT ... FOR LOCK.
Didn't you see this when you were using <cough> Vertical Inheritance?
Rings a bell for me...
(Pierre, see radar://5632577 for suggested fix)
with regards,
--
Lachlan Deck
_______________________________________________
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