Batch inserts with JPA/EJB3

by

Neither JPA nor Hibernate do provide particular support for batch inserts and the idiom for batch inserts with JPA would be the same as with Hibernate:

EntityManager em = ...;
EntityTransaction tx = em.getTransaction();
tx.begin();

for ( int i=0; i<100000; i++ ) {
    Customer customer = new Customer(.....);
    em.persist(customer);
    if ( i % 20 == 0 ) { //20, same as the JDBC batch size
        //flush a batch of inserts and release memory:
        em.flush();
        em.clear();
    }
}

tx.commit();
session.close();

Using Hibernate’s proprietary API in this case doesn’t provide any advantage IMO.

References

More Related Contents:

  1. JPA JoinColumn vs mappedBy
  2. How to fix the Hibernate “object references an unsaved transient instance – save the transient instance before flushing” error
  3. Difference between FetchType LAZY and EAGER in Java Persistence API?
  4. How to map a composite key with JPA and Hibernate?
  5. Hibernate Annotations – Which is better, field or property access?
  6. How to map an entity field whose name is a reserved word in JPA
  7. Do I need elements in persistence.xml?
  8. What’s the difference between JPA and Hibernate? [closed]
  9. How to map calculated properties with JPA and Hibernate
  10. What is the “owning side” in an ORM mapping?
  11. What is the solution for the N+1 issue in JPA and Hibernate?
  12. JPA CascadeType.ALL does not delete orphans
  13. What is the difference between persist() and merge() in JPA and Hibernate?
  14. Bypass GeneratedValue in Hibernate (merge data not in db?)
  15. When and why JPA entities should implement the Serializable interface?
  16. I found JPA, or alike, don’t encourage DAO pattern
  17. Getting Database connection in pure JPA setup
  18. Hibernate – @ElementCollection – Strange delete/insert behavior
  19. Hibernate/JPA – annotating bean methods vs fields [duplicate]
  20. How do I properly cascade save a one-to-one, bidirectional relationship on primary key in Hibernate 3.6
  21. JPA: Implementing Model Hierarchy – @MappedSuperclass vs. @Inheritance
  22. Is it possible to dynamically define column names in Hibernate / JPA?
  23. Doing an “IN” query with Hibernate
  24. Specifying an Index (Non-Unique Key) Using JPA
  25. The onFlushDirty Hibernate Interceptor method is never called
  26. Difference between @MapKey, @MapKeyColumn and @MapKeyJoinColumn in JPA and Hibernate
  27. Hibernate throws strange error: Class is not mapped
  28. Hibernate triggering constraint violations using orphanRemoval
  29. Hibernate vs JPA vs JDO – pros and cons of each? [closed]
  30. Clarifying terminology – What does “hydrating” a JPA or Hibernate entity mean when fetching the entity from the DB

Leave a Comment