Re: Problem relationship with 2 eomodels
"Pierre Gilquin" <[email protected]> Tue, 3 Nov 2009 09:18:43 +0100
| Newsgroups | gmane.comp.web.webobjects.devel |
|---|---|
| Message-ID | <[email protected]> |
>You would probably want to turn on adaptor debug to see what SQL is being generated for your particular case, and be >prepared to do some of the work in memory. From your description it sounds like you're fetching EntityAFromModel1 >with a qualifier that touches EntityCFromModel2, and it's generating the SQL in the database for Model1. In my app., EntityAFromModel1 si fetched directly. Then the details (EntityBFromModel1 and EntityCFromModel2) are fetched. The MySQL command for EntityAFromModel1 and EntityBFromModel1 are ok. Then an errors occurs before the Oracle command is send. I have fixed this by implementing in EntityBFromModel1.awakeFromFetch(..) the fetch of the EntityCFromModel2's object needed by the relationship. It seems to me that if the EntityCFromModel2 are already fetched, EOF don't have problem to use them.