Re: an interesting lockRowComparingAttributes:
Re: an interesting lockRowComparingAttributes:
- Subject: Re: an interesting lockRowComparingAttributes:
- From: Chuck Hill <email@hidden>
- Date: Wed, 2 Apr 2008 15:11:10 -0700
On Apr 2, 2008, at 2:57 PM, Lachlan Deck wrote:
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)
Was it you that I was discussing this with? Do you recall what was
happening? So many obscure bugs, so little time...
Chuck
--
Practical WebObjects - for developers who want to increase their
overall knowledge of WebObjects or who are trying to solve specific
problems.
http://www.global-village.net/products/practical_webobjects
_______________________________________________
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