java.sql.SQLException: sql injection violation, class com.alibaba.druid.sql.ast.statement.SQLCommentStatement not allow : comment on table jswoa1.con_attach is '附件表'


Solutions on the web

Solution icon of github
sql injection violation, class com.alibaba.druid.sql.ast.statement.SQLCommentStatement not allow : comment on table jswoa1.con_attach is ''

Solution icon of github
via GitHub by chinaxy
, 6 months ago
sql injection violation, class com.alibaba.druid.sql.ast.statement.SQLCommentStatement not allow : comment on column OPERATOR.eid is 'ID'

Solution icon of github
via GitHub by takeseem
, 1 year ago
sql injection violation, part alway true condition not allow : select count(personalin0_.i_id) as col_0_0_ from t_hr_personal_info personalin0_ cross join t_hr_staff staff1_ where personalin0_.i_staff_id=staff1_.i_id and 1=1 and staff1_.sstaffaccount=?

Solution icon of github
sql injection violation, part alway true condition not allow : select count(personalin0_.i_id) as col_0_0_ from t_hr_personal_info personalin0_ cross join t_hr_staff staff1_ where personalin0_.i_staff_id=staff1_.i_id and 1=1 and staff1_.sstaffaccount=?

Solution icon of github
sql injection violation, syntax error: ERROR. token : DESC, pos : 106 : SELECT BANK_CODE, CONN_LOCATION_TYPE, OUTER_KEYLABEL_NAME, INNER_KEYLABEL_NAME, DESC, COMMENT, STATUS, DB_TIMESTAMP FROM EGL_SYS_KEYLABEL_CONVERT_DEF WHERE STATUS='1'

Solution icon of github
sql injection violation, syntax error: syntax error, error in :'Rep` CHARACTER SET utf8 COLLATE utf',expect IDENTIFIER, actual IDENTIFIER CHARACTER : CREATE DATABASE `testRep` CHARACTER SET utf8 COLLATE utf8_general_ci

Solution icon of github
via GitHub by wing1000
, 1 year ago
sql injection violation, syntax error: syntax error, error in :'like "%"?"%" and status = 'display'',expect QUES, actual QUES % : select * from article where title like "%"?"%" and status = 'display' and `check` = 'yes' order by createTime desc limit ?,?

Solution icon of github
sql injection violation, syntax error: syntax error, error in :'d by "xxx" using '(DESCRIPTION = (A',expect IDENTIFIER, actual LITERAL_ALIAS xxx: create database link db_link connect to "xxx" identified by "xxx" using '(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = orcl)))'

Solution icon of stackoverflow
sql injection violation, deny object : dbms_random : select distinct (a.demand_id) as demand_id, a.demand_title as demand_title, f.product_version_id, h.name, to_char(a.qa_time, 'yyyy-mm-dd') as qa_time, e.op_name as op_name

Stack trace

java.sql.SQLException: sql injection violation, class com.alibaba.druid.sql.ast.statement.SQLCommentStatement not allow : comment on table jswoa1.con_attach is '附件表'
	at com.alibaba.druid.wall.WallFilter.check(WallFilter.java:726)
	at com.alibaba.druid.wall.WallFilter.statement_executeUpdate(WallFilter.java:525)
	at com.alibaba.druid.filter.FilterChainImpl.statement_executeUpdate(FilterChainImpl.java:2375)
	at com.alibaba.druid.filter.FilterAdapter.statement_executeUpdate(FilterAdapter.java:2486)
	at com.alibaba.druid.filter.FilterEventAdapter.statement_executeUpdate(FilterEventAdapter.java:327)
	at com.alibaba.druid.filter.FilterChainImpl.statement_executeUpdate(FilterChainImpl.java:2375)
	at com.alibaba.druid.proxy.jdbc.StatementProxyImpl.executeUpdate(StatementProxyImpl.java:225)
	at com.alibaba.druid.pool.DruidPooledStatement.executeUpdate(DruidPooledStatement.java:164)
	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.jdbcdslog.StatementLoggingHandler.invoke(StatementLoggingHandler.java:27)
	at com.sun.proxy.$Proxy84.executeUpdate(Unknown Source)
	at org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:252)
	at org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:203)
	at org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:522)
	at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1859)
	at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1930)

Write tip

You have a different solution? A short tip here would help you and many other users who saw this issue last week.

Users with the same issue

You are the first who have seen this exception. Write a tip to help other users and build your expert profile.