Why does Hibernate disable INSERT batching when using an IDENTITY identifier generator

by

Transactional write-behind

Hibernate tries to defer the Persistence Context flushing up until the last possible moment. This strategy has been traditionally known as transactional write-behind.

The write-behind is more related to Hibernate flushing rather than any logical or physical transaction. During a transaction, the flush may occur multiple times.

The flushed changes are visible only for the current database transaction. Until the current transaction is committed, no change is visible by other concurrent transactions.

IDENTITY

The IDENTITY generator allows an int or bigint column to be auto-incremented on demand. The increment process happens outside of the current running transaction, so a roll-back may end up discarding already assigned values (value gaps may happen).

The increment process is very efficient since it uses a database internal lightweight locking mechanism as opposed to the more heavyweight transactional course-grain locks.

The only drawback is that we can’t know the newly assigned value prior to executing the INSERT statement. This restriction is hindering the transactional write-behind flushing strategy adopted by Hibernate. For this reason, Hibernates disables the JDBC batch support for entities using the IDENTITY generator.

TABLE

The only solution would be to use a TABLE identifier generator, backed by a pooled-lo optimizer. This generator works with MySQL too, so it overcomes the lack of database SEQUENCE support.

However, the TABLE generator performs worse than IDENTITY, so in the end, this is not a viable alternative.

Conclusion

Therefore, using IDENTITY is still the best choice on MySQL, and if you need batching for insert, you can use JDBC for that.

More Related Contents:

  1. Transaction marked as rollback only: How do I find the cause
  2. Spring, JPA, and Hibernate – how to increment a counter without concurrency issues
  3. Error creating bean with name ‘entityManagerFactory’ defined in class path resource : Invocation of init method failed
  4. Bypass GeneratedValue in Hibernate (merge data not in db?)
  5. How does the FetchMode work in Spring Data JPA
  6. How to fetch FetchType.LAZY associations with JPA and Hibernate in a Spring Controller
  7. No Dialect mapping for JDBC type: 1111
  8. @Transactional method called from another method doesn’t obtain a transaction
  9. What is the ‘best’ way to do distributed transactions across multiple databases using Spring and Hibernate
  10. Spring data JPA and hibernate detached entity passed to persist on ManyToMany relationship
  11. Can I combine a @Query definition with a Specification in a Spring Data JPA repository method?
  12. Do you need a database transaction for reading data?
  13. Could not commit JPA transaction: Transaction marked as rollbackOnly
  14. Change database schema during runtime based on logged in user
  15. Spring JpaRepository – Detach and Attach entity
  16. How to map sql native query result into DTO in spring jpa repository?
  17. Difference between save and saveAndFlush in Spring data jpa
  18. The onFlushDirty Hibernate Interceptor method is never called
  19. javax.transaction.Transactional vs org.springframework.transaction.annotation.Transactional
  20. spring data jpa @query and pageable
  21. How to rollback a database transaction when testing services with Spring in JUnit?
  22. Hibernate, spring, JPS & isolation – custom isolation not supported
  23. HibernateException: Couldn’t obtain transaction-synchronized Session for current thread
  24. Error creating bean with name ‘entityManagerFactory
  25. How to configure transaction management for working with 2 different db in Spring?
  26. Mapping JPA or Hibernate projection query to DTO (Data Transfer Object)
  27. java.lang.IllegalStateException: No transactional EntityManager available
  28. FetchMode join makes no difference for ManyToMany relations in spring JPA repositories
  29. TransactionRequiredException Executing an update/delete query
  30. How to find distinct rows with field in list using JPA and Spring?

Leave a Comment