springmvc+mybaits一个事物同时update和调用存储过程异常回滚

事物作用的impl类这样写的

1@Override
2    public int updateReturnAll(int item, int status, int idUser) {
3        // TODO Auto-generated method stub
4        try {
5            int updateReturnAll = itemMapper.update****();
6            if(updateReturnAll>0){
7                Map<String, Object> map=new HashMap<String,Object>();
8                map.put("idpatient", item);
9                map.put("ChargeDealWith", 0);
10                Object callUpdatePPFIReturn = itemMapper.callUpdate****(map);
11                System.out.println(callUpdatePPFIReturn+"==================");
12                System.out.println(map.get("RetMeg")+"----------");
13                if(!map.get("RetMeg").equals("")){
14                    throw new Exception("callUpdatePPFIReturn异常！");
15                }
16                return updateReturnAll;
17            }else{
18                return 0;
19            }
20            
21        } catch (Exception e) {
22            TransactionAspectSupport.currentTransactionStatus().setRollbackOnly();
23            logger.error("updateReturnAll异常！",e); 
24            return 0;
25        }
26    }

如果没有

1TransactionAspectSupport.currentTransactionStatus().setRollbackOnly();指定异常回滚，update是会提交的此时，为了防止提交，是需要将异常抛出的，以便让aop捕获异常再去回滚
2
3@官网文档

11.4.3. Rolling Back a Declarative Transaction
2The previous section outlined the basics of how to specify transactional settings for classes, typically service layer classes, declaratively in your application. This section describes how you can control the rollback of transactions in a simple, declarative fashion.
3
4The recommended way to indicate to the Spring Framework’s transaction infrastructure that a transaction’s work is to be rolled back is to throw an Exception from code that is currently executing in the context of a transaction. The Spring Framework’s transaction infrastructure code catches any unhandled Exception as it bubbles up the call stack and makes a determination whether to mark the transaction for rollback.
5
6In its default configuration, the Spring Framework’s transaction infrastructure code marks a transaction for rollback only in the case of runtime, unchecked exceptions. That is, when the thrown exception is an instance or subclass of RuntimeException. ( Error instances also, by default, result in a rollback). Checked exceptions that are thrown from a transactional method do not result in rollback in the default configuration.
7
8You can configure exactly which Exception types mark a transaction for rollback, including checked exceptions. The following XML snippet demonstrates how you configure rollback for a checked, application-specific Exception type:
9
10<tx:advice id="txAdvice" transaction-manager="txManager">
11    <tx:attributes>
12    <tx:method name="get*" read-only="true" rollback-for="NoProductInStockException"/>
13    <tx:method name="*"/>
14    </tx:attributes>
15</tx:advice>
16If you do not want a transaction rolled back when an exception is thrown, you can also specify 'no rollback rules'. The following example tells the Spring Framework’s transaction infrastructure to commit the attendant transaction even in the face of an unhandled InstrumentNotFoundException:
17
18<tx:advice id="txAdvice">
19    <tx:attributes>
20    <tx:method name="updateStock" no-rollback-for="InstrumentNotFoundException"/>
21    <tx:method name="*"/>
22    </tx:attributes>
23</tx:advice>
24When the Spring Framework’s transaction infrastructure catches an exception and it consults the configured rollback rules to determine whether to mark the transaction for rollback, the strongest matching rule wins. So, in the case of the following configuration, any exception other than an InstrumentNotFoundException results in a rollback of the attendant transaction:
25
26<tx:advice id="txAdvice">
27    <tx:attributes>
28    <tx:method name="*" rollback-for="Throwable" no-rollback-for="InstrumentNotFoundException"/>
29    </tx:attributes>
30</tx:advice>
31You can also indicate a required rollback programmatically. Although simple, this process is quite invasive and tightly couples your code to the Spring Framework’s transaction infrastructure. The following example shows how to programmatically indicate a required rollback:
32
33public void resolvePosition() {
34    try {
35        // some business logic...
36    } catch (NoProductInStockException ex) {
37        // trigger rollback programmatically
38        TransactionAspectSupport.currentTransactionStatus().setRollbackOnly();
39    }
40}
41You are strongly encouraged to use the declarative approach to rollback, if at all possible. Programmatic rollback is available should you absolutely need it, but its usage flies in the face of achieving a clean POJO-based architecture.

View Code