Spring, JPA, and Hibernate – how to increment a counter without concurrency issues

by

The simplest solution is to delegate the concurrency to your database and simply rely on the database isolation level lock on the currently modified rows:

The increment is as simple as this:

UPDATE Tag t set t.count = t.count + 1 WHERE t.id = :id;

and the decrement query is:

UPDATE Tag t set t.count = t.count - 1 WHERE t.id = :id;

The UPDATE query takes a lock on the modified rows, preventing other transactions from modifying the same row before the current transaction commits (as long as you don’t use READ_UNCOMMITTED).

More Related Contents:

  1. Why does Hibernate disable INSERT batching when using an IDENTITY identifier generator
  2. Transaction marked as rollback only: How do I find the cause
  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. How to set up default schema name in JPA configuration?
  10. What is the ‘best’ way to do distributed transactions across multiple databases using Spring and Hibernate
  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. When are connections returned to the connection pool with Spring JPA (Hibernate) Entity Manager?
  14. Could not commit JPA transaction: Transaction marked as rollbackOnly
  15. Change database schema during runtime based on logged in user
  16. Spring JpaRepository – Detach and Attach entity
  17. How to map sql native query result into DTO in spring jpa repository?
  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