Duplicate entry [ was addObjectsToBothSide... not really both side]

Hi,
I though everything was good with my oneToOne (pk to pk)  
relationship, but not completely in fact.

So A and B have a relationship joining their pk.

But B can be "alone", which means I can have B object without A object.

So it happens that sometimes, when creating a A object (which will  
create the B object at the same time as the relationship is created)  
and trying to save it, A got a primary key already used by B which  
lead to a crash...

Is there a way to get the primary form the B object instead of the A  
object? (B pks are always good as I cannot have an A object without a B)

Thanks:)

Xavier


> I've setup my onetoone on both pk and everything is good:)
>
> Thanks a lot:)
>
> I'll wait for tomorrow for the next question;)
>
>
> Xavier
>
>> You really need to set both directions - EOF will not do it for you.
>>
>> On Sep 26, 2006, at 3:38 PM, Dev WO wrote:
>>
>>> Hi zak,
>>>> Dev WO wrote on 9/25/06 1:26 PM:
>>>>> So this one is a oneToOne relationship, with is specified in both
>>>>> entities A and B.
>>>>
>>>> [...]
>>>>
>>>>> A and B have a foreign key to each other, but only A gets it...  
>>>>> B's
>>>>> foreign key stay "null".
>>>>
>>>> I think you may not be modeling the relationship correctly. If you
>>>> really want a 1-to-1, A and B should share the same primary key  
>>>> and A
>>>> should be propagating its primary key to B.
>>>>
>>>> If both tables have their own primary keys, and both have  
>>>> foreign keys
>>>> to each other, things don't really stand up from a relational logic
>>>> point of view because you actually have two relationships -- A  
>>>> is joined
>>>> to B by by A.b_id and B is joined to A by B.a_id.
>>>>
>>>> Assuming that A.setB() is defined in terms of A.b_id, the reason  
>>>> B.a_id
>>>> doesn't update is that B.a() is defined by B.a_id but the  
>>>> relationship
>>>> you just set is defined by A.b_id. You have two separate  
>>>> relationships
>>>> based on two separate keys.
>>>
>>> HUUUUUU I feel stupid...not the first time though, and probably  
>>> not the last one too;)
>>>
>>> In my case, B can exist alone (without any A to relating to it),  
>>> but A cannot exist alone, it must be linked to a B.
>>>
>>> Does this change anything?
>>> I'll try to make the relationship between pks.
>>>
>>> Thanks:)
>>>
>>> Xavier
>>>
>>> _______________________________________________
>>> 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/lists% 
>>> 40anderhome.com
>>>
>>> This email sent to [email protected]
>>
>>
>
> _______________________________________________
> 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/webobjects% 
> 40anazys.com
>
> This email sent to [email protected]
>