JPA: what is the proper pattern for iterating over large result sets?

by

Page 537 of Java Persistence with Hibernate gives a solution using ScrollableResults, but alas it’s only for Hibernate.

So it seems that using setFirstResult/setMaxResults and manual iteration really is necessary. Here’s my solution using JPA:

private List<Model> getAllModelsIterable(int offset, int max)
{
    return entityManager.createQuery("from Model m", Model.class).setFirstResult(offset).setMaxResults(max).getResultList();
}

then, use it like this:

private void iterateAll()
{
    int offset = 0;

    List<Model> models;
    while ((models = Model.getAllModelsIterable(offset, 100)).size() > 0)
    {
        entityManager.getTransaction().begin();
        for (Model model : models)
        {
            log.info("do something with model: " + model.getId());
        }

        entityManager.flush();
        entityManager.clear();
        em.getTransaction().commit();
        offset += models.size();
    }
}

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. How to fix the Hibernate “object references an unsaved transient instance – save the transient instance before flushing” error
  4. How to map calculated properties with JPA and Hibernate
  5. org.hibernate.HibernateException: Access to DialectResolutionInfo cannot be null when ‘hibernate.dialect’ not set
  6. Can someone explain mappedBy in JPA and Hibernate?
  7. When and why JPA entities should implement the Serializable interface?
  8. How to fetch FetchType.LAZY associations with JPA and Hibernate in a Spring Controller
  9. When to use EntityManager.find() vs EntityManager.getReference() with JPA
  10. How to use @Id with String Type in JPA / Hibernate?
  11. I found JPA, or alike, don’t encourage DAO pattern
  12. Getting Database connection in pure JPA setup
  13. Hibernate and no PK
  14. Hibernate SessionFactory vs. JPA EntityManagerFactory
  15. annotation to filter results of a @OneToMany association
  16. Hibernate/JPA – annotating bean methods vs fields [duplicate]
  17. Deploying application using Hibernate JPA 2.1 to IBM WebSphere gives NullPointerException
  18. Is it possible to dynamically define column names in Hibernate / JPA?
  19. JPA Multiple Embedded fields
  20. Hibernate: “Field ‘id’ doesn’t have a default value”
  21. Create the perfect JPA entity [closed]
  22. Delete Not Working with JpaRepository
  23. IllegalStateException with Hibernate 4 and ManyToOne cascading
  24. Force refresh of collection JPA entityManager
  25. Hibernate native query – char(3) column
  26. Hibernate triggering constraint violations using orphanRemoval
  27. JPA: How do I specify the table name corresponding to a class at runtime?
  28. How to force Hibernate to return dates as java.util.Date instead of Timestamp?
  29. Spring, JPA, and Hibernate – how to increment a counter without concurrency issues
  30. Change Table Name of an Entity on runtime? [duplicate]

Leave a Comment