Select top 1 result using JPA

by

Try like this

String sql = "SELECT t FROM table t";
Query query = em.createQuery(sql);
query.setFirstResult(firstPosition);
query.setMaxResults(numberOfRecords);
List result = query.getResultList();

It should work

UPDATE*

You can also try like this

query.setMaxResults(1).getResultList();

More Related Contents:

  1. having an exception when saving oracle type object in some entity
  2. How can I make a JPA OneToOne relation lazy
  3. org.hibernate.HibernateException: Access to DialectResolutionInfo cannot be null when ‘hibernate.dialect’ not set
  4. When and why JPA entities should implement the Serializable interface?
  5. Spring Boot – Cannot determine embedded database driver class for database type NONE
  6. JPA : How to convert a native query result set to POJO class collection
  7. Why does JPA have a @Transient annotation?
  8. Spring-Data-Jpa Repository – Underscore on Entity Column Name
  9. How to persist a property of type List in JPA?
  10. Handling soft-deletes with Spring JPA
  11. Getting Database connection in pure JPA setup
  12. Hibernate and no PK
  13. When does the JPA set a @GeneratedValue @Id
  14. JPA @OneToOne with Shared ID — Can I do this Better?
  15. annotation to filter results of a @OneToMany association
  16. Parameter in like clause JPQL
  17. Hibernate/JPA – annotating bean methods vs fields [duplicate]
  18. Is it possible to dynamically define column names in Hibernate / JPA?
  19. Hibernate: “Field ‘id’ doesn’t have a default value”
  20. How to use @Transactional with Spring Data?
  21. @Basic(optional = false) vs @Column(nullable = false) in JPA
  22. Hibernate native query – char(3) column
  23. HQL joined query to eager fetch a large number of relationships
  24. Clarifying terminology – What does “hydrating” a JPA or Hibernate entity mean when fetching the entity from the DB
  25. Setting a JPA timestamp column to be generated by the database?
  26. What properties does @Column columnDefinition make redundant?
  27. DAO and Service layers (JPA/Hibernate + Spring) [duplicate]
  28. org.hibernate.loader.MultipleBagFetchException: cannot simultaneously fetch multiple bags
  29. JPA Updating Bidirectional Association
  30. Does JPA support mapping to sql views?

Leave a Comment