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: Ralf Schuchardt <email@hidden>
- Date: Mon, 14 May 2012 12:14:33 +0200
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