Druid数据源 sql injection violation, multi-statement not allow
问题描述:
Error updating database. Cause: java.sql.SQLException: sql injection violation, multi-statement not allow : update data set layer = ? where time = ? and id=?
解决方案:
1.数据源url
spring.datasource.druid.url=jdbc:mysql://ip:3306/db?allowMultiQueries=true&useSSL=false&serverTimezone=Asia/Shanghai
2. spring.datasource.filters的参数设置 wall
WallFilter () { WallFilter wallFilter = WallFilter()wallFilter.setConfig(())wallFilter} WallConfig () { WallConfig config = WallConfig()config.setMultiStatementAllow()config.setNoneBaseStatementAllow()config} buildDruidDataSource 中增加: List<Filter> filterList = Lists.newArrayList(wallFilter()); druidDataSource.setProxyFilters(filterList);