Most EAS can't do that with CMP, but there are OR mapping tools which
replace the CMP of the application server with their own CMP and provide
that functionality. For example TopLink for BEA WebLogic (Inprise is also
working on a project with TopLink-Intgration) or Avantis for IAS4
Look at http://www.objectpeople.com and http://www.avantis.de
> -----Original Message-----
> From: Amaresh Rajasekharan [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, March 23, 2000 3:43 AM
> To: [EMAIL PROTECTED]
> Subject: Entity Bean and Complex Queries
>
>
> Hi,
> I have a question about developing Entity Beans. Say,I
> have three tables
> (Two independant and one relation) and I have to use them to
> get some result.
> Now how to do this efficiently with Entity Bean model?
> Basically, I have to make a complex query like the following:
> (Just an example)
> --------------------------------------------------------------
> ------------------------------------------------
> select b.id, a.text
> from
> Atext a, AAtextrel b, ABrel c
> where
> c.id1 = &ID1 and
> c.id2 = b.id3 and
> b.text = a.text;
> --------------------------------------------------------------
> --------------------------------------------------
> One can map the CMP fields to the columns in a SINGLE table
> using the features
> provided in the standard IDEs. However, how to access
> different columns from
> different tables from a single bean? This leads to another
> question that if
> a model has 100 tables, does it mean 100 entity beans are needed to
> represent them as, in memory objects? What are the typical
> options to design
> this using EntityBean model(using CMP)?
> Thanks for your response
> Regards
> RA
>
> ==============================================================
> =============
> To unsubscribe, send email to listserv�java.sun.com and
> include in the body
> of the message "signoff EJB-INTEREST". For general help,
> send email to
> listserv�java.sun.com and include in the body of the message "help".
>
===========================================================================
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".
