druid拦截mysql相关语句,求助!

ken_yip 2017-12-12 11:31:19
我不想去掉wall配置来解决,但语句相关的语法我校验过是正确的,直接贴去跑也没问题。
下面报错中这句:'onal varchar(32)一直看不懂是哪里来的。


--------------------------------------------------------------------------------------------------

### Error updating database. Cause: java.sql.SQLException: sql injection violation, syntax error: syntax error, error in :'onal varchar(32) NOT NULL, ', expect RPAREN, actual IDENTIFIER pos 156, line 1, column 149, token IDENTIFIER varchar : CREATE TABLE AppServiceLang (id bigint not null auto_increment, dataid bigint NOT NULL, col national varchar(32) NOT NULL, lang national varchar(8) NOT NULL, content national varchar(4000) NOT NULL, CONSTRAINT PK_AppServiceLang primary key (id ASC), CONSTRAINT AK_AppServiceLang_dataid_col_lang UNIQUE NONCLUSTERED (dataId ASC, col ASC, lang ASC))
### SQL: CREATE TABLE AppServiceLang (id bigint not null auto_increment, dataid bigint NOT NULL, col national varchar(32) NOT NULL, lang national varchar(8) NOT NULL, content national varchar(4000) NOT NULL, CONSTRAINT PK_AppServiceLang primary key (id ASC), CONSTRAINT AK_AppServiceLang_dataid_col_lang UNIQUE NONCLUSTERED (dataId ASC, col ASC, lang ASC))
### Cause: java.sql.SQLException: sql injection violation, syntax error: syntax error, error in :'onal varchar(32) NOT NULL, ', expect RPAREN, actual IDENTIFIER pos 156, line 1, column 149, token IDENTIFIER varchar : CREATE TABLE AppServiceLang (id bigint not null auto_increment, dataid bigint NOT NULL, col national varchar(32) NOT NULL, lang national varchar(8) NOT NULL, content national varchar(4000) NOT NULL, CONSTRAINT PK_AppServiceLang primary key (id ASC), CONSTRAINT AK_AppServiceLang_dataid_col_lang UNIQUE NONCLUSTERED (dataId ASC, col ASC, lang ASC))
; uncategorized SQLException for SQL []; SQL state [null]; error code [0]; sql injection violation, syntax error: syntax error, error in :'onal varchar(32) NOT NULL, ', expect RPAREN, actual IDENTIFIER pos 156, line 1, column 149, token IDENTIFIER varchar : CREATE TABLE AppServiceLang (id bigint not null auto_increment, dataid bigint NOT NULL, col national varchar(32) NOT NULL, lang national varchar(8) NOT NULL, content national varchar(4000) NOT NULL, CONSTRAINT PK_AppServiceLang primary key (id ASC), CONSTRAINT AK_AppServiceLang_dataid_col_lang UNIQUE NONCLUSTERED (dataId ASC, col ASC, lang ASC)); nested exception is java.sql.SQLException: sql injection violation, syntax error: syntax error, error in :'onal varchar(32) NOT NULL, ', expect RPAREN, actual IDENTIFIER pos 156, line 1, column 149, token IDENTIFIER varchar : CREATE TABLE AppServiceLang (id bigint not null auto_increment, dataid bigint NOT NULL, col national varchar(32) NOT NULL, lang national varchar(8) NOT NULL, content national varchar(4000) NOT NULL, CONSTRAINT PK_AppServiceLang primary key (id ASC), CONSTRAINT AK_AppServiceLang_dataid_col_lang UNIQUE NONCLUSTERED (dataId ASC, col ASC, lang ASC))
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:83)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:71)
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:365)
at com.sun.proxy.$Proxy9.update(Unknown Source)
at org.mybatis.spring.SqlSessionTemplate.update(SqlSessionTemplate.java:251)
at com.armitage.server.system.dao.impl.CommonLangDAOImpl.createTable(CommonLangDAOImpl.java:156)
at com.armitage.server.system.service.impl.CommonLangBizImpl.createTable(CommonLangBizImpl.java:38)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:497)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
at com.sun.proxy.$Proxy13.createTable(Unknown Source)
at com.armitage.server.common.task.DataInit.init(DataInit.java:117)
at com.armitage.server.common.task.DataInit.<init>(DataInit.java:45)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:422)
at org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:126)
at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:74)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateBean(AbstractAutowireCapableBeanFactory.java:958)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:911)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:485)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:291)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:288)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:190)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:580)
at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:895)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:425)
at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:276)
at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:197)
at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:47)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4887)
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5381)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1559)
at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1549)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)
...全文
249 回复 打赏 收藏 转发到动态 举报
写回复
用AI写文章
回复
切换为时间正序
请发表友善的回复…
发表回复

56,677

社区成员

发帖
与我相关
我的任务
社区描述
MySQL相关内容讨论专区
社区管理员
  • MySQL
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