a short question that should be easy to answer: Can I assume the collection returned from the following finder is ordered and can be iterated in the assumed order?
Entia non sunt multiplicanda praeter necessitatem
posted 10 years ago
As far as I remember EJB-QL does not support the ORDERBY clause. However most of the containers provide extension to the standard EJB-QL including DISTINCT, ORDERBY, aggregate functions (COUNT, AVG, SUM, MIN, MAX), subqueries, etc. If you�re using WebLogic for example, your assumption is correct: the collection will be ordered properly. I would rather believe that the above assumption is correct for all containers that support the ORDERBY clause. Regards.