Random SELECT from PostgreSQL database via Hibernate

Question

I'm using PostgreSQL and what I need to do is to perform a random SELECT query from a certain table in my database (via Hibernate). What would be the best way of achieving this?

Here is my code so far:

criteria.addOrder(Order.asc("RANDOM()"))

where RANDOM() is the PostgreSQL function. However, there is no property with such a name in the Entity class, and therefore, a HibernateException gets thrown.

Predrag Maric · Accepted Answer · 2015-04-17 13:55:17Z

2

You could implement your own Order class, using instructions from this blog. You would then use it like criteria.addOrder(OrderBySqlFormula.sqlFormula("RANDOM() asc"));

answered Apr 17, 2015 at 13:55

Predrag Maric

24.5k5 gold badges57 silver badges72 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Random SELECT from PostgreSQL database via Hibernate

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related