SET ISOLATION æ–‡

SET ISOLATIONæ–‡ã?«ã‚ˆã‚ŠæŽ¥ç¶šã?®åˆ†é›¢ãƒ¬ãƒ™ãƒ«ã‚’変更ã?™ã‚‹ã?“ã?¨ã?Œã?§ã??ã?¾ã?™ã€‚ã?¨ã‚‹ã?“ã?¨ã?®ã?§ã??る分離レベルã?¯SERIALIZABLEã€?REPEATABLE READã€?READ COMMITTEDã€?READ UNCOMMITTEDã?§ã?™ã€‚

ã?“ã?®æ–‡ã‚’発行ã?™ã‚‹ã?¨ç?¾åœ¨ã?®ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã?¯å¸¸ã?«ã‚³ãƒŸãƒƒãƒˆã?•れã?¾ã?™ã€‚JDBCã?®java.sql.Connection.setTransactionIsolationメソッドã?¯ã€?唯一ã?¤ã?®ä¾‹å¤–を除ã??ã€?ã?“ã?®ã‚³ãƒžãƒ³ãƒ‰ã?¨ã?»ã?¼å?Œã?˜ã‚‚ã?®ã?§ã?™ã€‚組込ã?¿ã?®ãƒ‰ãƒ©ã‚¤ãƒ?を使ã?£ã?¦java.sql.Connection.setTransactionIsolationを呼んã? å ´å?ˆã€?分離レベルを変更ã?—ã?ªã?‘れã?°(ã?¤ã?¾ã‚Šç?¾åœ¨ã?®å€¤ã‚’分離レベルã?¨ã?—ã?¦è¨­å®šã?—ã?Ÿå ´å?ˆ)ã€?ç?¾åœ¨ã?®ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã?¯ã‚³ãƒŸãƒƒãƒˆã?•れã?¾ã?›ã‚“。

分離レベルã?«ã?¤ã?„ã?¦ã?®æƒ…å ±ã?¯ã€?Derby ディベロッパーズ ガイドã?«ã?‚ã‚‹ã€?"ロックã€?å?Œæ™‚平行度ã€?分離"ã‚’å?‚ç…§ã?—ã?¦ã??ã? ã?•ã?„。JDBCã?®java.sql.Connection.setTransactionIsolationメソッドã?«ã?¤ã?„ã?¦ã?¯ã€?java.sql.Connection.setTransactionIsolation メソッドをå?‚ç…§ã?—ã?¦ã??ã? ã?•ã?„。

æ§‹æ–‡

SET [ CURRENT ] ISOLATION [ = ]
{
UR | DIRTY READ | READ UNCOMMITTED
CS | READ COMMITTED | CURSOR STABILITY
RS |
RR | REPEATABLE READ | SERIALIZABLE
RESET 
}
set isolation serializable;
関連資料
SET SCHEMA æ–‡