import org.springframework.data.jpa.repository.Lock; import org.springframework.data.jpa.repository.Query; import org.springframework.data.repository.CrudRepository; import org.springframework.data.repository.query.Param; import javax.persistence.LockModeType; public interface PersonRepository extends CrudRepositoryIn this example Person is an entity and I want to lock a Person record based on id. The service layer method must be in transaction to use this method.{ @Lock(LockModeType.PESSIMISTIC_WRITE) @Query("select p from Person p where p.id = :id") Person findOneAndLock(@Param("id") int id); }
Showing posts with label spring-data. Show all posts
Showing posts with label spring-data. Show all posts
Sunday, February 7, 2016
Spring data JPA Pessimistic lock
If you want to lock a database record to execute certain business logic and do not want any other thread to update the same then do the following -
Subscribe to:
Posts (Atom)