Problem relationship with 2 eomodels
Pierre Gilquin <[email protected]> Thu, 29 Oct 2009 09:33:19 +0000
| Newsgroups | gmane.comp.web.webobjects.devel |
|---|---|
| Message-ID | <[email protected]> |
Hi all, I have 2 eomodels one using MySql and the second Oracle. I have the following Entities : EntityAFromModel1, EntityBFromModel1and EntityCFromModel2 EntityAFromModel1 has a to-many relationship with EntityBFromModel1. EntityBFromModel1 has a to-one relationship with EntityCFromModel2. This relation crosses the 2 models. When fetching EntityAFromModel1, I get the following error when accessing the to-one relationship to EntityCFromModel2 : java.lang.IllegalStateException: Server exception: The object with globalID _EOIntegralKeyGlobalID[EntityCFromModel2 (java.lang.Integer)16823]could not be found in the database. This could be result of a referential integrity problem with the database. An empty fault could not be created because the object's class could not be determined (e.g. the GID is temporary or it is for an abstract entity). No SQL statement is send to the Oracle Database. The only thing I find for help is to fetch all EntityCFromModel2 at the Application start. But it is not very practical has EntityCFromModel2 has a lot of instances. Moreover, I am sure that it will still work a long time after the start. I thought also to implement awakeFromFetch in EntityBFromModel1 in order to fetch the instance needed for the relationship but without success. Do you have a better idea to make this relationship works between 2 models working ? Thank in advance. Pierre WO 5.2.4 _________________________________________________________________ La Suisse reçoit plus d'espace! Votre disque dur virtuel de 25 Go avec Windows Live SkyDrive. http://skydrive.live.com