Dear Sirs,

I have BMP and CMP entities for my tables, and I need to apply complex
querries.

At first, I thought of putting CMR fields to my entities and get my data
through my relations. I was only able to do it with CMP entities and not
able to do the same with BMP entities.

The other solutions, which I think is low performant, is to gather my
data in a session and do the joins there. But in this way, I'm losing
the database performance like indexing ,... .

Now, I think of creating a CMP for the tables i need to do the complex
queries on, in addition to the existed BMP entity and stick with the
first thought.

Although, i'm going to have two entities BMP and CMP for most of the
tables, do u
think this is right?.

Anybody suggests anything?

Thanks in advance
Itani Sys.

===========================================================================
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