Re: faulting problem

Are you absolutely postive?  After logging the SQL when the event 
happens, triple check.

A fault does a simply query to get the row for its Object. That query 
is just a select using the PK (FK of the source EO with the fault). If 
it says it got more than one row, then you probably in fact do have 
dups. Maybe when you've checked for dups in the past you just selected 
on PK with distinct and the dups where filtered out?

d


On Saturday, March 15, 2003, at 12:18 AM, matthew kime wrote:

> No duplicate primary keys and my model and database (mysql) certainly 
> agree.
>
> ug. suddenly i feel i might be back at square one.
>
> --matt
>
>
> On Saturday, March 15, 2003, at 12:59 AM, Andrew Mottaz wrote:
>
>> The only time I've ever seen this error it was due to a table that 
>> had duplicate primary keys.  (How they got there is another issue)  
>> Check the primary key of the object being updated.  If there are two, 
>> that is certainly the problem.  Also confirm that your Model and 
>> Database agree on what exactly the primary key is.
>>
>> -Andrew
>> On Friday, March 14, 2003, at 11:32 PM, matthew kime wrote:
>>
>>> sorry about that...
>>>
>>> WebObjects 5.2, Mac OS X 10.2
>>>
>>> com.webobjects.eoaccess.EOGeneralAdaptorException: 
>>> lockRowComparingAttributes -- 
>>> com.webobjects.jdbcadaptor.JDBCChannel: lock operation locked more 
>>> than one row
>>>
>>> --matt
>>>
>>> On Saturday, March 15, 2003, at 12:27 AM, Ben Trumbull wrote:
>>>
>>>> software version ?  actual error text ?
>>>>
>>>> Is this an optimistic locking failure or a thread locking failure ?
>>>> -- 
>>>>
>>>> -Ben
>>>
>>> _______________________________________________
>>> WebObjects-dev mailing list
>>> [email protected]
>>> http://www.omnigroup.com/mailman/listinfo/webobjects-dev
>>>
>>
>> _______________________________________________
>> WebObjects-dev mailing list
>> [email protected]
>> http://www.omnigroup.com/mailman/listinfo/webobjects-dev
>>
>
> _______________________________________________
> WebObjects-dev mailing list
> [email protected]
> http://www.omnigroup.com/mailman/listinfo/webobjects-dev
>