mybatis 批量 update时报错 multi-statement not allow解决方案
原因
mysql默认不支持批量更新
Druid的multiStatementAllow默认是false
解决方案
方法一
修改application配置
- spring.datasource.url 后面加上 &allowMultiQueries=true
- 如果配置了druid 注释掉
filters: wall
,加上
filter:
wall:
config:
multi-statement-allow: true
none-base-statement-allow: true
参考如下
spring:
#mysql
datasource:
url: jdbc:xxx&serverTimezone=Asia/Shanghai&rewriteBatchedStatements=true&allowMultiQueries=true
username: xxx
password: xxx
driver-class-name: com.mysql.cj.jdbc.Driver
type: com.alibaba.druid.pool.DruidDataSource
#druid
druid:
# filters: wall
filter:
wall