Hibernate version:3.2

Hay buddies

Can I in HQL order an association? Say for instance I have "from User u left join fetch u.messages where u.id = ?"

Can I order the messages in the actual HQL? I've noticed that when using HQL the mapped collections aren't ordered the way you'd want them, even though you might map something like:

<set name="messages" cascade="all" order-by="created desc">

Help!

Thanks!

Sets can't be ordered, because the sense of sets is that they don't contain duplicates and that they are unordered.

But if you declare your message attribute as Collection instead of Set, your order-by attribute (I'm only working with annotations so I won't put my hand into the fire for it) should work. Attributes of type collection can be ordered.

Hoeft