美文网首页
Mybatis 批量update error

Mybatis 批量update error

作者: 沧海月明猪有泪 | 来源:发表于2017-04-19 09:35 被阅读0次

    错误详细:###

        ### Error updating database.  Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'update t_point_send_log_201704
                         SET send_status = 5, chan' at line 16
    

    分析异常:##

    大概意思是说出现了一个语法错误

    检查sql:###

    update t_point_send_log_201704 SET send_status = ?, channel_type = ?, platform_type = ? where send_status = ? and point_group = ? and send_number = ? ; update t_point_send_log_201704 SET send_status = ?, channel_type = ?, platform_type = ? where send_status = ? and point_group = ? and send_number = ? ; update t_point_send_log_201704 SET send_status = ?, channel_type = ?, platform_type = ? where send_status = ? and point_group = ? and send_number = ? ; update t_point_send_log_201704 SET send_status = ?, channel_type = ?, platform_type = ? where send_status = ? and point_group = ? and send_number = ?
    

    sql未出现语法错误

    检查参数:###

    5(Byte), marketing(String), 2(Byte), 5(Byte), test4_2017-04-19 00:03:23(String), liqiaomu@huize.com(String), 5(Byte), marketing(String), 2(Byte), 5(Byte), test4_2017-04-19 00:03:23(String), liubin@huize.com(String), 5(Byte), marketing(String), 1(Byte), 5(Byte), test4_2017-04-19 00:03:23(String), lining@huize.com(String), 5(Byte), marketing(String), 1(Byte), 5(Byte), test4_2017-04-19 00:03:23(String), chenhuan@huize.com(String)
    

    参数未发现异常,也没有NULL的值

    没办法,google下:###

    原来是mysql默认是不支持批量update,需要加allowMultiQueries参数

    参考stackoverflow

    相关文章

      网友评论

          本文标题:Mybatis 批量update error

          本文链接:https://www.haomeiwen.com/subject/fosczttx.html