Rian,
This is much too sql centric. You should resolve your entity beans around
business methods. So I would start off by reading more about entity beans.
Theserverside.com, for example has a download on an excellent book for
entity beans. As for the sql, you are talking a one to one relationship for
the car/model and a one to many relationship for the manufacturer/model.
There should be some examples of this on the sun's j2ee site. I know that
they specifically discuss this issue.
Regards,
the elephantwalker
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Rian Schmidt
Sent: Monday, April 16, 2001 2:23 PM
To: Orion-Interest
Subject: findBy referencing another entity reference
Hi all,
How about this scenario:
There are three entities: manufacturer, model, car (as an example)
model knows directly which manufacturer it is, car knows which model it is,
but car has to do a model.getManufacturer to find out its manufacturer...
OK, so what I wanna know is can I a findByManufacturer for car? I'd
like to be able to do something like this:
query="$model.manufacturer = $1"
Now, I know that I could specify a sub-query with the actual persistence
name of the other entity's thang, something like:
query="$model in (select $model from model where manufacturer_id = $1)"
but it strikes me that Orion won't know what I'm going on about, and best
case, will have to talk to the database each time. Either way, I had to put
the persistence name into the orion-ejb-jar.xml file, which is not goodness.
Is it possible maybe to say something like:
query="model in ($1)"
where $1 is a Collection of models taken from ModelHome.findByManufacturer?
Any thoughts on the best way to approach this?
Thanks,
Rian
--
Rian Schmidt
[EMAIL PROTECTED]
