How to do the BATCH insert in JPA?

hibernate jakarta-ee jpa informix
Dinesh picture Dinesh · Sep 16, 2011 · Viewed 14.1k times · Source

I am using JPA with Hibernate persistence. We are using JPA in the following configurations.

persistence-api 1.0 version
hibernate-core 3.3.2.GA version
hibernate-entitymanager 3.4.0.GA version

Is it possible to use Batch Insert in JPA with above configuration?

Please suggest how to do BATCH insert. We want to insert multiple rows in a single table without affecting performance of Database. Also suggest how many row insert is practically possible to use in batch?

Thanks in Anticipations

Answer

Mikko Maunu picture Mikko Maunu · Sep 17, 2011

JPA itself does not have have specific support for batch insert. However, because you use Hibernate, take a look to: http://docs.jboss.org/hibernate/core/3.3/reference/en/html/batch.html

Related questions

What's the difference between JPA and Hibernate?

I understand that JPA 2 is a specification and Hibernate is a tool for ORM. Also, I understand that Hibernate has more features than JPA 2. But from a practical point of view, what really is the difference? I have experience using …

Read More
Can someone explain mappedBy in JPA and Hibernate?

I am new to hibernate and need to use one-to-many and many-to-one relations. It is a bi-directional relationship in my objects, so that I can traverse from either direction. mappedBy is the recommended way to go about it, however, I …

Read More
deleted object would be re-saved by cascade (remove deleted object from associations)

i have the following two entities: 1- PlayList: @OneToMany(fetch = FetchType.EAGER, mappedBy = "playlist", orphanRemoval = true, cascade = CascadeType.ALL) @OrderBy("adOrder") private Set<PlaylistadMap> PlaylistadMaps = new HashSet<PlaylistadMap>(0); CascadeType.ALL: is needed for save and update …

Read More