>From my experience stateless session bean is a better choice for complex
lookups, especially
if they return enumeration of objects.
[EMAIL PROTECTED] (Josh Sanderson)@itglink.com> on 04/04/2000 10:49:17
AM
To: Orion-Interest <[EMAIL PROTECTED]>
cc:
Subject: RE: Is CMP is useless?
I don't know....I never thought Employees and sex mixed that well
anyways....
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Alex Paransky
Sent: Monday, April 03, 2000 9:04 PM
To: Orion-Interest
Subject: Is CMP is useless?
Is it my imagination, but the minute any kind of complex finding is
required
on an entity bean, CMP becomes useless. For example, I have entities
called
EMPLOYEE, PERSON, and SEX (M/F/Other you know).
EMPLOYEE is a PERSON with SEX.
I have a function in EmployeeHome, findFemaleEmployees(). How do I
implement this with CMP? The query has to do something like:
SELECT EMPLOYEE_ID FROM EMPLOYEE, PERSON, SEX WHERE SEX.TYPE="F" AND
EMPLOYEE.ID=PERSON.ID AND PERSON.SEX_ID = SEX.ID
Please note that SEX.ID is not the same as SEX.TYPE.
Can this be done with CMP or do I need to use BMP? If the answer is use
BMP
(and this is such a TRIVIAL) example, that it seems CMP is pretty much
useless.
-AP_