mybatis用foreach插入多条会报错，一条就没事，说是有格式错误

Question

这个是xml文件：

下面的报错：

### Error updating database.  Cause: java.sql.SQLException: sql injection violation, syntax error: TODO : COMMA values : insert into BIA_HGU_INFO (HGU_ID, AREA_CODE, BIND_CODE, 
      SN, HGU_MAC, PRODUCT_CLASS, 
      HGU_VENDOR, SOFTWARE_VERSION, WIFI_FLAG, 
      PPPOE_USER, VOIP_USER, REMARK, 
      DEV_TYPE)
    values 
          
        (
          ?, 
          ?, 
          ?, 
          ?, 
          ?, 
          ?, 
          ?, 
          ?, 
          ?, 
          ?, 
          ?, 
          ?, 
          ?
        )
         , 
        (
          ?, 
          ?, 
          ?, 
          ?, 
          ?, 
          ?, 
          ?, 
          ?, 
          ?, 
          ?, 
          ?, 
          ?, 
          ?
        )
         
        ;

Answer 1

<insert id="insertBatch" parameterType="java.util.List" useGeneratedKeys="false">
        INSERT INTO BIA_HGU_INFO (HGU_ID, AREA_CODE, BIND_CODE,
        SN, HGU_MAC, PRODUCT_CLASS, HGU_VENDOR, SOFTWARE_VERSION, WIFI_FLAG,
        PPPOE_USER, VOIP_USER, REMARK,
        DEV_TYPE)
        <foreach collection="hguInfolist" item="hguInfo" index="index" separator="union all">
            (SELECT
            #{hguInfo.hguId, jdbcType=VARCHAR},
            #{hguInfo.areaCode, jdbcType=VARCHAR},
            #{hguInfo.bindCode, jdbcType=VARCHAR},
            #{hguInfo.sn, jdbcType=VARCHAR},
            #{hguInfo.hguMac, jdbcType=VARCHAR},
            #{hguInfo.productClass, jdbcType=VARCHAR},
            #{hguInfo.hguVendor, jdbcType=VARCHAR},
            #{hguInfo.softwareVersion, jdbcType=VARCHAR},
            #{hguInfo.wifiFlag, jdbcType=DECIMAL},
            #{hguInfo.pppoeUser, jdbcType=VARCHAR},
            #{hguInfo.voipUser, jdbcType=VARCHAR},
            #{hguInfo.remark, jdbcType=VARCHAR},
            #{hguInfo.devType, jdbcType=DECIMAL}
            FROM dual
            )
        </foreach>
    </insert>

Answer 2

你应该用的druid的连接池吧，目测是druid的版本问题：
sql 里面没有Comment，抛异常 syntax error, COMMA values
升级druid看能不能好

Answer 3

values里面多个值的写法，不是sql标准功能，我知道的只有mysql支持。