第一种:検索用(行Lock)のSQL文を定義する
SELECT * FROM TWMT138
WHERE KANRI_NO =
AND CTL_CNT = ?
AND DEL_ID IS NULL
FOR UPDATE NOWAIT;
第二种:
LOCK TABLE TWMT158 IN EXCLUSIVE MODE;
只有在rollback或者commit操作之后,才会解锁。
SELECT * FROM TWMT138
WHERE KANRI_NO =
AND CTL_CNT = ?
AND DEL_ID IS NULL
FOR UPDATE NOWAIT;
第二种:
LOCK TABLE TWMT158 IN EXCLUSIVE MODE;
只有在rollback或者commit操作之后,才会解锁。