Is there a way to use batch inserts in JPA?

Asked Mar 13 '15 at 07:20

Active Mar 13 '15 at 08:20

Viewed 56 times

I have thousands of SELECT statements that are executed one after the other, and it takes a lot of time in doing this(the query can be seen below), quering the DB multiple times, and also it is not possible to have a single query.

Query q = mEntityManager.createNativeQuery(newQuery);           
List<Object> results = q.getResultList();

These statemenmts go inside a dynamic loop, which creates thousands of queries, is there a way to run them in batches, like we do it for insert and delete ?

edited Mar 13 '15 at 08:20

asked Mar 13 '15 at 07:20

rd22

1,032
1
18
34

for batch insert refer [this](http://stackoverflow.com/questions/20285347/massive-insert-with-jpa-hibernate) – rd22 Mar 13 '15 at 15:38

Is there a way to use batch inserts in JPA?

0 Answers0