程序员社区

Fowable oracle 数据库时 报错 sql injection violation, syntax error, expect DIMENSION, actual COMMA 错误

 

java.sql.SQLException: sql injection violation, syntax error, expect DIMENSION, actual COMMA : select a.material_type num,d.text material_type, c.equipment_model model ,c.serial_number  from mv_spm_spt_material_info a, t_ept_config b, t_ept_base_info c ,t_base_dictionary d  where b.material_id = a.id and b.equipment_id = c.base_id and a.material_type = d.value  and d.key = 'MATERIAL_TYPE' and a.module_level = 'A' and a.module_type = 'B000'  and c.serial_number = '116381' 
	at com.alibaba.druid.wall.WallFilter.check(WallFilter.java:582)
	at com.alibaba.druid.wall.WallFilter.connection_prepareStatement(WallFilter.java:185)
	at com.alibaba.druid.filter.FilterChainImpl.connection_prepareStatement(FilterChainImpl.java:446)
	at com.alibaba.druid.filter.FilterAdapter.connection_prepareStatement(FilterAdapter.java:928)
	at com.alibaba.druid.filter.FilterEventAdapter.connection_prepareStatement(FilterEventAdapter.java:122)
	at com.alibaba.druid.filter.FilterChainImpl.connection_prepareStatement(FilterChainImpl.java:446)
	at com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl.prepareStatement(ConnectionProxyImpl.java:342)
	at com.alibaba.druid.pool.DruidPooledConnection.prepareStatement(DruidPooledConnection.java:311)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.lang.reflect.Method.invoke(Unknown Source)
	at org.hibernate.jdbc.BorrowedConnectionProxy.invoke(BorrowedConnectionProxy.java:74)
	at com.sun.proxy.$Proxy32.prepareStatement(Unknown Source)
    //from www.1b23.com

wAAACH5BAEKAAAALAAAAAABAAEAAAICRAEAOw==

由于配置了druid连接池的 wall 拦截器,SQL防火墙拦截了你的SQL,解决办法:关闭wall拦截

赞(0) 打赏
未经允许不得转载:IDEA激活码 » Fowable oracle 数据库时 报错 sql injection violation, syntax error, expect DIMENSION, actual COMMA 错误

相关推荐

  • 暂无文章

一个分享Java & Python知识的社区