druid使用sqlite数据源时filter不支持wall

最新推荐文章于 2024-02-05 11:27:51 发布

yunfeather

最新推荐文章于 2024-02-05 11:27:51 发布

阅读量961

点赞数

分类专栏： SpringBoot 文章标签： sqlite 数据库 java

本文链接：https://blog.csdn.net/yunfeather/article/details/126029889

版权

SpringBoot 专栏收录该内容

6 篇文章 0 订阅

订阅专栏

druid使用sqlite数据源时filter不支持wall

1.解决方案：

druid数据源配置项的filter一项中，去掉wall即可

2.报错信息

java.sql.SQLException: sql injection violation, dbType sqlite, , druid-version 1.2.2, syntax error: syntax erro
at com.alibaba.druid.wall.WallFilter.checkInternal(WallFilter.java:849)
	at com.alibaba.druid.wall.WallFilter.connection_prepareStatement(WallFilter.java:292)
	at com.alibaba.druid.filter.FilterChainImpl.connection_prepareStatement(FilterChainImpl.java:568)
	at com.alibaba.druid.filter.FilterAdapter.connection_prepareStatement(FilterAdapter.java:930)
	at com.alibaba.druid.filter.FilterEventAdapter.connection_prepareStatement(FilterEventAdapter.java:122)
	at com.alibaba.druid.filter.FilterChainImpl.connection_prepareStatement(FilterChainImpl.java:568)
	at com.alibaba.druid.wall.WallFilter.connection_prepareStatement(WallFilter.java:295)
	at com.alibaba.druid.filter.FilterChainImpl.connection_prepareStatement(FilterChainImpl.java:568)
	at com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl.prepareStatement(ConnectionProxyImpl.java:341)
	at com.alibaba.druid.pool.DruidPooledConnection.prepareStatement(DruidPooledConnection.java:351)