sql语句可以在外部执行项目内部执行时报sql错误

最新推荐文章于 2022-08-11 18:31:46 发布
最新推荐文章于 2022-08-11 18:31:46 发布
阅读量482 收藏
点赞数
文章标签： bug mysql java
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/Riding_ants/article/details/107313191
版权

报错信息

2020-07-13 11:04:41.824 DEBUG 4724 --- [nio-8083-exec-7] c.t.m.TbItemMapper.selectAllSearchItem   : ==>  Preparing:   SELECT item_cat.`name` AS category_name, item.id AS id, item.image as image, item.title AS title, item.price AS price, item.sell_point AS sell_point, item_desc.item_desc AS item_desc FROM tb_item item LEFT JOIN tb_item_desc item_desc ON item.id = item_desc.item_id LEFT JOIN tb_item_cat item_cat ON item.cid = item_cat.id 
2020-07-13 11:04:41.825 DEBUG 4724 --- [nio-8083-exec-7] c.t.m.TbItemMapper.selectAllSearchItem   : ==> Parameters: 
2020-07-13 11:04:41.829 ERROR 4724 --- [nio-8083-exec-7] o.a.c.c.C.[.[.[/].[dispatcherServlet]    : Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception [Request processing failed; nested exception is org.springframework.jdbc.BadSqlGrammarException: 
### Error querying database.  Cause: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' 
  SELECT
  item_cat.`name` AS category_name,
  item.id AS id,
  item.image as' at line 1
### The error may exist in file [C:\Users\lanou\IdeaProjects\taotaoparent\taotao-manager\taotao-mapper\target\classes\mappers\TbItemMapper.xml]
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL:     SELECT   item_cat.`name` AS category_name,   item.id AS id,   item.image as image,   item.title AS title,   item.price AS price,   item.sell_point AS sell_point,   item_desc.item_desc AS item_desc   FROM   tb_item item   LEFT JOIN tb_item_desc item_desc ON item.id = item_desc.item_id   LEFT JOIN tb_item_cat item_cat ON item.cid = item_cat.id
### Cause: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' 
  SELECT
  item_cat.`name` AS category_name,
  item.id AS id,
  item.image as' at line 1
; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' 
  SELECT
  item_cat.`name` AS category_name,
  item.id AS id,
  item.image as' at line 1] with root cause

java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' 
  SELECT
  item_cat.`name` AS category_name,
  item.id AS id,
  item.image as' at line 1
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120) ~[mysql-connector-java-8.0.16.jar:8.0.16]
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) ~[mysql-connector-java-8.0.16.jar:8.0.16]
	at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) ~[mysql-connector-java-8.0.16.jar:8.0.16]
	at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:955) ~[mysql-connector-java-8.0.16.jar:8.0.16]
	at com.mysql.cj.jdbc.ClientPreparedStatement.execute(ClientPreparedStatement.java:372) ~[mysql-connector-java-8.0.16.jar:8.0.16]
	at com.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44) ~[HikariCP-3.2.0.jar:na]
	at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.execute(HikariProxyPreparedStatement.java) ~[HikariCP-3.2.0.jar:na]
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_181]
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_181]
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_181]
	at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_181]
	at org.apache.ibatis.logging.jdbc.PreparedStatementLogger.invoke(PreparedStatementLogger.java:59) ~[mybatis-3.5.2.jar:3.5.2]
	at com.sun.proxy.$Proxy75.execute(Unknown Source) ~[na:na]
	at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:64) ~[mybatis-3.5.2.jar:3.5.2]
	at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:79) ~[mybatis-3.5.2.jar:3.5.2]
	at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:63) ~[mybatis-3.5.2.jar:3.5.2]
	at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:324) ~[mybatis-3.5.2.jar:3.5.2]
	at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156) ~[mybatis-3.5.2.jar:3.5.2]
	at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109) ~[mybatis-3.5.2.jar:3.5.2]
	at com.github.pagehelper.PageInterceptor.intercept(PageInterceptor.java:108) ~[pagehelper-5.1.8.jar:na]
	at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:61) ~[mybatis-3.5.2.jar:3.5.2]
	at com.sun.proxy.$Proxy73.query(Unknown Source) ~[na:na]
	at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:147) ~[mybatis-3.5.2.jar:3.5.2]
	at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140) ~[mybatis-3.5.2.jar:3.5.2]
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_181]
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_181]
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_181]
	at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_181]
	at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:426) ~[mybatis-spring-2.0.2.jar:2.0.2]
	at com.sun.proxy.$Proxy55.selectList(Unknown Source) ~[na:na]
	at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:223) ~[mybatis-spring-2.0.2.jar:2.0.2]
	at org.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:147) ~[mybatis-3.5.2.jar:3.5.2]
	at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:80) ~[mybatis-3.5.2.jar:3.5.2]
	at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:57) ~[mybatis-3.5.2.jar:3.5.2]
	at com.sun.proxy.$Proxy56.selectAllSearchItem(Unknown Source) ~[na:na]
	at com.taotao.rest.service.impl.ItemServiceImpl.importAllTbItem2Solr(ItemServiceImpl.java:25) ~[classes/:na]
	at com.taotao.rest.web.ItemController.dataImport(ItemController.java:19) ~[classes/:na]
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_181]
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_181]
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_181]
	at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_181]
	at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:190) ~[spring-web-5.1.8.RELEASE.jar:5.1.8.RELEASE]
	at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:138) ~[spring-web-5.1.8.RELEASE.jar:5.1.8.RELEASE]
	at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:104) ~[spring-webmvc-5.1.8.RELEASE.jar:5.1.8.RELEASE]
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:892) ~[spring-webmvc-5.1.8.RELEASE.jar:5.1.8.RELEASE]
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:797) ~[spring-webmvc-5.1.8.RELEASE.jar:5.1.8.RELEASE]
	at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87) ~[spring-webmvc-5.1.8.RELEASE.jar:5.1.8.RELEASE]
	at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1039) ~[spring-webmvc-5.1.8.RELEASE.jar:5.1.8.RELEASE]
	at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:942) ~[spring-webmvc-5.1.8.RELEASE.jar:5.1.8.RELEASE]
	at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1005) ~[spring-webmvc-5.1.8.RELEASE.jar:5.1.8.RELEASE]
	at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:897) ~[spring-webmvc-5.1.8.RELEASE.jar:5.1.8.RELEASE]
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:634) ~[tomcat-embed-core-9.0.21.jar:9.0.21]
	at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:882) ~[spring-webmvc-5.1.8.RELEASE.jar:5.1.8.RELEASE]
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:741) ~[tomcat-embed-core-9.0.21.jar:9.0.21]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) ~[tomcat-embed-core-9.0.21.jar:9.0.21]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-9.0.21.jar:9.0.21]
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) ~[tomcat-embed-websocket-9.0.21.jar:9.0.21]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[tomcat-embed-core-9.0.21.jar:9.0.21]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-9.0.21.jar:9.0.21]
	at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:99) ~[spring-web-5.1.8.RELEASE.jar:5.1.8.RELEASE]
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:109) ~[spring-web-5.1.8.RELEASE.jar:5.1.8.RELEASE]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[tomcat-embed-core-9.0.21.jar:9.0.21]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-9.0.21.jar:9.0.21]
	at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:92) ~[spring-web-5.1.8.RELEASE.jar:5.1.8.RELEASE]
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:109) ~[spring-web-5.1.8.RELEASE.jar:5.1.8.RELEASE]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[tomcat-embed-core-9.0.21.jar:9.0.21]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-9.0.21.jar:9.0.21]
	at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:93) ~[spring-web-5.1.8.RELEASE.jar:5.1.8.RELEASE]
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:109) ~[spring-web-5.1.8.RELEASE.jar:5.1.8.RELEASE]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[tomcat-embed-core-9.0.21.jar:9.0.21]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-9.0.21.jar:9.0.21]
	at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:200) ~[spring-web-5.1.8.RELEASE.jar:5.1.8.RELEASE]
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:109) ~[spring-web-5.1.8.RELEASE.jar:5.1.8.RELEASE]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[tomcat-embed-core-9.0.21.jar:9.0.21]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-9.0.21.jar:9.0.21]
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202) ~[tomcat-embed-core-9.0.21.jar:9.0.21]
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) [tomcat-embed-core-9.0.21.jar:9.0.21]
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:490) [tomcat-embed-core-9.0.21.jar:9.0.21]
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) [tomcat-embed-core-9.0.21.jar:9.0.21]
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) [tomcat-embed-core-9.0.21.jar:9.0.21]
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) [tomcat-embed-core-9.0.21.jar:9.0.21]
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) [tomcat-embed-core-9.0.21.jar:9.0.21]
	at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:408) [tomcat-embed-core-9.0.21.jar:9.0.21]
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) [tomcat-embed-core-9.0.21.jar:9.0.21]
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:853) [tomcat-embed-core-9.0.21.jar:9.0.21]
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1587) [tomcat-embed-core-9.0.21.jar:9.0.21]
	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) [tomcat-embed-core-9.0.21.jar:9.0.21]
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [na:1.8.0_181]
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [na:1.8.0_181]
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-embed-core-9.0.21.jar:9.0.21]
	at java.lang.Thread.run(Thread.java:748) [na:1.8.0_181]

