Read the replies to this posting. It should help. http://markmail.org/message/ndp7jgdfjwfnouwa#query:webobject%20many%20to%20many%20tutorial+page:1+mid:ejbgzqebozximrda+state:results
> EOModeler can do this automatically for you. 1)Click on the model so you can > see the model in list mode. 2)Select the two entities you want to join > (Command Click on Mac Control Click on Windows) 3)Menu->Property->Join In > Many-to-Many > Et Voilà! > Just fill the missing info in the newly created entity. Also I leave the > correlation object to be of type EOGenericRecord (no need for create a custom > class). > Mark Sent from my iPhone On 14 May 2012, at 12:00, Pavan Kumar Jayam <[email protected]> wrote: > 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/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]
