pessimistlock exception when saving data in loop

manpreet Best Answer 2 years ago

I am getting pesimistlockexception when trying to persist multiple object of same time through JPA. Here is my code for reference

 @Override
@Transactional(propagation = Propagation.REQUIRED, rollbackFor = Exception.class)
public Boolean changeDplListMappingByCustomWatchList(List<Integer> dplIds, Integer customWatchListId,
    ServiceRequestor customServiceRequestor) {

            for(Integer dplId : dplIds) {
                if(dplId != null) {
                    CustomWatchListDplMapping customWatchListDplMapping = new CustomWatchListDplMapping();
                    customWatchListDplMapping.setDplId(dplId);
                    customWatchListDplMapping.setWatchListId(customWatchListId);

                    this.create(customWatchListDplMapping);
                }
            }
    }
    catch(Exception e) {
        LOG.error("Exception occured while changing dpl mapping by custom watchList id", e);
    }

    return true;
}
 public void create(Model entity) {

    manager.persist(entity);
    manager.joinTransaction();
}

After first entity when it iterate through second one it throws an exception. If it has only one entity to save then it works well, but for more than one entity model it throws this exception.

manpreet 2 years ago

by default pessimistic lock is for 1 second so please do the changes in the properties file it will help you to unlock and you will be able to save into database