At 11:53 21.08.00 , you wrote:
>Robert,
>
>Are you familiar with how to use CMP Entity beans that utilize joins within
>an RDBMS.
>
>I also use Oracle and thought that you may have some familiarity with this.
>
>Thanks,
>
>Cory
yes but please post this to the mailing list so others can participate when
you find the solution and the archive gets better. search the archive for
"is cmp useless". the thread contains all the info you need. in short, you
have 2 options:
- use nested selects in your where conditions
- use the "partial=false" setting and specify the full sql query
regards,
robert
(-) Robert Kr�ger
(-) SIGNAL 7 Gesellschaft f�r Informationstechnologie mbH
(-) Br�der-Knau�-Str. 79 - 64285 Darmstadt,
(-) Tel: 06151 665401, Fax: 06151 665373
(-) [EMAIL PROTECTED], www.signal7.de
