时间戳

首页 > 解决方案 > 无法回滚事务

java - 无法回滚事务

问题描述

persistence.xml

<persistence-unit name="user_per_unit" transaction-type="RESOURCE_LOCAL">
<provider>org.hibernate.jpa.HibernatePersistenceProvider</provider>
<class>com.example.User</class>
<class>com.example.Order</class>
<class>com.example.Package</class>
<exclude-unlisted-classes>true</exclude-unlisted-classes>
<properties>
    <property name="hibernate.show_sql" value="true" />
    <property name="hibernate.format_sql" value="false" />
    <property name="hibernate.hbm2ddl.auto" value="validate" />
    <property name="hibernate.jdbc.batch_size" value="100" />
    <property name="hibernate.order_inserts" value="true" />
    <property name="hibernate.order_updates" value="true" />
    <property name="hibernate.dialect" value="org.hibernate.dialect.MySQLDialect" />
</properties>

applicationContext.xml

<jpa:repositories base-package="com.example.user.repository" entity-manager-factory-ref="userEntityManagerFactory" transaction-manager-ref="userTransactionManager"/>

<bean id="userEntityManagerFactory" class="org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean">
    <property name="persistenceUnitName"    value="user_per_unit" />
    <property name="dataSource"             ref="userDataSource" />
    <property name="jpaVendorAdapter"       ref="jpaVendorAdapter" />
    <property name="jpaProperties">
        <props>
            <prop key="hibernate.show_sql">true</prop>
            <prop key="hibernate.format_sql">false</prop>
        </props>
    </property>
</bean>

<bean id="userTransactionManager" class="org.springframework.orm.jpa.JpaTransactionManager">
    <property name="entityManagerFactory" ref="userEntityManagerFactory" />
</bean>

<bean id="userDataSource" class="org.apache.commons.dbcp2.BasicDataSource">
    <property name="driverClassName" value="${driver}" />
    <property name="url" value="${url}" />
    <property name="username" value="${username}" />
    <property name="password" value="${password}" />
    <property name="initialSize" value="${size}" />
    <property name="maxTotal" value="${maxtotal}" />
    <property name="maxIdle" value="${maxidle}" />
    <property name="minIdle" value="${minidle}" />
</bean>

Class

@Autowired
private ApplicationContext applicationContext;
private JpaTransactionManager userTransactionManager;
private EntityTransaction userTx;

userTransactionManager = (JpaTransactionManager) applicationContext.getBean("provTransactionManager");
userTx = provTransactionManager.getEntityManagerFactory().createEntityManager().getTransaction();

userTx.begin();
boolean isUpdateSuccess = updateViaUserRepository(...);
if(!isUpdateSuccess) {
    userTx.rollback();
} else {
    userTx.commit();
}

我的代码正在到达userTx.rollback();，但实际数据库没有回滚。我的persisence或applicationContext配置中是否有任何错误。

编辑：我所有的桌子都有引擎InnoDb

标签： javahibernatetransactionsspring-data-jparollback

解决方案

首先要查找：您使用的表类型是什么？

例如对于 MySQL，MyISAM 表不支持事务，这意味着您必须使用另一种表类型（例如 InnoDB）。

推荐阅读