mybatis 批量更新 【踩坑】

参考

星星满天

正题

数据库连接必须配置：&allowMultiQueries=true
mapper文件代码

<update id="updateMany"  parameterType="java.util.List" >
    <foreach collection="list" item="item" index="index" open="" close="" separator=";">
            UPDATE inf_message
        <set>
            <if test="item.messageId !=null and item.messageId >= 0 "> 
                messageId = #{item.messageId},
                    </if>
            <if test="item.segment !=null and item.segment!='' ">
                 segment=#{item.segment},  
            </if> 
            <if test="item.target !=null and item.target!='' ">
                     target=#{item.target},  
            </if> 
            <if test="item.targetReal !=null and item.targetReal!='' ">
                     targetReal=#{item.targetReal},  
            </if> 
            <if test="item.appId !=null and item.appId!='' ">
                 appId=#{item.appId},  
            </if> 
            <if test="item.source !=null and item.source!='' ">
                 source=#{item.source},  
            </if> 
        </set>
            WHERE messageId = #{item.messageId}
        </foreach>    
</update>

这些都配置好后，单元测试发现还是报错

org.springframework.jdbc.UncategorizedSQLException: 
### Error updating database.  
Cause: java.sql.SQLException: Cannot execute statement: 
impossible to write to binary log since BINLOG_FORMAT = STATEMENT 
and at least one table uses a storage engine limited to row-based logging. 
InnoDB is limited to row-logging 
when transaction isolation level is READ COMMITTED or READ UNCOMMITTED.

重点在最后一句话 transaction isolation level is READ COMMITTED or READ UNCOMMITTED.
这才发现，执行该语句方法的Spring事务用的是 READ COMMITTED，用 DEFAULT 就好了