Implementing Optimistic lock using Hibernate and Spring

by

JPA/Hibernate Optmistic locking works by using some field to store the last modified version (e.g. timestamp, long) and then comparing the version of the entity in the session with the entity in the database to see if the change can be saved.

For this to work you need to have a field in your entity annotated with @Version.

See below for an example.

http://www.javacodegeeks.com/2012/11/jpahibernate-version-based-optimistic-concurrency-control.html

For this to work in a web application requires further thought however as if two people load the same entity for editing and then some time later submit their edits they will likely both succeed as, unless you are using some kind of long running session, the entity being edited will be reloaded from the database on form submit, populated and saved.

e.g. Entity at Revision 1

  • user 1 loads for edit: revision at 1
  • user 2 loads for edit: revision at 1
  • user 2 submits form: entity (at r1) loaded, fields are bound, entity is saved: revision is 2.
  • user 1 submits form: entity (at r2) is loaded, fields are bound, entity is saved: revision is 3.

So for this to work you could look at submitting a hidden field with the form which stores the entity revision at the time it was loaded. So, on the last step above, when user 1 submits, the revision field will be set back to 1 and the update will fail because the record in the DB as at r2.

More Related Contents:

  1. How does spring.jpa.hibernate.ddl-auto property exactly work in Spring?
  2. Spring Data JPA map the native query result to Non-Entity POJO
  3. Spring Hibernate – Could not obtain transaction-synchronized Session for current thread
  4. ${employee.id} from List in JSP throws java.lang.NumberFormatException: For input string: “id”
  5. Joining two table entities in Spring Data JPA
  6. Disable all Database related auto configuration in Spring Boot
  7. Hibernate configuring multiple datasources and multiple session factories
  8. Spring Data JPA – Multiple EnableJpaRepositories
  9. Spring Data optional parameter in query method
  10. How Do I Create Many to Many Hibernate Mapping for Additional Property from the Join Table?
  11. Spring and hibernate: No Session found for current thread
  12. Hibernate Transactions and Concurrency Using attachDirty (saveOrUpdate)
  13. @Autowired in static classes
  14. JPA / JTA / @Transactional Spring annotation
  15. Spring Transactions and hibernate.current_session_context_class
  16. Spring @Transactional with a transaction across multiple data sources
  17. Access to Session using Spring JPA and Hibernate in order to enable filters
  18. Could not build ClassFile – ArchiveException
  19. Spring Boot Data JPA – Modifying update query – Refresh persistence context
  20. PostGIS Geometry saving: “Invalid endian flag value encountered.”
  21. LazyInitializationException in JPA and Hibernate
  22. Multiple data source and schema creation in Spring Boot
  23. Spring Boot Remove Whitelabel Error Page
  24. Docker Compose + Spring Boot + Postgres connection
  25. Why did Spring framework deprecate the use of Guava cache?
  26. How can I use Spring Security without sessions?
  27. URL encoding using the new Spring UriComponentsBuilder
  28. How to inject dependencies into HttpSessionListener, using Spring?
  29. Spring 4 + Hibernate 5 = org.springframework.orm.jpa.EntityManagerHolder cannot be cast to org.springframework.orm.hibernate5.SessionHolder
  30. What is the right way to use spring MVC with Hibernate in DAO, service layer architecture

Leave a Comment