CODEWITHSUNDEEP
hibernatejpafluent-nhibernatejpa-2.0hibernate-mapping
Łukasz Rzeszotarski
Łukasz Rzeszotarski

Reputation: 6130

Hibernate ordering in sql

Is it possible to sort the Set collection using hibernate, in sql without using SortedSet interface, without using @OrderBy annotation - just using criteria's addOrder.

I've tried it and it adds order by clause but the set isn't sorted.

I use hibernate 3.4.

Upvotes: 0

Views: 1013

Answers (2)

Manu Navarro
Manu Navarro

Reputation: 740

We will work correctly if you change the "Set" to "List" and methods that do not exist in the "List" put the equivalent.

Regards,

Upvotes: 0

user2189331
user2189331

Reputation:

NHibernate Sets don't have "order" even though the set mapping supports an order-by. See Ayende's explanation:

Note that [order-by] does not work with generic sets and that in general, you don’t want to rely on those ordering properties, you want to use the natural properties of the selected collection. Sets are, by definition, unordered set of unique elements.

You can append the order by clause to the underlying SQL, but that order is lost when NHibernate builds the set. Using an "ordered" set or other collection type (bag or list) will work, of course.

Upvotes: 1

Related Questions