com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:异常问题解析!

最新推荐文章于 2024-05-23 09:43:51 发布
最新推荐文章于 2024-05-23 09:43:51 发布
阅读量6.1k 收藏
点赞数
文章标签： mybatis mysql
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.youkuaiyun.com/NullPointerExcept1on/article/details/79943337
版权

    
    首先遇到这样的问题,肯定是你的sql写错了,应该不用怀疑,虽然我把sql代码抽取出来在sql 单独运行了一遍,没有报错,但是还是sql语法的错误,下面先上错误的代码 
 <select id="getCustomerListCount" resultType="int" parameterType="queryvo">
        SELECT
          count (0)
        FROM
          customer a
        LEFT JOIN base_dict b ON a.cust_source = b.dict_id
        LEFT JOIN base_dict c ON a.cust_industry = c.dict_id
        LEFT JOIN base_dict d ON a.cust_level = d.dict_id

        <include refid="customer_list_where"/>
    </select>

错误原因为第三行: count(0)  最后改为 COUNT(0) 错误消失!不仅仅是大写小写的问题,我用的idea,代码快建建提示的那个可能是导入了其他对象,后来直接从数据库复制出来,就没报错了,也没有了关键字变亮了.

报错信息为: 

### Error querying database.  Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: FUNCTION crm.count does not exist. Check the 'Function Name Parsing and Resolution' section in the Reference Manual
### The error may exist in com/itheima/boot/dao/CustomerDao.xml
### The error may involve com.itheima.boot.dao.CustomerDao.getCustomerListCount-Inline
### The error occurred while setting parameters
### SQL: SELECT           count (0)         FROM           customer a         LEFT JOIN base_dict b ON a.cust_source = b.dict_id         LEFT JOIN base_dict c ON a.cust_industry = c.dict_id         LEFT JOIN base_dict d ON a.cust_level = d.dict_id
### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: FUNCTION crm.count does not exist. Check the 'Function Name Parsing and Resolution' section in the Reference Manual
; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: FUNCTION crm.count does not exist. Check the 'Function Name Parsing and Resolution' section in the Reference Manual
	at org.springframework.jdbc.support.SQLExceptionSubclassTranslator.doTranslate(SQLExceptionSubclassTranslator.java:91)
	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73)
	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
	at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:73)
	at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:371)
	at com.sun.proxy.$Proxy12.selectOne(Unknown Source)
	at org.mybatis.spring.SqlSessionTemplate.selectOne(SqlSessionTemplate.java:163)
	at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:68)
	at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:52)
	at com.sun.proxy.$Proxy18.getCustomerListCount(Unknown Source)
	at com.itheima.boot.service.impl.CustomerServiceImpl.getCustomerList(CustomerServiceImpl.java:32)
	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:498)
	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
	at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
	at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:267)
	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
	at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207)
	at com.sun.proxy.$Proxy19.getCustomerList(Unknown Source)
	at com.itheima.boot.controller.CustomerController.customerList(CustomerController.java:60)
	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:498)
	at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:221)
	at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:137)
	at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:110)
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:777)
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:706)
	at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)
	at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:943)
	at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:877)
	at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:966)
	at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:857)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:624)
	at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:842)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:505)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
	at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:956)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:436)
	at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1078)
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:625)
	at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Thread.java:748)


