SQLIntegrityConstraintViolationException导致Spring事务回滚

Question

Spring 4.1.4 Hibernate 4.2.0 JDK 1.8

我的上下文：我有一个控制器调用-->Service-->调用Dao业务功能是删除（在1到许多DB关系中）一些子级，但不是所有子级。然后，在删除了一些子项之后，我尝试删除父项，然后我得到了java.sql.SqlIntegrityConstraintViolationException

@Transactional(noRollbackFor = SQLIntegrityConstraintViolationException.class)

public void delete() {
    FacesMessage msg = new FacesMessage(FacesMessage.SEVERITY_INFO, "Data deleted.","");
    
    try{
        memoTemplateService.delete(memoTemplate);
        memoTemplates.remove(memoTemplate);
    }
    catch (Exception e){
        msg=new FacesMessage(FacesMessage.SEVERITY_WARN, "A","B");
    }
    reset();

    
    FacesContext.getCurrentInstance().addMessage(null, msg);
}

@Override
@Transactional(noRollbackFor =  {SQLIntegrityConstraintViolationException.class,DBConstraintException.class})
public void delete(MemoTemplate memoTemplate)throws BusinessException {
    // deleting some ,not all , child 
    phaseAndMemoGenerator.deleteMemosForVisibleTimeHorizon(memoTemplate);
    try{// some times Template cannot be deleted
        memoTemplateDao.delete(memoTemplate);
    }
    catch (Exception e){
        throw new DBConstraintException("Partial Delete", "Template cannot be deleted, Memo in the past are present");
    }
}

@Repository(value = "memoTemplateDao")
public class MemoTemplateDaoImpl extends GenericJpaDaoImpl<MemoTemplate,  Long> implements MemoTemplateDao {

@Override
@Transactional(noRollbackFor = SQLIntegrityConstraintViolationException.class)
public void delete(MemoTemplate t) {
    super.delete(t);
    em.flush();
}
}

@Transactional(noRollbackFor = {SQLIntegrityConstraintViolationException.class,PersistenceException.class})
public void tryToDelete(MemoTemplate t)throws Exception {
    super.delete(t);
    try{
        em.flush();
    }
    catch (Exception e){
        throw new Exception("ddddd");
    }
}

Answer 1

如果在DB中定义了约束，您将无法通过提交而不回滚来绕过它们。