OutOfMemoryError Exception in hibernate

Question

I have a OutOfMemoryError when i run my springBoot application ,

@Transaction(propagation = Propagation.REQUIRED) 
void public function() {
   subFunction() ;
}

Subfunction process file with 3000000 lines and create insert query to dataBase. The program aborted in line 1900000 with outOfMemory error.

When we analyze dump with Eclipse Memory analyzer we have that result :

Any help will be useful , thank you .

Please use the search as questions regarding batch inserting with JPA/Hibernate have been answered before. — M. Deinum
– M. Deinum, Commented Apr 19, 2021 at 13:09

Christian Beikov · Accepted Answer · 2021-04-22 07:45:55Z

1

Hibernate keeps all entities that you persist in the persistence context. If you do not need these entities anymore, you can flush and clear them out in e.g. batches of 50 items.

int lineCount = 0;
for (String line : lines) {
  // Your code
  entityManager.persist(entity);
  lineCount++;
  if ((lineCount % 50) == 0) {
      entityManager.flush();
      entityManager.clear();
  }
}

answered Apr 22, 2021 at 7:45

Christian Beikov

16.6k2 gold badges36 silver badges66 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

mohamed Over a year ago

Thanks ,I try this but it didn't solve the problem,i will add that i use nativeQuery to insert in DB.

mohamed Over a year ago

@ Christian Beikov Thanks ,I try this but it didn't solve the problem,i will add that i use nativeQuery to insert in DB.

Collectives™ on Stack Overflow

OutOfMemoryError Exception in hibernate

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related