Re: Multiple foreign keys pointing to the same table
Re: Multiple foreign keys pointing to the same table
- Subject: Re: Multiple foreign keys pointing to the same table
- From: Pavan Kumar Jayam <email@hidden>
- Date: Mon, 14 May 2012 16:30:02 +0530
Hi Ralf,
Thanks for the suggestion and I will verify marking as deferrable constraint.
And I followed another approach of storing the details in a join table, I am encountering a null pointer exception while saving the data. Displayed all the objects in the context by using "context.insertedObjects()" and I can see all the objects and data in console.
Can you suggest me where I am going wrong.
Regards,
Pavan.
On 14-May-2012, at 3:44 PM, Ralf Schuchardt wrote:
> Hi Pavan,
>
> the order of inserts of objects in a transaction is not specified. I think you see the insert of a row in table1 before the depending row in table2 causing the error.
> You should mark the foreign keys as "deferrable initially deferred" to postpone the integrity check to the end of the transaction, when all rows are inserted.
>
> Regards,
> Ralf
>
> Am 14.05.2012 um 10:57 schrieb Pavan Kumar Jayam:
>
>> Hi List,
>>
>> I want to have multiple foreign keys in Table1 representing same table Table2.
>>
>> Eg: Employee table have a Department table primary key as foreign key, now I want to have another foreign key in Employee table representing Department table. Which means an employee can be a member of two departments.
>>
>> I have foreign key in table1 represents table 2 primary key, also I want to have another foreign key in table 1 to represent the same table(table 2).
>>
>> Both the table 1 and table 2 records are creating in the same editing context and saving the editing context changes with ec.saveChanges().
>>
>> With one foreign key I am able to save table1 and table2 records, but when I am saving the editing context with multiple foreign keys of same table I am getting error "error code: 2291 == msg ORA-02291: integrity constraint() violated - parent key not found".
>>
>> Please advise how to implement it with Oracle 11 and WO 5.4.3.
>>
>> Regards,
>> Pavan.
>>
>> _______________________________________________
>> Do not post admin requests to the list. They will be ignored.
>> Webobjects-dev mailing list (email@hidden)
>> Help/Unsubscribe/Update your Subscription:
>>
>> This email sent to email@hidden
>
>
>
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden