jpa事务停止回滚

Question

我有以下代码。我希望即使有异常也要继续执行

@Transactional(noRollbackFor={PersistenceException.class, PSQLException.class,SQLGrammarException.class})
public void executeQuery(String parameterName){
    Query query = objectManager.getEntityManager().createNativeQuery("SOME UPDATE QUERY");

    Map<String, String> paramMap = (Map) destTableMap.get(parameterName);
    query.setParameter("xyz",5);

    try{
        query.executeUpdate();
    }catch(Exception ex){
         ex.printStackTrace();
    }
}

我收到异常堆栈跟踪是

Exception in thread "main" org.springframework.transaction.TransactionSystemException: Could not commit JPA transaction; nested exception is javax.persistence.RollbackException: Transaction marked as rollbackOnly
    at org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:476)
    at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:754)
    at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:723)
    at org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:393)
    at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:120)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
    at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:621)
    at 
Caused by: javax.persistence.RollbackException: Transaction marked as rollbackOnly
    at org.hibernate.ejb.TransactionImpl.commit(TransactionImpl.java:73)
    at org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:467)
    ... 11 more

Answer 1

来自the documentation

如果会话抛出异常(包括任何SQLException )，则立即回滚数据库事务，调用Session.close()并丢弃会话实例。会话的某些方法不会使会话处于一致状态。Hibernate抛出的任何异常都不能视为可恢复的。通过在finally块中调用close()来确保会话将被关闭。

必须回滚事务。因此，如果您希望在Hibernate抛出异常时继续执行，则应该将execute executeQuery方法放在它自己的事务中，在@Transactional注释中使用REQUIRES_NEW传播。这样，只会回滚这个短事务。

Answer 2

我尝试使用以下代码来避免此TransactionSystemException: org.springframework.transaction.TransactionSystemException: Could not commit JPA transaction;嵌套异常为javax.persistence.RollbackException：标记为rollbackOnly的事务

@Transactional(readOnly = false, rollbackFor = Exception.class, propagation = Propagation.REQUIRES_NEW)
public String foo(Object obj, String tableName, BindingResult result) throws Exception
{
    // put some code here
}