mysql的sql语句没错但是报错_sql语句没错·但是却报错，怎么回事？

最新推荐文章于 2024-04-27 22:15:08 发布

weixin_39929096

最新推荐文章于 2024-04-27 22:15:08 发布

阅读量1.5k

点赞数

文章标签： mysql的sql语句没错但是报错

本文链接：https://blog.csdn.net/weixin_39929096/article/details/113972656

版权

CREATE USER @user@@@host IDENTIFIED BY @pwd 用的这个sql，生成的sql语句放到数据库运行不报错，但是运行报错

For example:> "CREATE USER 'text'@'%' IDENTIFIED BY '111';"

2017-11-29 11:10:43 ERROR StatFilter:148 - merge sql error, dbType mysql, sql : CREATE USER ?@? IDENTIFIED BY ?;

java.lang.ClassCastException: com.alibaba.druid.sql.ast.expr.SQLVariantRefExpr cannot be cast to com.alibaba.druid.sql.ast.expr.SQLIdentifierExpr

at com.alibaba.druid.sql.dialect.mysql.parser.MySqlExprParser.primaryRest(MySqlExprParser.java:474)

at com.alibaba.druid.sql.parser.SQLExprParser.primary(SQLExprParser.java:631)

at com.alibaba.druid.sql.dialect.mysql.parser.MySqlExprParser.primary(MySqlExprParser.java:177)

at com.alibaba.druid.sql.dialect.mysql.parser.MySqlStatementParser.parseCreateUser(MySqlStatementParser.java:442)

at com.alibaba.druid.sql.dialect.mysql.parser.MySqlStatementParser.parseCreate(MySqlStatementParser.java:334)

at com.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:155)

at com.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:78)

at com.alibaba.druid.sql.visitor.ParameterizedOutputVisitorUtils.parameterize(ParameterizedOutputVisitorUtils.java:43)

at com.alibaba.druid.filter.stat.StatFilter.mergeSql(StatFilter.java:146)

at com.alibaba.druid.filter.stat.StatFilter.createSqlStat(StatFilter.java:634)

at com.alibaba.druid.filter.stat.StatFilter.internalBeforeStatementExecute(StatFilter.java:402)

at com.alibaba.druid.filter.stat.StatFilter.statementExecuteBefore(StatFilter.java:350)

at com.alibaba.druid.filter.FilterEventAdapter.statement_execute(FilterEventAdapter.java:185)

at com.alibaba.druid.filter.FilterChainImpl.statement_execute(FilterChainImpl.java:2598)

at com.alibaba.druid.proxy.jdbc.StatementProxyImpl.execute(StatementProxyImpl.java:153)

at com.alibaba.druid.pool.DruidPooledStatement.execute(DruidPooledStatement.java:497)

at org.nutz.dao.impl.sql.run.NutDaoExecutor._runStatement(NutDaoExecutor.java:357)

at org.nutz.dao.impl.sql.run.NutDaoExecutor.exec(NutDaoExecutor.java:60)

at org.nutz.dao.DaoInterceptorChain.doChain(DaoInterceptorChain.java:66)

at org.nutz.dao.impl.interceptor.DaoLogInterceptor.filter(DaoLogInterceptor.java:22)

at org.nutz.dao.DaoInterceptorChain.doChain(DaoInterceptorChain.java:64)

at org.nutz.dao.DaoInterceptorChain.invoke(DaoInterceptorChain.java:139)

at org.nutz.dao.impl.sql.run.NutDaoRunner.runCallback(NutDaoRunner.java:158)

at org.nutz.dao.impl.sql.run.NutDaoRunner._runWithoutTransaction(NutDaoRunner.java:125)

at org.nutz.dao.impl.sql.run.NutDaoRunner._run(NutDaoRunner.java:92)

at org.nutz.dao.impl.sql.run.NutDaoRunner.run(NutDaoRunner.java:81)

at org.nutz.dao.impl.DaoSupport.run(DaoSupport.java:240)

