springboot druid 数据库批量更新错误 multi-statement not allow
来源:互联网 发布:天谕浅粉色头发数据 编辑:程序博客网 时间:2024/05/29 13:34
springboot druid 在写批量更新的时候出现错误
Caused by: java.sql.SQLException: sql injection violation, multi-statement not allow com.alibaba.druid.wall.WallFilter.check(WallFilter.java:714) at com.alibaba.druid.wall.WallFilter.connection_prepareStatement(WallFilter.java:240) at com.alibaba.druid.filter.FilterChainImpl.connection_prepareStatement(FilterChainImpl.java:448) at com.alibaba.druid.filter.FilterAdapter.connection_prepareStatement(FilterAdapter.java:928) at com.alibaba.druid.filter.FilterEventAdapter.connection_prepareStatement(FilterEventAdapter.java:122) at com.alibaba.druid.filter.FilterChainImpl.connection_prepareStatement(FilterChainImpl.java:448) at com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl.prepareStatement(ConnectionProxyImpl.java:342) at com.alibaba.druid.pool.DruidPooledConnection.prepareStatement(DruidPooledConnection.java:318)
需要WallConfig设置multiStatementAllow=true
@Configurationpublic class DruidDBConfig { private Logger logger = LoggerFactory.getLogger(DruidDBConfig.class); @Bean //声明其为Bean实例 @Primary //在同样的DataSource中,首先使用被标注的DataSource @ConfigurationProperties(prefix = "spring.datasource") public DataSource dataSource(){ DruidDataSource datasource = new DruidDataSource(); List<Filter> filters = new ArrayList<>(); filters.add(wallFilter); datasource.setProxyFilters(filters); return datasource; } @Autowired WallFilter wallFilter; @Bean(name = "wallConfig") WallConfig wallFilterConfig(){ WallConfig wc = new WallConfig (); wc.setMultiStatementAllow(true); return wc; } @Bean(name = "wallFilter") @DependsOn("wallConfig") WallFilter wallFilter(WallConfig wallConfig){ WallFilter wfilter = new WallFilter (); wfilter.setConfig(wallConfig); return wfilter; }}
阅读全文
0 0
- springboot druid 数据库批量更新错误 multi-statement not allow
- springboot druid 数据库批量更新错误 multi-statement not allow
- MyBatis(7)--spring boot集成MyBatis,集成Druid批量更新报错multi-statement not allow
- MySql+Mybatis+Druid:sql injection violation, multi-statement not allow
- MySql+Mybatis+Druid:sql injection violation, multi-statement not allow
- MySql+Mybatis+Druid之SqlException:sql injection violation, multi-statement not allow
- SpringBoot 使用druid监控数据库
- Statement和PreparedStatement批量更新
- Statement和PreparedStatement批量更新
- Statement和PreparedStatement批量更新
- Statement和PreparedStatement批量更新
- Statement和PreparedStatement批量更新
- Statement和PreparedStatement批量更新
- Statement和PreparedStatement批量更新
- Statement和PreparedStatement批量更新
- Statement和PreparedStatement批量更新
- Sybase数据库提示The 'CREATE TABLE' command is not allowed within a multi-statement
- Mysql 批量更新操作的时候出错 “Multi-statement transaction required more than 'max_binlog_cache_size' bytes of s
- Git与Repo入门
- 机器学习中的范数规则化之(一)L0、L1与L2范数
- Nginx配置SSL证书部署HTTPS网站
- C/C++:各种基本算法实现小结(一)—— 单链表
- Python版单进程、多进程、多线程服务器
- springboot druid 数据库批量更新错误 multi-statement not allow
- CODE[VS]1016 税收与补贴问题
- JavaWeb应用技术概述
- C++实现二分查找算法
- wordpress伪静态化之后去除category分类
- java中输入char类型的数据
- github项目学习--Vue结合Pug模板引擎
- 加深理解指针的四个实验
- clientX, pageX, offsetX, screenX