Problem relationship with 2 eomodels
|
View:
New views
10 Messages
—
Rating Filter:
Alert me
|
 |
Problem relationship with 2 eomodels
by Pierre Gilquin-2
::
Rate this Message:
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_______________________________________________ WebObjects-dev mailing list WebObjects-dev@... http://www.omnigroup.com/mailman/listinfo/webobjects-dev |
|
|
Re: Problem relationship with 2 eomodels
by Kieran Kelleher
::
Rate this Message:
Have you tried this with latest Project Wonder and WO 5.3.3?
On Oct 29, 2009, at 5:33 AM, Pierre Gilquin wrote: > > 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_______________________________________________ > WebObjects-dev mailing list > WebObjects-dev@... > http://www.omnigroup.com/mailman/listinfo/webobjects-dev _______________________________________________ WebObjects-dev mailing list WebObjects-dev@... http://www.omnigroup.com/mailman/listinfo/webobjects-dev |
|
|
RE: Problem relationship with 2 eomodels
by Pierre Gilquin-2
::
Rate this Message:
<D55E1855-B1CE-4E4A-94E7-07F18F87147E@...> Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable MIME-Version: 1.0 I don't have choice=2C deployment is on WO 5.2.4 Thanks ---------------------------------------- > CC: webobjects-dev@... > From: kieran_lists@... > To: pgilquin@... > Subject: Re: Problem relationship with 2 eomodels > Date: Thu=2C 29 Oct 2009 06:51:35 -0400 > > Have you tried this with latest Project Wonder and WO 5.3.3? > > On Oct 29=2C 2009=2C at 5:33 AM=2C Pierre Gilquin wrote: > >> >> Hi all=2C >> >> I have 2 eomodels one using MySql and the second >> Oracle. >> >> I have the following Entities : EntityAFromModel1=2C >> 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=2C 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=2C 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=E7oit plus d'espace! Votre disque dur virtuel de 25 Go >> avec Windows Live SkyDrive. >> http:// >> skydrive.live.com_______________________________________________ >> WebObjects-dev mailing list >> WebObjects-dev@... >> http://www.omnigroup.com/mailman/listinfo/webobjects-dev > _________________________________________________________________ La Suisse re=E7oit plus d'espace! Votre disque dur virtuel de 25 Go avec Wi= ndows Live SkyDrive. http://skydrive.live.com= _______________________________________________ WebObjects-dev mailing list WebObjects-dev@... http://www.omnigroup.com/mailman/listinfo/webobjects-dev |
|
|
Re: Problem relationship with 2 eomodels
by Pierre G
::
Rate this Message:
I found the way to make it work in awakeFromFetch of EntityBFromModel1.
I had to set the id used for the to-one relationship in the class and I was abled to fetch the corresponding EntityCFromModel2 : public void awakeFromFetch(EOEditingContext ec) { EntityCFromModel2 entC = (EntityCFromModel2)EOUtilities.objectWithPrimaryKeyValue(ec,"EntityCFromModel2", idForRelation()); } better idea ?
|
|
|
Re: Problem relationship with 2 eomodels
by Chad Leigh-3
::
Rate this Message:
On Oct 29, 2009, at 5:15 AM, Pierre Gilquin wrote: > > <D55E1855-B1CE-4E4A-94E7-07F18F87147E@...> > Content-Type: text/plain; charset="iso-8859-1" > Content-Transfer-Encoding: quoted-printable > MIME-Version: 1.0 > > > I don't have choice=2C deployment is on WO 5.2.4 > Thanks Btw, if it helps, you can embed the WO libs into your app so it does not matter what the target machine has as installed WO. It will use the embedded WO libs instead. Just set the classpath stuff correctly Chad > > ---------------------------------------- >> CC: webobjects-dev@... >> From: kieran_lists@... >> To: pgilquin@... >> Subject: Re: Problem relationship with 2 eomodels >> Date: Thu=2C 29 Oct 2009 06:51:35 -0400 >> >> Have you tried this with latest Project Wonder and WO 5.3.3? >> >> On Oct 29=2C 2009=2C at 5:33 AM=2C Pierre Gilquin wrote: >> >>> >>> Hi all=2C >>> >>> I have 2 eomodels one using MySql and the second >>> Oracle. >>> >>> I have the following Entities : EntityAFromModel1=2C >>> 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=2C 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=2C 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=E7oit plus d'espace! Votre disque dur virtuel de 25 Go >>> avec Windows Live SkyDrive. >>> http:// >>> skydrive.live.com_______________________________________________ >>> WebObjects-dev mailing list >>> WebObjects-dev@... >>> http://www.omnigroup.com/mailman/listinfo/webobjects-dev >> > =20 > _________________________________________________________________ > La Suisse re=E7oit plus d'espace! Votre disque dur virtuel de 25 Go > avec Wi= > ndows Live SkyDrive. > http://skydrive.live.com= > _______________________________________________ > WebObjects-dev mailing list > WebObjects-dev@... > http://www.omnigroup.com/mailman/listinfo/webobjects-dev _______________________________________________ WebObjects-dev mailing list WebObjects-dev@... http://www.omnigroup.com/mailman/listinfo/webobjects-dev |
|
|
Re: Problem relationship with 2 eomodels
by Pierre G
::
Rate this Message:
Some parts of this message have been removed.
Learn more about Nabble's security policy.
>Btw, if it
helps, you can embed the WO libs into your app so it does
>not matter what the target machine has as installed WO. It will use >the embedded WO libs instead. Just set the classpath stuff correctly >Chad Thanks Chad,
I wil try this idea.
What frameworks from WO 5.3.3, i have to put
in first position ?
javaeocontrol.jar, javaeoaccess.jar
...
As I use this in a java client probably
javaeodistribution.jar (wojavaclient.jar on the client) as well.
Pierre
_______________________________________________ WebObjects-dev mailing list WebObjects-dev@... http://www.omnigroup.com/mailman/listinfo/webobjects-dev |
|
|
Re: Problem relationship with 2 eomodels
by Chuck Hill
::
Rate this Message:
I recall that having relationships between entities in different
databases is problematic in EOF. I don't recall ever doing this. I don't recall if this is completely non-functional, or if there are just some bugs. There is no reason that I can think of that it could not work. Chuck On Oct 29, 2009, at 2:33 AM, Pierre Gilquin wrote: > > 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_______________________________________________ > WebObjects-dev mailing list > WebObjects-dev@... > http://www.omnigroup.com/mailman/listinfo/webobjects-dev -- Chuck Hill Senior Consultant / VP Development Practical WebObjects - for developers who want to increase their overall knowledge of WebObjects or who are trying to solve specific problems. http://www.global-village.net/products/practical_webobjects _______________________________________________ WebObjects-dev mailing list WebObjects-dev@... http://www.omnigroup.com/mailman/listinfo/webobjects-dev |
|
|
Re: Problem relationship with 2 eomodels
by Travis Britt-2
::
Rate this Message:
It's been a couple years, and my experience was on two different
Oracle databases, but IIRC it works so long as you don't try to pre- fetch the relationship. (Or, heaven forbid, create a qualifier that attempts to traverse the relationship.) tb On Nov 2, 2009, at 4:07 PM, Chuck Hill wrote: > I recall that having relationships between entities in different > databases is problematic in EOF. I don't recall ever doing this. I > don't recall if this is completely non-functional, or if there are > just some bugs. There is no reason that I can think of that it > could not work. > > > Chuck > > > On Oct 29, 2009, at 2:33 AM, Pierre Gilquin wrote: > >> >> 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_______________________________________________ >> WebObjects-dev mailing list >> WebObjects-dev@... >> http://www.omnigroup.com/mailman/listinfo/webobjects-dev > > -- > Chuck Hill Senior Consultant / VP Development > > Practical WebObjects - for developers who want to increase their > overall knowledge of WebObjects or who are trying to solve specific > problems. > http://www.global-village.net/products/practical_webobjects > > > > > > > > _______________________________________________ > WebObjects-dev mailing list > WebObjects-dev@... > http://www.omnigroup.com/mailman/listinfo/webobjects-dev _______________________________________________ WebObjects-dev mailing list WebObjects-dev@... http://www.omnigroup.com/mailman/listinfo/webobjects-dev |
|
|
Re: Problem relationship with 2 eomodels
by Clark Mueller
::
Rate this Message:
It's a problem if you do anything that would cause EOF to write SQL
that does a join, which is definitely when you're doing prefetches or constructing a qualifier that touches both models. Traversing the relationships in memory works. For example, if you have A with a relationship to B in separate databases, you should be able to do someA.getB() since this will ultimately only require the value of A's primary key in B's database when the SQL is generated. 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. Clark On 2009-11-02, at 6:25 PM, Travis Britt wrote: > It's been a couple years, and my experience was on two different > Oracle databases, but IIRC it works so long as you don't try to pre- > fetch the relationship. (Or, heaven forbid, create a qualifier that > attempts to traverse the relationship.) > > tb > > > On Nov 2, 2009, at 4:07 PM, Chuck Hill wrote: > >> I recall that having relationships between entities in different >> databases is problematic in EOF. I don't recall ever doing this. >> I don't recall if this is completely non-functional, or if there >> are just some bugs. There is no reason that I can think of that it >> could not work. >> >> >> Chuck >> >> >> On Oct 29, 2009, at 2:33 AM, Pierre Gilquin wrote: >> >>> >>> 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_______________________________________________ >>> WebObjects-dev mailing list >>> WebObjects-dev@... >>> http://www.omnigroup.com/mailman/listinfo/webobjects-dev >> >> -- >> Chuck Hill Senior Consultant / VP Development >> >> Practical WebObjects - for developers who want to increase their >> overall knowledge of WebObjects or who are trying to solve specific >> problems. >> http://www.global-village.net/products/practical_webobjects >> >> >> >> >> >> >> >> _______________________________________________ >> WebObjects-dev mailing list >> WebObjects-dev@... >> http://www.omnigroup.com/mailman/listinfo/webobjects-dev > > _______________________________________________ > WebObjects-dev mailing list > WebObjects-dev@... > http://www.omnigroup.com/mailman/listinfo/webobjects-dev _______________________________________________ WebObjects-dev mailing list WebObjects-dev@... http://www.omnigroup.com/mailman/listinfo/webobjects-dev |
|
|
Re: Problem relationship with 2 eomodels
by Pierre G
::
Rate this Message:
>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. _______________________________________________ WebObjects-dev mailing list WebObjects-dev@... http://www.omnigroup.com/mailman/listinfo/webobjects-dev |
| Free embeddable forum powered by Nabble | Forum Help |
