java 休眠事务未正确回滚

hibernate transaction not rolling back correctly

提问by randomThought

I have 2 tables, say Item and Property and a hibernate object mapped to both. The mapping for table Item to Property looks like

我有 2 个表，比如说 Item 和 Property 以及一个映射到两者的休眠对象。表 Item 到 Property 的映射如下所示

<set name="propertySet" cascade="all-delete-orphan">
    <key column="item_id" not-null="true"/>
    <one-to-many class="Property"/>
</set>

An item can have multiple properties. Everything like select, insert works properly. but when there is an error, the inserts to the property table do not rollback.

一个项目可以有多个属性。一切像选择，插入工作正常。但是当出现错误时，对属性表的插入不会回滚。

What happens is that if i am editing an item with N properties and enter an invalid value in a field, the next time I retrieve the item, it has 2*N properties.

发生的情况是，如果我正在编辑具有 N 个属性的项目并在字段中输入无效值，则下次检索该项目时，它具有 2*N 个属性。

Edit ---

编辑 - -

What my class looks like is

我的班级看起来像

@Autowired
SessionFactory sessionFactory

@Transactional
public void updateItem(Item i){
    ...
    // The only 2 statements dealing with hibernate or session in this function
    ItemModel im = sessionFactory.getCurrentSession().get(...);

    sessionFactory.getCurrentSession().update(updatedItem);
    ...
}

I am using annotated transactions (@Transactional) with the spring framework and the lowest exception getting thrown is

我在 spring 框架中使用带注释的事务（@Transactional），抛出的最低异常是

Caused by: org.springframework.transaction.TransactionSystemException: Could not roll back Hibernate transaction; nested exception is org.hibernate.Tra
nsactionException: Transaction not successfully started
        at org.springframework.orm.hibernate3.HibernateTransactionManager.doRollback(HibernateTransactionManager.java:679)
        at org.springframework.transaction.support.AbstractPlatformTransactionManager.processRollback(AbstractPlatformTransactionManager.java:845)
        at org.springframework.transaction.support.AbstractPlatformTransactionManager.rollback(AbstractPlatformTransactionManager.java:822)
        at org.springframework.transaction.interceptor.TransactionAspectSupport.completeTransactionAfterThrowing(TransactionAspectSupport.java:412)
        at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:111)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
        at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:625)
Caused by: org.hibernate.TransactionException: Transaction not successfully started
        at org.hibernate.transaction.JDBCTransaction.rollback(JDBCTransaction.java:183)
        at org.springframework.orm.hibernate3.HibernateTransactionManager.doRollback(HibernateTransactionManager.java:676)
        at org.springframework.transaction.support.AbstractPlatformTransactionManager.processRollback(AbstractPlatformTransactionManager.java:845)
        at org.springframework.transaction.support.AbstractPlatformTransactionManager.rollback(AbstractPlatformTransactionManager.java:822)
        at org.springframework.transaction.interceptor.TransactionAspectSupport.completeTransactionAfterThrowing(TransactionAspectSupport.java:412)
        at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:111)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
        at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:625)
    ...
    ...
        at org.apache.catalina.valves.SSLValve.invoke(SSLValve.java:113)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
        at org.apache.coyote.http11.Http11NioProcessor.process(Http11NioProcessor.java:894)
        at org.apache.coyote.http11.Http11NioProtocol$Http11ConnectionHandler.process(Http11NioProtocol.java:719)
        at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:2101)
        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
        at java.lang.Thread.run(Thread.java:662)

采纳答案by Ryan Stewart

Transactions don't "cascade". At the JDBC level, a transaction consists of:

交易不会“级联”。在 JDBC 级别，事务包括：

1. Turning off autocommit
2. Executing some statements
3. Calling java.sql.Connection.commit()or java.sql.Connection.rollback().

1. 关闭自动提交
2. 执行一些语句
3. 调用java.sql.Connection.commit()或java.sql.Connection.rollback()。

If you're saying that some things are being committed and some are rolled back, then there's something wrong in your transaction management. Either autocommit is on or you actually have multiple calls to commit() happening.

如果您说有些事情正在提交而有些事情已回滚，那么您的事务管理就有问题。要么自动提交已打开，要么您实际上有多次调用 commit() 发生。

回答by atrain

Transactions are managed under the hood by Spring if you do the following: in your XML config, you need to 1) enable transactions, and 2) configure a transaction manager, as follows:

如果您执行以下操作，Spring 会在后台管理事务：在 XML 配置中，您需要 1) 启用事务，以及 2) 配置事务管理器，如下所示：

<tx:annotation-driven />
<bean id="transactionManager" class="org.springframework.orm.hibernate3.HibernateTransactionManager">
    <property name="sessionFactory" ref="mainSessionFactory" />
</bean>

Tx schemaLocation is http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-3.0.xsd"

Tx schemaLocation 是 http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-3.0.xsd"