Greetings.

I need to be able to change the ordering of the result returned by a named query at rutime. Initially I was trying to createFilter on the collection returned by the query, but that didn't work because collection was not persistent and Hibernate was throwing an exception.

I would like to avoid creating similar HQL queries with different ORDER BY clauses.

Is there an elegant way to order named query result at runtime? Or is there a way to add a criterion to a loaded named query?

Thanks.

You can use Collections.sort(...) to sort a collection. You need a comparator. There is code in Commons that may help:

i.e.
ComparatorChain mSort = new ComparatorChain();
mSort.addComparator(new BeanComparator("sortProp1"), false);
mSort.addComparator(new BeanComparator("sortProp2"), false);
Collections.sort(dataSet, mSort);

We have used this several places where we didn't want to duplicate query code just to put the results into a different order. While we haven't had any problems, I would think that very large collections could pose some problems.

Curtis ...

This may not work for me, because collections returned by the query may be rather large. I would prefer to be able to edit the query by specifying the "order by" clause before running it on the database.

Is there a way to adjust named query by appending "order by" clause at runtime?

Thanks.

Not that I'm aware of using HQL.

Can you use a CriteriaQuery? You can programmatically deal with the order by with those.

Good Luck,
Curtis ...

Using CriteriaQuery is not an option for me, because I am required to keep all queries separate from Java code, in hbm files.

Check out Session.createFilter(...). While I've never used it, it appears to allow adding bits of HQL for ordering. Pg 145 of H3 doc mentions it.

Curtis ...

That doesn't work. See my first message in this thread.