Search code examples
sqlhibernategrailsjdbcgroovy

SQl Query to Hibernate Query

I have a MySQL query that I use to retrieve random rows from a table. The query is:

SELECT * FROM QUESTION WHERE TESTID=1 ORDER BY RAND() LIMIT 10;

Now I need to change this query to Hibernate. Did a bit of googling but couldn't find the answer. Can someone provide help on this?

Solution

  • According to this post, you can do that :

    String query = "from QUESTION order by newid()";
Query q = session.createQuery(query);
q.setMaxResults(10);

    Not sure if it will work (especially for the random part), but you can try it :)