本文详细介绍了h2database的事务隔离级别，包括默认的读已提交、可串行化和读未提交。在可串行化级别下，可以避免脏读、不可重复读和幻读问题。同时，文章还阐述了两阶段提交协议的工作原理，包括如何处理在网络故障等情况下处于不确定状态的事务。
Transaction Isolation
Transaction isolation is provided for all data manipulation language (DML) statements. Most data definition language (DDL) statements commit the current transaction. See the Grammar for details.
This database supports the following transaction isolation levels:
- Read Committed
This is the default level. Read locks are released immediately after executing the statement, but write locks are kept until the transaction commits. Higher concurrency is possible when using this level.
To enable, execute the SQL statementSET LOCK_MODE 3
or append
最低0.47元/天 解锁文章
805
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
