Dynamic EJB-QL Order By does not work

sweetfa Jul 17, 2002 4:55 AM

I have the following EJB-QL (JBoss specific) with an Order By clause.

SELECT DISTINCT OBJECT(num) FROM Numbers AS num WHERE num.phoneNumber >= ?1 AND num.phoneNumber <= ?2 ORDER BY num.phoneNumber ASC

When the query executes as a normal jboss-ql query the sort order is fine.

When the query executes as a dynamic-ql the data is always retrieved in the DESC order, regardless of the ORDER BY clause directive.

Is this a bug, that anyone is aware of or should I lodge it (or on the off-chance I have made a mistake) can someone enlighten me as to the error of my ways.

Regards

1. Re: Dynamic EJB-QL Order By does not work

sweetfa Jul 23, 2002 12:23 AM (in response to sweetfa)

You must return a Collection from your ejbSelectGeneric method. When using a Set the ordering is incorrect.
Actions
2. Re: Dynamic EJB-QL Order By does not work

simone73 Oct 17, 2002 3:34 AM (in response to sweetfa)

Hi, sweetfa.
I have a question for you.
I'm wondered about the use of the ORDER BY clause in your ejb-ql query. In fact, I'm using EJB 2.0 with JBoss and if I use the ORDER BY, I obtain a ParseException during deployment phase because EJB 2.0 does not support the ORDER BY.
So, can you tell me how can I use the ORDER BY clause?

Thanks,
Simone
Actions

Go to original post