Re: an interesting lockRowComparingAttributes:
Re: an interesting lockRowComparingAttributes:
- Subject: Re: an interesting lockRowComparingAttributes:
- From: Chuck Hill <email@hidden>
- Date: Wed, 2 Apr 2008 15:39:57 -0700
On Apr 2, 2008, at 3:27 PM, Lachlan Deck wrote:
On 03/04/2008, at 9:11 AM, Chuck Hill wrote:
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?
We did discuss this at one point a while ago.
Do you recall what was happening? So many obscure bugs, so little
time...
Yes, see thread "Snapshot weirdness" Dec 07
http://sourceforge.net/mailarchive/message.php?msg_id=email@hidden
Essentially... that thread will give you the background of the
problem... but the real solution I posted to yourself/Mike offlist
due to certain code mods.
Yes, that is what I was remembering. It wasn't David this time. This
time...
But unless Johann is using VI, that does not shed much light on his
problem.
Thanks!
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