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

最新推荐文章于 2025-11-09 00:40:30 发布

原创最新推荐文章于 2025-11-09 00:40:30 发布 · 1.3k 阅读

1 ·

本内容遵循CC 4.0 BY-SA版权协议

标签

#sqlite #数据库 #java

SpringBoot 专栏收录该内容

6 篇文章

订阅专栏

当Druid数据源配置为SQLite时，可能会遇到因Wall过滤器不支持而引发的SQLException。为了解决这个问题，只需在配置中移除Wall过滤器即可。报错信息显示是由于SQL注入检查导致的语法错误。移除相关过滤后，Druid将能正常处理SQLite的SQL语句。

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)