1.使用hibernate连接h2数据库，当把事务隔离级别设置为4时，会发生死锁错误，当设置为2时，则不会报错。
h2版本：2.1.212
hibernate版本：5.4.11.Final
2.代码如下
（1）hibernate.cfg.xml
name="hibernate.dialect">org.example.pool.NoneSequenceInformationH2Dialect
name="connection.url">jdbc:h2:file:F:\h2test\test;MODE=MySQL;AUTO_SERVER=TRUE;DB_CLOSE_DELAY=-1;DB_CLOSE_ON_EXIT=FALSE
name="connection.driver_class">org.h2.Driver
name="connection.username">test
name="connection.password">test
name="connection.provider_class">org.hibernate.c3p0.internal.C3P0ConnectionProvider
name="hibernate.connection.isolation">4
（2）实体类
@Entity
@Table(name = "tb_user")
public class EUser {
@Id
private String id;
private String name;
private String phone;
}
（3）测试代码
public void test2() throws InterruptedException {
Thread t1 = new Thread(() -> {
Session currentSession = HibernateUtils.getCurrentSession();
Transaction transaction = currentSession.beginTransaction();
EUser eUser = currentSession.get(EUser.class, "user-1");
eUser.setPhone("123335");
currentSession.merge(eUser);
transaction.commit();
System.out.println("t1----");
});
Thread t2 = new Thread(() -> {
Session currentSession = HibernateUtils.getCurrentSession();
Transaction transaction = currentSession.beginTransaction();
EUser eUser = currentSession.get(EUser.class, "user-1");
eUser.setPhone("456335");
currentSession.merge(eUser);
transaction.commit();
System.out.println("t2----");
});
t1.start();
t2.start();
t1.join();
t2.join();
}
3.运行结果
ERROR: Deadlock detected. The current transaction was rolled back. Details: "TB_USER"; SQL statement:
update tb_user set name=?, phone=? where id=? [40001-212]
Exception in thread "Thread-0" javax.persistence.OptimisticLockException: org.hibernate.exception.LockAcquisitionException: could not execute statement
at org.hibernate.internal.ExceptionConverterImpl.wrapLockException(ExceptionConverterImpl.java:277)
at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:98)
at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:181)
at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:188)
at org.hibernate.internal.SessionImpl.doFlush(SessionImpl.java:1360)
at org.hibernate.internal.SessionImpl.managedFlush(SessionImpl.java:447)
at org.hibernate.internal.SessionImpl.flushBeforeTransactionCompletion(SessionImpl.java:3233)
at org.hibernate.internal.SessionImpl.beforeTransactionCompletion(SessionImpl.java:2401)
at org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.beforeTransactionCompletion(JdbcCoordinatorImpl.java:447)
at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl.beforeCompletionCallback(JdbcResourceLocalTransactionCoordinatorImpl.java:183)
at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl.access$300(JdbcResourceLocalTransactionCoordinatorImpl.java:40)
at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl$TransactionDriverControlImpl.commit(JdbcResourceLocalTransactionCoordinatorImpl.java:281)
at org.hibernate.engine.transaction.internal.TransactionImpl.commit(TransactionImpl.java:101)
at org.example.AppTest.lambda$test2$0(AppTest.java:69)
at java.lang.Thread.run(Thread.java:748)
Caused by: org.hibernate.exception.LockAcquisitionException: could not execute statement
at org.hibernate.dialect.H2Dialect$3.convert(H2Dialect.java:351)
at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:113)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:99)
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:200)
at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:3430)
at org.hibernate.persister.entity.AbstractEntityPersister.updateOrInsert(AbstractEntityPersister.java:3292)
at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:3704)
at org.hibernate.action.internal.EntityUpdateAction.execute(EntityUpdateAction.java:201)
at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:604)
at org.hibernate.engine.spi.ActionQueue.lambda$executeActions$1(ActionQueue.java:478)
at java.util.LinkedHashMap.forEach(LinkedHashMap.java:684)
at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:475)
at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:348)
at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:40)
at org.hibernate.event.service.internal.EventListenerGroupImpl.fireEventOnEachListener(EventListenerGroupImpl.java:102)
at org.hibernate.internal.SessionImpl.doFlush(SessionImpl.java:1356)
... 10 more
Caused by: org.h2.jdbc.JdbcSQLTransactionRollbackException: Deadlock detected. The current transaction was rolled back. Details: "TB_USER"; SQL statement:
update tb_user set name=?, phone=? where id=? [40001-212]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:512)
at org.h2.message.DbException.getJdbcSQLException(DbException.java:477)
at org.h2.message.DbException.get(DbException.java:212)
at org.h2.mvstore.db.MVTable.convertException(MVTable.java:684)
at org.h2.mvstore.db.MVPrimaryIndex.lockRow(MVPrimaryIndex.java:224)
at org.h2.mvstore.db.MVPrimaryIndex.lockRow(MVPrimaryIndex.java:217)
at org.h2.mvstore.db.MVTable.lockRow(MVTable.java:555)
at org.h2.command.dml.Update.update(Update.java:76)
at org.h2.command.dml.DataChangeStatement.update(DataChangeStatement.java:74)
at org.h2.command.CommandContainer.update(CommandContainer.java:174)
at org.h2.command.Command.executeUpdate(Command.java:252)
at org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:209)
at org.h2.jdbc.JdbcPreparedStatement.executeUpdate(JdbcPreparedStatement.java:169)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:410)
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:197)
... 22 more
Caused by: org.h2.mvstore.MVStoreException: [2.1.212/105]
at org.h2.mvstore.DataUtils.newMVStoreException(DataUtils.java:1004)
at org.h2.mvstore.tx.TxDecisionMaker$RepeatableReadLockDecisionMaker.logAndDecideToPut(TxDecisionMaker.java:378)
at org.h2.mvstore.tx.TxDecisionMaker.decide(TxDecisionMaker.java:80)
at org.h2.mvstore.tx.TxDecisionMaker$LockDecisionMaker.decide(TxDecisionMaker.java:346)
at org.h2.mvstore.tx.TxDecisionMaker$LockDecisionMaker.decide(TxDecisionMaker.java:338)
at org.h2.mvstore.MVMap$DecisionMaker.decide(MVMap.java:1705)
at org.h2.mvstore.MVMap.operate(MVMap.java:1779)
at org.h2.mvstore.tx.TransactionMap.set(TransactionMap.java:346)
at org.h2.mvstore.tx.TransactionMap.lock(TransactionMap.java:312)
at org.h2.mvstore.db.MVPrimaryIndex.lockRow(MVPrimaryIndex.java:222)
... 32 more
4.如果是下面这样就没啥问题
<property name="hibernate.connection.isolation">2property>
我不是很理解，使用mysql的时候没有任何问题，使用h2就会出现这种问题，求解答！
不知道你这个问题是否已经解决, 如果还没有解决的话: