@Lock(LockModeType.PESSIMISTIC_WRITE) @Query("SELECT p FROM AitTaskEmailPivot p WHERE p.state = ?1 order by p.id") List<AitTaskEmailPivot> listByState(final String state);
@Lock(LockModeType.PESSIMISTIC_WRITE) PropertyValue findLockByAppCodeAndKeyAndProfileCode(String appCode, String key, String profileCode);
@Lock(LockModeType.PESSIMISTIC_WRITE) App findLockByAppCode(String appCode);
@Lock(LockModeType.PESSIMISTIC_WRITE) Profile findLockByProfileCode(String profileCode);
@Lock(LockModeType.PESSIMISTIC_WRITE) PropertyKey findLockByAppCodeAndKey(String appCode, String key);
@Lock(LockModeType.PESSIMISTIC_WRITE) Manager findLockByManagerCode(String managerCode);
@Lock(LockModeType.PESSIMISTIC_WRITE) ManagerApp findLockByManagerCodeAndAppCode(String managerCode, String appCode);
@Lock(LockModeType.PESSIMISTIC_WRITE) @Query("SELECT m FROM #{#entityName} m WHERE m.id=:transactionId") TransactionPO findOneOnLock(@Param("transactionId") Long transactionId);
@Lock(LockModeType.PESSIMISTIC_WRITE) @Query("SELECT m FROM #{#entityName} m WHERE m.transactionNo=:orderNo") List<TransactionPO> findByOrderNoOnLock(@Param("orderNo") String orderNo);
@Query("SELECT t FROM Tourinfo t WHERE t.tourCode = :tourCode") @Lock(LockModeType.PESSIMISTIC_WRITE) Tourinfo findOneForUpdate(@Param("tourCode") String tourCode);
@Query("SELECT r FROM Reserve r WHERE reserveNo = :reserveNo") @Lock(LockModeType.PESSIMISTIC_WRITE) Reserve findOneForUpdate(@Param("reserveNo") String reserveNo);
@Lock(LockModeType.PESSIMISTIC_WRITE) @Query("select u from User u where u.id = :id") User findOneForUpdate(@Param("id") UUID id);
@Lock(LockModeType.PESSIMISTIC_WRITE) @Query(name = "Version.findLatestNo") Integer findLatestNoForUpdate(int docId);
/** * Zoek een gepersisteerde {@link Selectietaak selectietaak} voor een update. * @param id het ID van de taak * @return de selectietaak */ @Query("select t from Selectietaak t where id= :id") @Lock(LockModeType.PESSIMISTIC_WRITE) Selectietaak findOneForUpdate(@Param("id") Integer id);
/** * Persists the supplied entity. * If the entity has an id and previously has been persisted, it will be merged * to the persistence context otherwise it will be inserted into the * persistence context. * * @param inEntity Entity to persist. * @return Persisted entity. */ @Lock(LockModeType.PESSIMISTIC_WRITE) T persist(T inEntity);