mysql+mybatis 批量更新错误百思不得其解 求指导

数据库配置

<bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource" init-method="init" destroy-method="close">
<property name="url" value="jdbc:mysql://192.168.0.246:8866/cust_identity?allowMultiQueries=true&amp;characterEncoding=UTF-8" />
        <property name="username" value="1" />
        <property name="password" value="1" />
        <property name="initialSize" value="1" />
        <property name="minIdle" value="1" />
        <property name="maxActive" value="10" />
        <property name="maxWait" value="60000" />
        <property name="timeBetweenEvictionRunsMillis" value="60000" />
        <property name="minEvictableIdleTimeMillis" value="300000" />
        <property name="validationQuery" value="select  1  from dual" />
        <property name="testWhileIdle" value="true" />
        <property name="testOnBorrow" value="false" />
        <property name="testOnReturn" value="false" />
    </bean>

 

sql：

<update id="updatehandleResult" parameterType="java.util.List">
        <foreach  close="" index="index"   open="" collection="list" separator=";" item="rel">
           UPDATE DEGREE_CUST_NODE_REL SET  CHECK_RESULT = #{rel.checkResult}  WHERE  DEGREE_CUST_NODE_REL_ID = #{rel.relId}  
        </foreach>
     
    </update>

 

 

报错

 

org.springframework.jdbc.BadSqlGrammarException: 
### Error updating database.  Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check sql ERROR. UPDATE DEGREE_CUST_NODE_REL
SET CHECK_RESULT = '1'
WHERE DEGREE_CUST_NODE_REL_ID = 64
### The error may involve commonmodel.updatehandleResult-Inline
### The error occurred while setting parameters
### SQL: UPDATE DEGREE_CUST_NODE_REL SET  CHECK_RESULT = ?  WHERE  DEGREE_CUST_NODE_REL_ID = ?            ;             UPDATE DEGREE_CUST_NODE_REL SET  CHECK_RESULT = ?  WHERE  DEGREE_CUST_NODE_REL_ID = ?
### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check sql ERROR. UPDATE DEGREE_CUST_NODE_REL
SET CHECK_RESULT = '1'
WHERE DEGREE_CUST_NODE_REL_ID = 64
; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check sql ERROR. UPDATE DEGREE_CUST_NODE_REL
SET CHECK_RESULT = '1'
WHERE DEGREE_CUST_NODE_REL_ID = 64
    at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:231)
    at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73)
    at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:73)
    at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:397)
    at com.sun.proxy.$Proxy50.update(Unknown Source)

 

在网上看 是因为数据库url要配置allowMultiQueries  可是配置了 依然不允许批量