How to do orderBy with EJB (CMP)??

Greenhorn

Posts: 7

posted 21 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

What is the correct statement to do orderBy in Oracle9i dev with EJB (CMP)?? I know this is possible with EJB (BMP).

thanks,
-AARON
[ July 25, 2002: Message edited by: Long Huynh ]

Long A. Huynh ( yes, as in the primitive 64 bit Long...lol) SCJP2 "Got Java?"

Mark Spritzler

ranger

Posts: 17347

I like...

posted 21 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

I am going to move this thread to a more appropriate forum, so that you can get answers quicker.

Mark

Perfect World Programming, LLC - iOS Apps
How to Ask Questions the Smart Way FAQ

Dave Landers

Ranch Hand

Posts: 401

posted 21 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

In EJB 2.0 CMP, you specify the query in ejb-jar.xml using EJB-QL. There is no ORDER BY in EJB-QL (yet - it is coming in EJB 2.1).
I know that Weblogic has an extention to EJB-QL that includes an ORDERBY keyword. Other appservers may do something similar, but I don't know.
If the ordering is important, you are stuck with BMP. Or you could do the ordering on the client using an appropriate Comparator with the Collection returned by the finder. Ugh.

Siva Jagadeesan

Ranch Hand

Posts: 160

posted 21 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Yes Dave is correct.
Order By is introduced in the EJB1.3
Chk the EJB 1.3 public draft
Rgds
-Siva
sivajag@hotmail.com

Rgds--Siva Jagadeesan <a href="http://java2simple.blog-city.com" target="_blank" rel="nofollow">http://java2simple.blog-city.com</a> Sun Certified Java2 Programmer Sun Certified Web Component Developer BEA Certified Weblogic Server 7 Enterprise Developer

Did you see how Paul cut 87% off of his electric heat bill with 82 watts of micro heaters?