druid WallConfig method setMultiStatementAllow doesn't work

ds97pgxw 于 2022-10-21 发布在 Druid

关注(0)|答案(4)|浏览(329)

WallFilter wallDefault = new WallFilter();
wallDefault.setDbType("sqlserver");
WallConfig wc = new WallConfig();
wc.setMultiStatementAllow(true);
wallDefault.setConfig(wc);
druidPlugin.addFilter(wallDefault);

batch execute Sql:

DELETE FROM    table1     WHERE main_id=?
DELETE FROM    table2     WHERE main_id=?
DELETE FROM    table3     WHERE main_id=?

Exception info: Caused by: java.sql.SQLException: sql injection violation, multi-statement not allow .
When I trace the source code class “WallProvider”,I find that "setMultiStatementAllow" doesn't work.

druid

来源：https://github.com/alibaba/druid/issues/980

4条答案

按热度按时间

fslejnso1#

这个问题应该怎么解决呢，我也是遇到这个问题了

赞(0）回复(0）举报 2022-10-21

7kqas0il2#

我也遇到类似的问题，通过在创建数据源的时候添加一个wallFilter解决了
@bean
@ConfigurationProperties(prefix = "spring.datasource")
public DataSource druidDataSource() {
DruidDataSource dataSource = new DruidDataSource();

// 设置数据源允许执行多条语句
    WallConfig wallConfig = new WallConfig();
    wallConfig.setMultiStatementAllow(true);

    WallFilter wallFilter = new WallFilter();
    wallFilter.setConfig(wallConfig);
    dataSource.getProxyFilters().add(wallFilter);

    return dataSource;
}

赞(0）回复(0）举报 2022-10-21

d7v8vwbk3#

我也遇到类似的问题，通过在创建数据源的时候添加一个wallFilter解决了
@bean
@ConfigurationProperties(prefix = "spring.datasource")
public DataSource druidDataSource() {
DruidDataSource dataSource = new DruidDataSource();

// 设置数据源允许执行多条语句
    WallConfig wallConfig = new WallConfig();
    wallConfig.setMultiStatementAllow(true);

    WallFilter wallFilter = new WallFilter();
    wallFilter.setConfig(wallConfig);
    dataSource.getProxyFilters().add(wallFilter);

    return dataSource;
}

这个可以解决,但是配置在yml文件里的配置不会赋值到datasource里

赞(0）回复(0）举报 2022-10-21

u4vypkhs4#

I have the same issue, I found out that the construct function WallFilter() was called several times, so there are several instances of WallFilter, only one of it has thetruevalue on wallConfig.multiStatementAllow . When running WallProvider.checkInternal , the config hasfalsevalue,(╯︵╰)

赞(0）回复(0）举报 2022-10-21

我来回答

druid WallConfig method setMultiStatementAllow doesn't work

4条答案

相关问题

热门标签

最新问答