[GitHub] [shardingsphere] laravelshao edited a comment on issue #8015: Sharding-jdbc transaction commit exception but update operation haven’t rollback

[GitBox <gi...@apache.org>]

laravelshao edited a comment on issue #8015:
URL: https://github.com/apache/shardingsphere/issues/8015#issuecomment-726570823


   After checking druid configuration, I haven’t find any problem. But yesterday my colleague says: Sharding-jdbc version under 3.0 has a problem which not Support batch INSERT, in my project sharding-jdbc version is 3.0.0.M1, so batch INSERT is support. But i'm wondering whether or not this batch update operation lead to this problem, and this version sharding-jdbc support or not. @cherrylzhao @kimmking 
   ```
    <update id="batchUpdateList" parameterType="java.util.List">
       <foreach collection="list" item="item" separator=";">
           update tb_rule
           set
           level = #{item.level},
           value = #{item.value},
           update_time = now()
           where
           id = #{item.id}
           and type = #{type}
           and rule_id = #{level.ruleId}
       </foreach>
   </update>
   ```


----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org