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
原创粉丝点击