Batch Inserts Using JPA Entitymanager

Batch inserts using JPA EntityManager

It is possible to perform batch writes using JPA, but it's highly dependent on the specific implementation of your persistence provider, database and JDBC driver. For example, this article explains how to enable batch writing (optimization #8) using EclipseLink JPA 2.3 and an Oracle database.Look for similar configuration parameters in your particular environment.

JPA/Hibernate bulk(batch) insert

If you're using the database to generate ids, then Hibernate has to execute a query to generate the primary key for each entity.

How do I do JPA Batches (Insert) in EclipseLink

You can unwrap the EntityManager to a java.sql.Connection: java.sql.Connection connection = em.unwrap(java.sql.Connection.class);

Then you can use PreparedStatements as in this answer: Efficient way to do batch INSERTS with JDBC

---

Related Topics