Personally, I would try and avoid applications which use
complex SQL in entity beans. The whole design was initially
intended for a 1-1 mapping between entity beans and database
tables. I would rather create a denormalized layer of tables
which represent my entity beans and use some database replication
mechanism to resolve this layer into the rest of my schema then have
entity beans represent multi-table joins.
Just my $.02
>From: Pavan Venkata Tirunagari <[EMAIL PROTECTED]>
>Reply-To: Pavan V T <[EMAIL PROTECTED]>
>To: [EMAIL PROTECTED]
>Date: Wed, 27 Dec 2000 13:50:03 +0530
>
>Hi all
>
>To take the advantage of database independence which EJB offers,we need to
>use CMP EJBs.
>but from what we have seen so far most of our requirements cannot be met
>with this. We will have to use BMP Entity beans in which case there needs
>to
>be a translating tool/layer to achieve database independence.
>
>Please suggest me whether I am right and when to use CMP and BMP
>My idea goes like this complex sql queries and joins use BMP.
>
>Thanx in advance
>Pavan
>
>===========================================================================
>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".
>
_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com
===========================================================================
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".
