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: Mark Gowdy <email@hidden>
- Date: Mon, 14 May 2012 11:37:19 +0100
The other option is to use a many-to-many relationship between the two entities.
Select the two entities in EOModeller (or whatever it is called nowadays) and join in a 'many-to-many'.
It will create the join table (with a compound key created using the two primary keys), and wo will handle all of the magic required to make it work.
Mark
Sent from my iPhone
On 14 May 2012, at 11:14, Ralf Schuchardt <email@hidden> 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
_______________________________________________
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