intermediateTop 30 Scenario-Based Questions
How do you implement optimistic locking in a Spring Boot application with JPA?
JPA @Version annotation: @Entity public class Order { @Id Long id; @Version Integer version; ... }. JPA auto-handles: on UPDATE, includes AND version = :current in the WHERE clause. On 0 rows updated: throws OptimisticLockException (DataAccessException in Spring). SQL generated: UPDATE orders SET ... version = version+1 WHERE id = ? AND version = ?. Spring retry: @Retryable(value=OptimisticLockExc
This is a Pro chapter
Sign in, then upgrade to Pro or Power to unlock this and the full Databases Mastery library.
How do you implement optimistic locking in a Spring Boot application with JPA?