Hi,

how can I order my result set by the size of a set ( i do not want to sort the set itself, i want to get the users with the most certificates first )

What is the correct way to do this ?

Thanks


Hibernate version:
3.2.6

Mapping documents:
<class name="User" table="user" batch-size="20">
<set name="certificates" table="certificate_info" inverse="true" batch-size="20">
<key column="user_id" />
<one-to-many class="de.tendme.backend.model.certificate.CertificateInfo"/>
</set>
</class>


Name and version of the database you are using:

MySQL 5.1

The generated SQL (show_sql=true):

[ from de.tendme.backend.model.Provider p where p.user.userState=? and p.user.country.id =? and p.activated = true ORDER BY p.user.certificates DESC]

SQL : select [...] where [...] user1_.country_id=? and petcarepro0_1_.is_activated=1 order by . DESC

We had an extensive discussion in this forum, including some problems that occur for particular databases.