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;