Hello,

I have several situations in my application where I need to be able to model
a 1 - many relationship; ie. I want to retrieve an Order object and its
related details objects.  I would like recommendations on how to do this in
ejb, preferably using CMP if feasible.  I have looked an example in on the
EJB books but the description seems very expensive from a performance
standpoint.  My read of one such example is:

When selecting the order object, you also retreive a vector of primary keys
for the detail.  You then do a findByPrimaryKey(..) on each element of the
vector.

According to this you would have a database hit for each row in the result
set when you really should only have 2 - one for the order and one for the
line items.

Thanks in advance.


Suneet

===========================================================================
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff EJB-INTEREST".  For general help, send email to
[EMAIL PROTECTED] and include in the body of the message "help".

Reply via email to