彭大勃
关注
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column ‘‘x’‘ in ‘field list‘
DN金猿的博客
06-07 244
项目中配置了sql检查：select ‘x’，没用 shardingjdbc 时启动没问题，用了 shardingjdbc 启动就报下面的报错信息。从上面的代码脚本里很明显能看出来是x两边的标点符号问题，但是在配置文件中却看不出来，不好分辨。如下图放上英文标点符号，也分不清啊！你能分的点哪个是英文标点，哪个是中文标点吗？就算放到java代码里也不好分辨，只能说是idea字体的原因吧。最后把x两边的中文标点单引号换成英文标点单引号启动就正常了。
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:
知识改变命运，ヾ(◍°∇°◍)ﾉﾞ【求关注】
08-14 5482
跑项目时报错：Table xxxxx’ doesn’t exist
Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: ….. this is incompatible with sq
12-14
1、写在开头 标题之前我想说一下Linux的mysql真的实在是太坑了。太坑了。总是会出现这样那样的你想不到的问题。崩溃了。首先来罗列一下我遇到过的一些问题吧。 1、大小写敏感 2、连接数超过系统最大连接数 3、Can’t connect to local MySQL server through socket ‘/Data/mydata/mysql.sock’ socket文件目录不对应导致的问题 4、今天要说的就是 没有打开only_full_group_by Cause:com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorExcepti
异常：com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException
Nostalgian的博客
06-15 2万+
当程序中出现异常提示为：com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException  的时候，说明是SQL语句出现了错误，导致程序无法编译。例如：   语句1----> stmt.executeUpdate("update article set rootid = " + k + " where id = " + k + ";");  
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException
WYMei_529
09-20 4469
stmt = conn.prepareStatement("SELECT *, u.user_name AS current_owner_name FROM book AS b LEFT JOIN user AS u ON b.current_owner_id = u.id WHERE owner_id = " + userId + "ORDER BY b.id DESC LIMIT " + pagination.getOffset() + "," + pagination.getPageSize());
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: #42000
Lq_joe的博客
08-01 8903
一、解决方法 以下是我从网上搜罗的解决方法： 检查sql语句格式是否错误（我是这种，在sql语句的最后添加了“;”，这个在一般语句中不会出错，但恰好我的batch）； 检查是否使用mysql的关键字且没使用``； conf-jdbc.properties 文件没开启批量修改，jdbc_url=...?allowMultiQueries=true 二、解决过程 背景 继上次MyS...
出现语法错误mybatis :Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:
qq_45555170的博客
11-09 6639
Error updating database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 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 '　delete from t_book where boo
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: FUNCTION health.connect does not exist
weixin_43194330的博客
04-24 907
数据库语法错误 ### The error may exist in com/it/dao/SetmealDao.xml ### The error may involve com.it.dao.SetmealDao.selectByCondition-Inline ### The error occurred while setting parameters ### SQL: select co...
解决com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:
热门推荐
一条正弦
10-28 3万+
解决com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 1. 报错内容 com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds ...
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException异常
weixin_44552194的博客
08-20 2063
在获取mysql数据库的连接报了这样的一个错误：com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'performance_schema.session_variables' doesn't exist 我看了下我数据库并没有这张表，而且我也没有去写执行找这张表的命令，只是单单建立连接： 我想了下应该数据库...
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException异常的解决方案
2301_79779756的博客
05-23 2767
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException 是 MySQL Connector/J（MySQL JDBC 驱动）在执行 SQL 语句时，因为 SQL 语法错误而抛出的异常。当 JDBC 客户端尝试执行一个包含语法错误的 SQL 语句时，MySQL 服务器会返回一个语法错误，这个错误随后会被 JDBC 驱动捕获并转换为 MySQLSyntaxErrorException 异常。
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException异常产生原因及解决方法
欧阳子遥的博客
07-31 6308
产生原因：SQL语句错误。 解决方法： 检查SQL语句的格式，确保其规范。 检查SQL语句的符号，看是不是一些英文符号写成中文符号了。 检查SQL语句的拼接情况，看是否漏掉空格，导致一些单词粘连在一起了。 ...
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException
weixin_54319871的博客
05-03 2124
当关键字出现是MySQLSyntaxErrorException,报错地方可以看。反应就是去检查你写的mysql语句或语法有没有写错。以后写代码不要手速太快，，希望能帮到大家！改成下面的形式，就不会报错啦！,在dao层里，原本我的写法是，
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown database
最新发布
02-20
### 解决 `com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown database` 错误 当遇到此错误时，表明应用程序尝试访问一个不存在于 MySQL 数据库服务器上的数据库。以下是几种可能的原因及解决...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值