在SQLServer 2008R2 中，开启filter，后台报com.alibaba.druid.sql.parser.ParserException: syntax error, error in :'PXXK a (nolock) inner join ', expect RPAREN, actual LPAREN pos 271, line 11, column 32, token LPAREN

qgelzfjb 于 2022-10-27 发布在 Druid

关注(0)|答案(3)|浏览(625)

请不要忘记SQLServer啦！！！

org.springframework.jdbc.UncategorizedSQLException:

Error querying database. Cause: java.sql.SQLException: sql injection violation, syntax error: syntax error, error in :'PXXK a (nolock)

inner join ', expect RPAREN, actual LPAREN pos 271, line 11, column 32, token LPAREN : select count(0) from (
    SELECT b.xh Xh,b.spxh Spxh,a.spbz Spbz,
    a.sqrmc Sqrmc,
    b.ypmc Ypxmmc,
    b.sl Sqsl,
    b.ts Sqts,
    a.msg Wgxx
    ,a.sqmbdm Sqmbdm
    ,b.idm Idm
    ,b.ypdm Ypdm
    from XXX_SPXXK a (nolock)
    inner join XXX_WGMXK b( NOLOCK ) on (a.xh=b.spxh)
     WHERE  a.sqrq>=  CONVERT(varchar(100),  ?, 112)
            and a.sqrq <=? 
    ) as c

druid

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

3条答案

按热度按时间

pb3s4cty1#

Springboot2.3.0
Druid version: 1.1.22
DataBase type: SQLServer 2008 R2

yml file config：

druid: filter: wall: enabled: true config: multi-statement-allow: true comment-allow: true none-base-statement-allow: true stat: enabled: true merge-sql: true db-type: sqlserver log-slow-sql: true slow-sql-millis: 5000

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

hts6caw32#

close wall can fix your question

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

xwmevbvl3#

close wall can fix your question

是的，目前我的项目中已经关闭了wall等功能！但我想用这个功能，因为druid本身就是为监控而生的。

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