springboot 整合 druid监控, 批量操作报错问题
如下
WallFilter wallFilter;
@Bean(name = "wallConfig")
WallConfig wallFilterConfig(){
WallConfig wc = new WallConfig ();
//允许sql批量操作
wc.setMultiStatementAllow(true);
//允许非基本语句的其他语句
wc.setNoneBaseStatementAllow(true);
return wc;
}
@Bean(name = "wallFilter")
@DependsOn("wallConfig")
WallFilter wallFilter(WallConfig wallConfig){
WallFilter wfilter = new WallFilter();
wfilter.setConfig(wallConfig);
return wfilter;
}
@Bean(name = "test1DataSource")
@ConfigurationProperties(prefix = "datasource.primary")
@Primary
public DataSource druidDataSource() {
DruidDataSource datasource = new DruidDataSource();
List<Filter> filters = new ArrayList<>();
filters.add(wallFilter);
datasource.setProxyFilters(filters);
return datasource;
}
在数据源 使用之前 注入进去