springbooy mybaits 批量添加List到数据库，BadSqlGrammarException' exception.

Question

批量插入报错怎么办呢，数据库yml文件配置：

 master:
url: jdbc:mysql://127.0.0.1:3306/qmy-qm-platform?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=false&**allowMultiQueries=true**

mapper.xml如下：

<insert id="insertQmSearchDatas" parameterType="java.util.List">
        insert into qmy_qm_search_data(search_param,search_data,search_ec_queue,search_shareholder_ec_queue,created_time,updated_time)
        values
        <foreach collection="list" item="item" index="index" separator=",">  
            (#{item.searchParam},
            #{item.searchData},
            #{item.searchEcQueue},
            #{item.searchShareholderEcQueue},
            #{item.createdTime},
            #{item.updatedTime})  
        </foreach>  
    </insert>

service调用如下：

try {
                     status = iQmSearchDataService.insertQmSearchDatas(qmSearchDataList);

                } catch (Exception e) {
                    log.error("数据库插入异常" + e.getMessage());
                }

会的朋友加qq探讨一下 1479756648

Answer 1

能把报错完整的发一遍嘛？你这个报错里的sql不全，也不知道是不是sql错了