ibatis 批量更新与事务

最新推荐文章于 2022-07-01 11:18:14 发布

husw_2008

最新推荐文章于 2022-07-01 11:18:14 发布

阅读量6k

点赞数

分类专栏：技术文章文章标签： ibatis exception list

本文链接：https://blog.csdn.net/husw_2008/article/details/3988284

版权

技术文章专栏收录该内容

9 篇文章 0 订阅

订阅专栏

public int addMessages(List list) {
    int result = 0;
    try {
        this.getSqlMapTransactionManager().startTransaction();
        this.startBatch();
        for(int i=0;i<list.size();i++) {
             this.insert("addMessage",(Message)list.get(i));
        }
        this.executeBatch();
        this.getSqlMapTransactionManager().commitTransaction();
        result = 1;
   } catch (Exception e) {
        result = 0;
       e.printStackTrace();
} finally {
   try {
          this.getSqlMapTransactionManager().endTransaction();
    } catch (Exception e) {
          e.printStackTrace();
    }
          return result;
   }
}
这样就会报错

com.ibatis.common.jdbc.exception.NestedSQLException: Could not start transaction. Cause: com.ibatis.sqlmap.engine.transaction.TransactionException: TransactionManager could not start a new transaction. A transaction is already started.
Caused by: com.ibatis.sqlmap.engine.transaction.TransactionException: TransactionManager could not start a new transaction. A transaction is already started.
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.startTransaction(SqlMapExecutorDelegate.java:728)
at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.startTransaction(SqlMapSessionImpl.java:125)
at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.startTransaction(SqlMapClientImpl.java:102)
at com.vodone.cpms.dao.impl.MessageDaoImpl.addMessages(MessageDaoImpl.java:26)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at com.ibatis.dao.engine.impl.DaoProxy.invoke(DaoProxy.java:72)
at $Proxy1.addMessages(Unknown Source)

原因是ibatis在执行批量更新或保存的时候会新起一个事务，我们在批量更新的上面已经开始了事务，当我们开始批量操作时就会造成嵌套的事务而报错，把批量更新前的事务代码去掉就ok了！