I have a situation where I want to get an ordered list of objects and each object contains a mapped set. I would also like the mapped set to be ordered. If I include both in the order by of my HQL then the proper SQL gets generated and the list of objects gets sorted properly. However, the set collection within each object are not ordered.

I tried adding an order-by clause to my set mapping, however, this seems to override my HQL order by completely. So now the list of objects comes back unordered with the set collection for each object ordered properly.

Is there any way to have both an ordered list of objects, each containing an ordered set collection using either HQL or a setting in the mapping?

Thanks!

Hmm. In Hibernate 3.0, using an order-by in the set mapping completely overrides any order by clause in my HQL. However, in Hibernate 2.1 it concatenates the set mapped order-by to the HQL order by, thus generating the SQL I'm looking for.

Is this a bug with 3.0?

sounds like a bug, please report to jira