sql语句

  SELECT
  item_cat.`name` AS category_name,
  item.id AS id,
  item.image AS image,
  item.title AS title,
  item.price AS price,
  item.sell_point AS sell_point,
  item_desc.item_desc AS item_desc
  FROM
  tb_item item
  LEFT JOIN tb_item_desc item_desc ON item.id = item_desc.item_id
  LEFT JOIN tb_item_cat item_cat ON item.cid = item_cat.id;

外部执行结果

在这里插入图片描述
很疑惑 也很头疼 头一次碰见这种情况,有没有知道的大佬给解答一下

问题解决

这问题真是折磨人啊！不屑努力和询问终于完美解决了 问题就出在了 select标签内部结束时 有了个空格
对 就是一个空格 难为了我整整一上午。
在这里插入图片描述
好在顺利解决 我太难了！

Mr super
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
SQLServer 数据库语句可以执行但是语句会有红线提示错误
蒙蒙宝贝
08-16 2394
sql语句可以执行，但是会有波浪线提示错误，我是用的是SQLServer2019
sql语句在数据库中可以执行，但是测试时无法执行
weixin_30275415的博客
07-15 1089
错误信息：org.springframework.jdbc.UncategorizedSQLException: ### Error querying database. Cause: java.sql.SQLException: sql injection violation, syntax error: ERROR. token : LEAVE, pos : 24 : select...
0001PreparedStatement执行sql语句出错
weixin_44397071的博客
04-21 440
PreparedStatement执行sql语句出错 出错代码： //编写增删改公告方法 public static int excute(Connection connection,PreparedStatement preparedStatement,String sql,Object[] params ) throws SQLException { preparedStatement = connection.prepareStatement(sql);
activiti 部署失败：[Validation set: 'activiti-executable-process' | Problem: 'activiti-process-defin。。。。。
Dalon_G的博客
12-09 7883
部署activiti时，遇到这个问题 2019-12-09 14:13:24.196 DEBUG 11492 --- [nio-8099-exec-1] .m.m.a.ExceptionHandlerExceptionResolver : Using @ExceptionHandler public java.lang.String com.seagetech.web.starter.serv...
在SQLServer上查看SQL语句的执行时间的方法
09-11
在SQL Server中，监控SQL语句的执行时间是优化数据库性能和提高代码效率的重要环节。以下是如何在SQL Server上查看SQL语句执行时间的几种方法： 1. **简单时间差计算法**： 这是最基础的方法，通过记录查询开始和...
thinkPHP框架中执行原生SQL语句的方法
10-19
本篇文章将深入探讨如何在ThinkPHP中执行原生SQL语句，并对比`query()`和`execute()`这两个方法的使用场景和差异。 首先，执行原生SQL语句的方法通常涉及创建一个模型对象。在ThinkPHP中，你可以通过以下方式实例化...
详解一条sql语句在mysql中是如何执行的
09-09
在MySQL中，SQL语句的执行过程涉及到多个关键步骤，从连接到数据库、解析SQL、优化执行计划到最终的数据检索和返回。以下是对这个过程的详细解析： 首先，当一个SQL语句提交到MySQL服务器时，它会经过连接器的处理...
Shell脚本中执行sql语句操作mysql的5种方法
09-15
主要介绍了Shell脚本中执行sql语句操作mysql的5种方法,本文讲解了将SQL语句直接嵌入到shell脚本文件中、命令行调用单独的SQL文件、使用管道符调用SQL文件等方法,需要的朋友可以参考下
SQL语句的执行过程.pptx
最新发布
11-21
在SQL语句执行过程中，数据库系统还会使用共享池来存放以前执行过的SQL语句、PL/SQL代码和数据字典信息，以便重用已经执行的工作。共享池是Oracle体系结构的一个关键成分。 在SQL语句执行过程中，数据库系统还会...
解决Exception java.sql.SQLException ORA-00600 内部错误代码
07-29
在oracle里面运行一下，解决Exception java.sql.SQLException ORA-00600 内部错误代码
SQL问题记录
forever_u_wzx的博客
08-11 768
平时sql报错记录
sql内部连接_SQL内部联接的分步演练
culuo4781的博客
07-25 910
sql内部连接 Organizations are generating and analyzing unmatched volumes of data with each passing minute. In this article, we will demonstrate how we can employ SQL Inner Join to query and access data...
SQL 异常之 Error: Method queryTotal execution error of sql
热门推荐
ye2353030的博客
11-08 2万+
在一个连接查询中，在MySQL查询工具中查询没有问题，粘到项目里的Mapper.xml文件中，运行时却报MybatisPlusException: Error: Method queryTotal execution error of sql : SELECT ANY_VALUE(e.id) AS "id", ANY_VALUE(e.project_no) AS "projectNo", ANY_VALUE(sampleIn.sample_id) A
【Mybatis】MybatisSqlInterceptor Interceptor 拦截器打印完整的sql语句
朝阳大司马
12-09 6043
最近在做公司的项目，发现项目当中使用Mybatis框架的时候，打印的SQL都是用原生的DEBUG的日志，执行SQL和参数都是分开的，这样我们在排查SQL问题的时候，都需要手动拼接，浪费了一些时间， 所以我们需要想办法打印出完成的SQL，Mybatis为我们提供了org.apache.ibatis.plugin.Interceptor接口，我们来实现该接口做一些打印SQL的工作，可能很多小伙伴的项目都已经用了此功能，但是也可以 看一下，温故而知新，主要是为了那些真正需要帮助的小伙伴提供一些参考。我参与..
"深入理解SQL语句执行过程及类型-拓明科技Oracle数据库内部培训资料
在Oracle数据库中，SQL语句的执行可以概括为四个步骤：分析、优化、行资源生成和语句执行。 首先，分析阶段是对提交的SQL语句进行语法和语义检查。数据库会检查SQL语句的语法是否正确，并验证语句中引用的表、列等...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值