Re: [webobjects-newbies] lockRowComparingAttributes
Re: [webobjects-newbies] lockRowComparingAttributes
- Subject: Re: [webobjects-newbies] lockRowComparingAttributes
- From: "Jonathan Fleming" <email@hidden>
- Date: Sat, 15 Mar 2003 16:36:40 +0000
From: matthew kime <email@hidden>
To: email@hidden
Subject: Re: [webobjects-newbies] lockRowComparingAttributes
Date: Sat, 15 Mar 2003 11:27:33 -0500
I just started to get the same problem!
WO queries the database in such a manner as to ensure that the row hasn't
been updated since you loaded data from it. (it selects based on the
values it expects to find) its complaining that a change must have
happened because its not returning any rows.
You need to have the lock on for at least the primary keys, i believe.
now, if you remove the lock for all but the primary keys, I predict you'll
get a slightly similar, but different error.
which version of java are you running? which database?
i'm using Java 1.3.1, WO 5.1.3 on Windows2000 with openBase at the moment
but I will be using SQLServer2000 shortly (just havn't got around to swaping
over).
--matt
On Saturday, March 15, 2003, at 11:12 AM, Jonathan Fleming wrote:
I've looked at the API and tried to make sense of 2 replies that I've had
on
this subject and I still don't understand what is causing the error
below.
Does anyone have a layman's answer to this since the technical one is
baffling me?
What i am being told is that I may be using pessimisic locking instead of
optimistic locking, if I am, I don't know how I've got on to that... the
only thing I can think of that may have cause this auomatically (if
possible)is that in EOModel I have turned off the lock symbol next to any
attribute that has the external type of "object" because comaring a
snapshot
with a blob would make the app much slower. Other than that i can not
answer
this.
If I have somehow defaulted to pessimistic locking, how do I go back to
optimistic locking so I can at least see if my error is down to the
EOModel
locking mechinism?
Exception occurred while handling request:
com.webobjects.eoaccess.EOGeneralAdaptorException:
lockRowComparingAttributes -- com.webobjects.jdbcadaptor.JDBCChannel:
lock
operation failed to select any rows
[2003-03-15 15:43:29 GMT] <WorkerThread0>
com.webobjects.eoaccess.EOGeneralAdaptorException:
lockRowComparingAttributes -- com.webobjects.jdbcadaptor.JDBCChannel:
lock
operation failed to select any rows
I'd love to understand this
Jonathan
_________________________________________________________________
Express yourself with cool emoticons http://messenger.msn.co.uk
------------------------ Yahoo! Groups Sponsor ---------------------~-->
Get 128 Bit SSL Encryption!
http://us.click.yahoo.com/xaxhjB/hdqFAA/xGHJAA/nhFolB/TM
--------------------------------------------------------------------- ~->
To unsubscribe from this group, send an email to:
email@hidden
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
_________________________________________________________________
Stay in touch with absent friends - get MSN Messenger
http://messenger.msn.co.uk
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.