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 protected]> 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 protected]) >> Help/Unsubscribe/Update your Subscription: >> https://lists.apple.com/mailman/options/webobjects-dev/rasc%40gmx.de >> >> 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: > https://lists.apple.com/mailman/options/webobjects-dev/gowdy%40mac.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: https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [email protected]