at org.nutz.dao.impl.DaoSupport._exec(DaoSupport.java:252)

at org.nutz.dao.impl.DaoSupport.execute(DaoSupport.java:236)

at org.nutz.dao.impl.NutDao.execute(NutDao.java:1008)

at com.yh.app.webser.module.manage.platformfunction.RelatingManagementModule.registration(RelatingManagementModule.java:417)

at com.yh.app.webser.module.manage.platformfunction.RelatingManagementModule$FM$registration$e0a07a62b6c1f37d5ddc2d74db19e920.invoke(RelatingManagementModule.java)

at org.nutz.mvc.impl.processor.MethodInvokeProcessor.process(MethodInvokeProcessor.java:31)

at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)

at com.yh.app.webser.common.mvc.UsbKeyCheckProcessor.process(UsbKeyCheckProcessor.java:42)

at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)

at org.nutz.mvc.impl.processor.AdaptorProcessor.process(AdaptorProcessor.java:30)

at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)

at org.nutz.integration.shiro.YHShiroProcessor.process(YHShiroProcessor.java:57)

at org.nutz.mvc.impl.processor.ActionFiltersProcessor.process(ActionFiltersProcessor.java:62)

at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)

at org.nutz.integration.shiro.NutShiroProcessor.process(NutShiroProcessor.java:126)

at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)

at org.nutz.mvc.impl.processor.ModuleProcessor.process(ModuleProcessor.java:123)

at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)

at org.nutz.mvc.impl.processor.EncodingProcessor.process(EncodingProcessor.java:27)

at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)

at org.nutz.mvc.impl.processor.UpdateRequestAttributesProcessor.process(UpdateRequestAttributesProcessor.java:15)

at org.nutz.mvc.impl.NutActionChain.doChain(NutActionChain.java:44)

at org.nutz.mvc.impl.ActionInvoker.invoke(ActionInvoker.java:67)

at org.nutz.mvc.ActionHandler.handle(ActionHandler.java:31)

at org.nutz.mvc.NutFilter.doFilter(NutFilter.java:202)

at com.yh.app.webser.common.mvc.YHwebFilter.doFilter(YHwebFilter.java:41)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)

at com.alibaba.druid.support.http.WebStatFilter.doFilter(WebStatFilter.java:123)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)

at org.apache.shiro.web.servlet.AbstractShiroFilter.executeChain(AbstractShiroFilter.java:449)

at org.apache.shiro.web.servlet.AbstractShiroFilter$1.call(AbstractShiroFilter.java:365)

at org.apache.shiro.subject.support.SubjectCallable.doCall(SubjectCallable.java:90)

at org.apache.shiro.subject.support.SubjectCallable.call(SubjectCallable.java:83)

at org.apache.shiro.subject.support.DelegatingSubject.execute(DelegatingSubject.java:383)

at org.apache.shiro.web.servlet.AbstractShiroFilter.doFilterInternal(AbstractShiroFilter.java:362)

at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)

at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199)

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:108)

at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)

at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)

at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:620)

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)

at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:349)

at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:783)

at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)

at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:745)

at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1455)

at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)

at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)

at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)

at java.lang.Thread.run(Thread.java:745)

2017-11-29 11:10:43 DEBUG NutDaoExecutor:97 - SQLException

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '?@? IDENTIFIED BY ?' at line 1

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 com.mysql.jdbc.Util.handleNewInstance(Util.java:400)

at com.mysql.jdbc.Util.getInstance(Util.java:383)

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:980)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3847)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3783)

at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2447)

at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2594)

at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2541)

at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2499)

at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:844)

at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:748)

at com.alibaba.druid.filter.FilterChainImpl.statement_execute(FilterChainImpl.java:2600)

at com.alibaba.druid.filter.FilterAdapter.statement_execute(FilterAdapter.java:2473)

at com.alibaba.druid.filter.FilterEventAdapter.statement_execute(FilterEventAdapter.java:188)