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=866FD117-33B9-488F-BD23-77FBA7636F88%40gmail.com
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.
with regards,
--
Lachlan Deck
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list ([email protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com
This email sent to [EMAIL PROTECTED]
