Home > database >  Druid intercept mysql related statements, ask for help!
Druid intercept mysql related statements, ask for help!

Time:10-01

I don't want to remove the wall configuration to solve, but the statement related to grammar I check is right, stick to run directly is no problem,
The following error in this sentence: 'onal varchar (32) has been don't understand is where come of,


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

### 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, the content national varchar (4000) not null, the CONSTRAINT PK_AppServiceLang primary key (id ASC), the 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), The 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))
The at org. Springframework. JDBC. Support. AbstractFallbackSQLExceptionTranslator. Translate (AbstractFallbackSQLExceptionTranslator. Java: 83)
The at org. Springframework. JDBC. Support. AbstractFallbackSQLExceptionTranslator. Translate (AbstractFallbackSQLExceptionTranslator. Java: 80)
The at org. Mybatis. Spring. MyBatisExceptionTranslator. TranslateExceptionIfPossible (MyBatisExceptionTranslator. Java: 71)
The at org. Mybatis. Spring. SqlSessionTemplate $SqlSessionInterceptor. Invoke (SqlSessionTemplate. Java: 365)
At com. Sun. Proxy. $Proxy9. Update (Unknown Source)
The at org. Mybatis. Spring. SqlSessionTemplate. Update (SqlSessionTemplate. Java: 251)
At com.armitage.server.system.dao.impl.Com monLangDAOImpl. CreateTable (CommonLangDAOImpl. Java: 156)
At com.armitage.server.system.service.impl.Com monLangBizImpl. CreateTable (CommonLangBizImpl. Java: 38)
At sun. Reflect. NativeMethodAccessorImpl. Invoke0 (Native Method)
At sun. Reflect. NativeMethodAccessorImpl. Invoke (NativeMethodAccessorImpl. Java: 62)
At sun. Reflect. DelegatingMethodAccessorImpl. Invoke (43) DelegatingMethodAccessorImpl. Java:
The at Java. Lang. Reflect. Method. Invoke (497) Method. The Java:
The at org. Springframework. Aop. Support. AopUtils. InvokeJoinpointUsingReflection (AopUtils. Java: 309)
The at org. Springframework. Aop. Framework. ReflectiveMethodInvocation. InvokeJoinpoint (ReflectiveMethodInvocation. Java: 183)
The at org. Springframework. Aop. Framework. ReflectiveMethodInvocation. Proceed (ReflectiveMethodInvocation. Java: 150)
nullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnull
  • Related