天天看点

springboot 整合 druid监控, 批量操作报错问题

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;
        }
           

在数据源 使用之前 注入进去

继续阅读