错误详细:###
### 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参数
网友评论