### The error occurred while setting parameters
### SQL: UPDATE db_outbound SET batch_no=?, push_times=?, update_at=? WHERE id = ? AND is_del=0 ; UPDATE db_outbound SET batch_no=?, push_times=?, update_at=? WHERE id = ? AND is_del=0
### Cause: java.sql.SQLSyntaxErrorException: 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 db_outbound
SET batch_no='20191031110000015',
' at line 9
; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: 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 db_outbound
SET batch_no='20191031110000015',
' at line 9
原因:mybatis默认一次请求仅执行一条sql语句,需要批量操作请手动配置 jdbc.propreties文件中增加&allowMultiQueries=true