druid 使用wall后,delete语句中使用partition报错

5n0oy7gb  于 5个月前  发布在  Druid
关注(0)|答案(2)|浏览(79)

sql语句为: delete from XXXX partition(P_XXX) where .....
报错信息如下:
org.springframework.jdbc.UncategorizedSQLException:
Cause: java.sql.SQLException: sql injection violation, syntax error: TODO : pos 36, line 1, column 27, token PARTITION : delete from XXXX PARTITION (P_XXX) where ID = ?
; uncategorized SQLException; SQL state [null]; error code [0]; sql injection violation, syntax error: TODO : pos 36, line 1, column 27, token PARTITION : delete from XXXX PARTITION (P_XXX) where ID = ?; nested exception is java.sql.SQLException: sql injection violation, syntax error: TODO : pos 36, line 1, column 27, token PARTITION : delete from XXXX PARTITION (P_XXX) where ID = ?
Caused by: com.alibaba.druid.sql.parser.ParserException: TODO : pos 36, line 1, column 27, token PARTITION
at com.alibaba.druid.sql.dialect.oracle.parser.OracleStatementParser.parseStatementList(OracleStatementParser.java:810)

bakd9h0s

bakd9h0s1#

使用druid-spring-boot-starter版本为1.1.21

gr8qqesn

gr8qqesn2#

升级了版本还是报sql injection violation, syntax error: TODO : pos 36, line 1, column 27, token PARTITION : 这个错,配置文件要配什么吗

相关问题