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 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/archive%40mail-archive.com This email sent to [email protected]
