Hibernate Criteria return rows in random order

leefa · **Joined:** Wed Aug 20, 2008 1:16 pm **Posts:** 1

I am trying to return a query with the rows in random order using a hibernate criteria query. a fixed number of rows needs to be returned.

nordborg · **Posted:** Wed Aug 20, 2008 4:56 pm

Returning a fixed number of rows should be rather easy. Use the Criteria.setFirstResult() and Criteria.setMaxResults() methods.

Sorting in random order may be a bit more complicated. The only thing I can think of is to subclass the org.hibernate.criterion.Order class and implement the toSqlString() method to return something that generates:

Code:

... order by rand()

This will of course only work if your database supports it. Take a look at the MySQL documentation for an example: http://dev.mysql.com/doc/refman/5.0/en/ ... ction_rand

dilan · **Posted:** Fri Sep 19, 2008 9:46 pm

Is it possible to use crit.addOrder() to add get rand(),
im using postgres. ?

where postgres support that, according to
http://www.petefreitag.com/item/466.cfm
but i want to use within Criteria.
Please help me out..

patrycja · **Posted:** Sat Oct 25, 2008 12:21 pm

Had the same problem :)
See http://opensource.atlassian.com/projects/hibernate/browse/HHH-2381 for a solution.