Mybatis 批量update error

2017-04-19  本文已影响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

上一篇下一篇

猜你喜欢

热点阅读