Re: Problem with locking and deleting with many-to-many relationship
Re: Problem with locking and deleting with many-to-many relationship
- Subject: Re: Problem with locking and deleting with many-to-many relationship
- From: Gerald Hanks <email@hidden>
- Date: Wed, 26 Nov 2003 16:06:25 -0700
I wasn't using the addObjectTo/removeObjectFromBothSidesOfRelationship... but did change to using those functions and I still get the same result. I am not using pessimistic locking and have checked the delete rules and they appear to be correct. I did not change them from what EOModeler set them to when I chose join in many to many from the menu to connect the two tables item and option. What else should I be looking at.
-gerald
On Wednesday, November 26, 2003, at 03:15PM, Ricardo Strausz <email@hidden> wrote:
>If not an answer, some point to check:
>- are you using add/deleteToBothSidesOfRelation?
>- are your model delete rules correct?
>- did you *log* the EC's arrays updatedObjects, deletedObjects and so?
>if so, is that what you spected to be?
>- are you using pessimistic locking?
>Dino
>
>On Nov 26, 2003, at 14:50, Gerald Hanks wrote:
>
>> I have a flattened many-to-many relationship from item to option which
>> uses
>> three tables: item, option, and item_option. The item object has a
>> flattened
>> attribute called options.
>>
>> When I add an option to the options list using
>>
>> anItem.addToOptions(anOption) I get the following SQL on saveChanges()
>>
>> INSERT INTO item_option(item_id, option_id) VALUES (1, 8)
>>
>> This would seem to be correct
>>
>> When I remove an option from the options list using
>>
>> anItem.removeFromOptions(anOption) then I get the following SQL on
>> saveChanges()
>>
>> SELECT t0.item_id FROM item_option t0 WHERE t0.option_id = 8 FOR UPDATE
>> DELETE FROM item_option WHERE option_id = 8
>>
>> This seems to be in error since this SQL would remove option 8 from
>> all items not
>> just the one being updated. In fact if there are two items with
>> option 8 and
>> I try to delete option 8 from either item I get a locking failure
>> telling me
>> that more than one row was locked.
>>
>> Can anyone help me on this one. I am kind of stuck for the time being.
>>
>> -gerald
>> _______________________________________________
>> 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.
_______________________________________________
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.