Hibernate Criteria API: get n random rows

by

Actually it is possible with Criteria and a little bit of tweaking. Here is how:

Criteria criteria = session.createCriteria(Table.class);
criteria.add(Restrictions.eq("fieldVariable", anyValue));
criteria.add(Restrictions.sqlRestriction("1=1 order by rand()"));
criteria.setMaxResults(5);
return criteria.list();

any Restrictions.sqlRestriction will add keyword ‘and’; so to nullify its effect,
we shall add a dummy condition and inject our rand() function.

More Related Contents:

  1. Hours and seconds are lost when storing a date in the database [closed]
  2. Multiple queries executed in java in single statement
  3. Hibernate show real SQL [duplicate]
  4. How to print a query string with parameter values when using Hibernate
  5. MySQL and JDBC with rewriteBatchedStatements=true
  6. How to get SQL from Hibernate Criteria API (*not* for logging)
  7. Using Hibernate’s ScrollableResults to slowly read 90 million records
  8. Unable to get spring boot to automatically create database schema
  9. Hibernate: Automatically creating/updating the db tables based on entity classes
  10. what is the use of annotations @Id and @GeneratedValue(strategy = GenerationType.IDENTITY)? Why the generationtype is identity?
  11. No Dialect mapping for JDBC type: 1111
  12. How can you call custom database functions with Hibernate?
  13. java.sql.SQLException: No suitable driver found for jdbc:mysql://localhost:3306/dbname [duplicate]
  14. Spring boot JPA insert in TABLE with uppercase name with Hibernate
  15. Can Hibernate work with MySQL’s “ON DUPLICATE KEY UPDATE” syntax?
  16. Spring, Hibernate, Blob lazy loading
  17. Hibernate Group by Criteria Object
  18. When are connections returned to the connection pool with Spring JPA (Hibernate) Entity Manager?
  19. Hibernate Criteria Query to get specific columns
  20. com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after connection closed
  21. How to prevent SQL Injection with JPA and Hibernate?
  22. SQL Error: 0, SQLState: 08S01 Communications link failure [duplicate]
  23. Hibernate: Create Mysql InnoDB tables instead of MyISAM
  24. How to use prepared statement for select query in Java?
  25. A datetime equivalent in java.sql ? (is there a java.sql.datetime ?)
  26. How to setup Hibernate to read/write to different datasources?
  27. Get column name of property mapped with Hibernate
  28. How to escape colon `:` within a native SQL query in Hibernate?
  29. Hibernate Issue : Foreign key must have same number of columns as referenced primary key
  30. Make hibernate backquote all table / column names

Leave a Comment