I have a table "organization" which has a reference to its self so that we have a parent org/org hierarchy. The problem is that whenever i get the children of a certain organization (say root org), the children are lazy loaded but are returned in a different order each time. Is there a way to get sorted result in a lazy loaded set ?
Thanks.

You have to tell the DB to return the results as a list instead of a hash/bag.

See http://forum.hibernate.org/viewtopic.ph ... 75#2346875 for example code.