Caused by: net.sf.jsqlparser.parser.ParseException: Encountered “ “LIKE“ “LIKE ““ at line 77。。。。

最新推荐文章于 2024-07-24 16:36:56 发布
置顶 最新推荐文章于 2024-07-24 16:36:56 发布
阅读量1.5k 收藏
点赞数 2
分类专栏： mybatis 文章标签： mysql sql 数据库 mybatis spring boot
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/omnipotent_wang/article/details/114889799
版权

该错误其中一个原因的解决办法

Caused by:net.sf.jsqlparser.parser.ParseException: Encountered " “LIKE” "LIKE “” at line 77, column 76.Was expecting one of:

错误信息，错误并不影响SQL的使用

net.sf.jsqlparser.JSQLParserException
	at net.sf.jsqlparser.parser.CCJSqlParserUtil.parse(CCJSqlParserUtil.java:56)
	at com.github.pagehelper.parser.OrderByParser.converToOrderBySql(OrderByParser.java:51)
	at com.github.pagehelper.dialect.AbstractHelperDialect.getPageSql(AbstractHelperDialect.java:176)
	at com.github.pagehelper.PageHelper.getPageSql(PageHelper.java:97)
	at com.github.pagehelper.PageInterceptor.intercept(PageInterceptor.java:129)
	at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:61)
	at com.sun.proxy.$Proxy243.query(Unknown Source)
	at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:148)
	at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:141)
	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.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:433)
	at com.sun.proxy.$Proxy90.selectList(Unknown Source)
	at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:230)
	at org.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:139)
	at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:76)
	at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:59)
	at com.sun.proxy.$Proxy181.selectAll(Unknown Source)
	at com.aima.project.damageRepair.service.Impl.ExceedStandardServiceImpl.selectList(ExceedStandardServiceImpl.java:71)
	at com.aima.project.damageRepair.controller.DamageExceedStandardController.list(DamageExceedStandardController.java:115)
	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:189)
	at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:138)
	at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:102)
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:895)
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:800)
	at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
	at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1038)
	at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:942)
	at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1005)
	at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:908)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:660)
	at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:882)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108)
	at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137)
	at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:112)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:112)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:61)
	at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108)
	at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137)
	at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)
	at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66)
	at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108)
	at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137)
	at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)
	at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66)
	at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108)
	at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137)
	at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)
	at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66)
	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:387)
	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:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at com.alibaba.druid.support.http.WebStatFilter.doFilter(WebStatFilter.java:123)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:99)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:92)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:93)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:200)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:490)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
	at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:408)
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:791)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1417)
	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
	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)
Caused by: net.sf.jsqlparser.parser.ParseException: Encountered " "LIKE" "LIKE "" at line 77, column 76.
Was expecting one of:
    "AND" ...
    "ESCAPE" ...
    ")" ...
    "|" ...
    "&" ...
    "^" ...
    "::" ...
    "::" ...
    "^" ...
    "|" ...
    "&" ...
    "ESCAPE" ...
    "ESCAPE" ...
    "::" ...
    "^" ...
    "|" ...
    "&" ...
    "ESCAPE" ...
    
	at net.sf.jsqlparser.parser.CCJSqlParser.generateParseException(CCJSqlParser.java:16395)
	at net.sf.jsqlparser.parser.CCJSqlParser.jj_consume_token(CCJSqlParser.java:16248)
	at net.sf.jsqlparser.parser.CCJSqlParser.AndExpression(CCJSqlParser.java:4689)
	at net.sf.jsqlparser.parser.CCJSqlParser.OrExpression(CCJSqlParser.java:4651)
	at net.sf.jsqlparser.parser.CCJSqlParser.Expression(CCJSqlParser.java:4622)
	at net.sf.jsqlparser.parser.CCJSqlParser.WhereClause(CCJSqlParser.java:4021)
	at net.sf.jsqlparser.parser.CCJSqlParser.PlainSelect(CCJSqlParser.java:2455)
	at net.sf.jsqlparser.parser.CCJSqlParser.SetOperationList(CCJSqlParser.java:2579)
	at net.sf.jsqlparser.parser.CCJSqlParser.SelectBody(CCJSqlParser.java:2336)
	at net.sf.jsqlparser.parser.CCJSqlParser.Select(CCJSqlParser.java:2328)
	at net.sf.jsqlparser.parser.CCJSqlParser.SingleStatement(CCJSqlParser.java:129)
	at net.sf.jsqlparser.parser.CCJSqlParser.Statement(CCJSqlParser.java:80)
	at net.sf.jsqlparser.parser.CCJSqlParserUtil.parse(CCJSqlParserUtil.java:54)
	... 111 more
Caused by:
net.sf.jsqlparser.parser.ParseException: Encountered " "LIKE" "LIKE "" at line 77, column 76.
Was expecting one of:
    "AND" ...
    "ESCAPE" ...
    ")" ...
    "|" ...
    "&" ...
    "^" ...
    "::" ...
    "::" ...
    "^" ...
    "|" ...
    "&" ...
    "ESCAPE" ...
    "ESCAPE" ...
    "::" ...
    "^" ...
    "|" ...
    "&" ...
    "ESCAPE" ...
    
	at net.sf.jsqlparser.parser.CCJSqlParser.generateParseException(CCJSqlParser.java:16395)
	at net.sf.jsqlparser.parser.CCJSqlParser.jj_consume_token(CCJSqlParser.java:16248)
	at net.sf.jsqlparser.parser.CCJSqlParser.AndExpression(CCJSqlParser.java:4689)
	at net.sf.jsqlparser.parser.CCJSqlParser.OrExpression(CCJSqlParser.java:4651)
	at net.sf.jsqlparser.parser.CCJSqlParser.Expression(CCJSqlParser.java:4622)
	at net.sf.jsqlparser.parser.CCJSqlParser.WhereClause(CCJSqlParser.java:4021)
	at net.sf.jsqlparser.parser.CCJSqlParser.PlainSelect(CCJSqlParser.java:2455)
	at net.sf.jsqlparser.parser.CCJSqlParser.SetOperationList(CCJSqlParser.java:2579)
	at net.sf.jsqlparser.parser.CCJSqlParser.SelectBody(CCJSqlParser.java:2336)
	at net.sf.jsqlparser.parser.CCJSqlParser.Select(CCJSqlParser.java:2328)
	at net.sf.jsqlparser.parser.CCJSqlParser.SingleStatement(CCJSqlParser.java:129)
	at net.sf.jsqlparser.parser.CCJSqlParser.Statement(CCJSqlParser.java:80)
	at net.sf.jsqlparser.parser.CCJSqlParserUtil.parse(CCJSqlParserUtil.java:54)
	at com.github.pagehelper.parser.OrderByParser.converToOrderBySql(OrderByParser.java:51)
	at com.github.pagehelper.dialect.AbstractHelperDialect.getPageSql(AbstractHelperDialect.java:176)
	at com.github.pagehelper.PageHelper.getPageSql(PageHelper.java:97)
	at com.github.pagehelper.PageInterceptor.intercept(PageInterceptor.java:129)
	at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:61)
	at com.sun.proxy.$Proxy243.query(Unknown Source)
	at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:148)
	at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:141)
	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.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:433)
	at com.sun.proxy.$Proxy90.selectList(Unknown Source)
	at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:230)
	at org.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:139)
	at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:76)
	at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:59)
	at com.sun.proxy.$Proxy181.selectAll(Unknown Source)
	at com.aima.project.damageRepair.service.Impl.ExceedStandardServiceImpl.selectList(ExceedStandardServiceImpl.java:71)
	at com.aima.project.damageRepair.controller.DamageExceedStandardController.list(DamageExceedStandardController.java:115)
	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:189)
	at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:138)
	at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:102)
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:895)
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:800)
	at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
	at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1038)
	at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:942)
	at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1005)
	at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:908)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:660)
	at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:882)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108)
	at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137)
	at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:112)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:112)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:61)
	at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108)
	at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137)
	at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)
	at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66)
	at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108)
	at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137)
	at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)
	at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66)
	at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108)
	at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137)
	at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)
	at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66)
	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:387)
	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:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at com.alibaba.druid.support.http.WebStatFilter.doFilter(WebStatFilter.java:123)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:99)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:92)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:93)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:200)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:490)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
	at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:408)
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:791)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1417)
	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
	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)
17:14:56.809 [http-nio-8088-exec-15] DEBUG c.a.p.d.m.E.selectAll - [debug,159] - ==>  Preparing: SELECT DISTINCT es.id as id, es.ids as ids, es. CODE as code, es.year_no as yearNo, es.part_no as partNo, es.work_package_no as workPackageNo, es.approval_category as approvalCategory, cwp.entry_time as entryTime, cwp.number as number, cwp.model as model, cwp.aircraft_number as aircraftNumber, cwp.line_no as lineNo, cc.ch_part as chPart, cc.en_part as enPart, cc.component_type as componentType, cc.location as location, cwp.plane_hours as planeHours, cwp.plane_loop as planeLoop, cwp.flight_hours as flightHours, cwp.flight_loop as flightLoop, cwp.contract_no as contractNo, es.nums as nums, es.damage_status as damageStatus, es.sro_no as sroNo, es.rea_no as reaNo, es.she_no as sheNo, es.der_no as derNo, es.defect_rep_no as defectRepNo, es. SUBJECT as subject, es.en_subject as enSubject, es.repair_instruction as repairInstruction, es.keyword as keyword, es.main_repair as mainRepair, es.typical as typical, es.special_tool as specialTool, es.replace_with_repair as replaceWithRepair, es.cp_engineer as cpEngineer, es.tm_engineer as tmEngineer, es.plan_writing as planWriting, es.plan_type as planType, es.expect_stop_time as expectStopTime, es.der_estimate_time as derEstimateTime, es.defect_report_date as defectReportDate, es.draft_start_date as draftStartDate, es.draft_end_date as draftEndDate, es.tm_review_date as tmReviewDate, es.faa_approval_date as faaApprovalDate, es.dmdor_end_date as dmdorEndDate, es.caac_application_date as caacApplicationDate, es.caac_approval_date as caacApprovalDate, es.special_reason as specialReason, es.draft_time as draftTime, es.engineer_time as engineerTime, es.faa_approval_time as faaApprovalTime, es.dmdor_caac_time as dmdorCaacTime, es.internal_tat as internalTat, es.all_tat as allTat, es.payment as payment, es.remarks as remarks, es.remark as remark, es.create_time as createTime, CASE WHEN dmaop.`code` IS NULL THEN 111 ELSE 666 END AS pdfStatus FROM exceed_standard es LEFT JOIN damage_mro_and_oem_pdf dmaop ON dmaop.`code` = es.`code` LEFT JOIN contract_work_package cwp ON cwp.work_package_no = es.work_package_no AND cwp.part_no = es.part_no AND cwp.number = es.number AND cwp.contract_no = es.contract_no LEFT JOIN capabilitylist_caac cc ON cc.component_id = es.part_no WHERE (es.damage_status LIKE concat('%PENDING%') || es.damage_status LIKE concat('ON HOLD%')) order by ids desc LIMIT ? 
17:14:56.811 [http-nio-8088-exec-15] DEBUG c.a.p.d.m.E.selectAll - [debug,159] - ==> Parameters: 10(Integer)
17:14:57.173 [http-nio-8088-exec-15] DEBUG c.a.p.d.m.E.selectAll - [debug,159] - <==      Total: 10

具体问题在这

net.sf.jsqlparser.parser.ParseException: Encountered " "LIKE" "LIKE "" at line 77, column 76.
Was expecting one of:
    "AND" ...
    "ESCAPE" ...
    ")" ...
    "|" ...
    "&" ...
    "^" ...
    "::" ...
    "::" ...
    "^" ...
    "|" ...
    "&" ...
    "ESCAPE" ...
    "ESCAPE" ...
    "::" ...
    "^" ...
    "|" ...
    "&" ...
    "ESCAPE" ...

它说我77行76列，like附近有问题

<if test="damageStatus != null and damageStatus != ''">
        <if test="damageStatus == 'WORK IN PROGRESS'">
        /*这块有问题*/
        and (es.damage_status LIKE concat('%PENDING%') || es.damage_status LIKE concat('ON HOLD%'))
        /*========================================================*/
        </if>
        <if test="damageStatus != 'WORK IN PROGRESS'">
          and es.damage_status like concat('%', #{damageStatus,jdbcType=VARCHAR}, '%')
        </if>
</if>

实际上我的问题在于 “ || ”，我的“或”，把“ || ”换成 “or”，我的问题就解决了*
希望能帮到你们

yizhi-w
关注
专栏目录
解决Caused by: net.sf.jsqlparser.parser.ParseException: Encountered “ “(“ “( ““ at line 10, column 42.
灰太狼
03-15 7267
解决Caused by: net.sf.jsqlparser.parser.ParseException: Encountered " "(" "( "" at line 10, column 42. 运行mybatis查询sql时报错异常： Caused by: net.sf.jsqlparser.parser.ParseException: Encountered " "(" "( "" at line 10, column 42. Was expecting one of: "AS" .
sql关键字与系统冲突报错 Caused by: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token:
sfreedt的博客
10-18 4774
# sql关键字与系统冲突报错 Caused by: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "ORDER" "order"
解决：net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: “xx“ “xx“
zhaofuqiangmycomm的博客
05-07 2484
有的博客说@InterceptorIgnore(tenantLine = "true")的作用是对某个Mapper方法 忽略多租户处理，从这次报错来看不仅是这个作用，感觉应该还有忽略mysql关键词解析的作用,因为我的sql包含关键词database
解决报错net.sf.jsqlparser.statement.select.SelectBody
最新发布
2301_81878287的博客
07-24 1940
然后我的因为我的这个模块使用了mybatisplus的分页插件,和这个Spring依赖里面的分页产生了冲突,所以定位到问题之后我们就可以直接去排除这个依赖就行了。而这个报错,是告诉我们的分页依赖冲突,要加个jsqlparser依赖来解决这个冲突,也相当于平衡,但是可能因为我们版本的不匹配,还是会报错,例如下面这样。但是我们是不知道到底是什么依赖冲突的,这个时候就会用到一个工具,一个idea的插件 Maven Helper。当我们安装这个插件是,就可以在pom里面看见这个。
MybatisPlus执行sql语句报错：Caused by: net.sf.jsqlparser.parser.ParseException
socilents的博客
11-13 4266
mybatisplus多租户使用sql拦截导致的不能识别sql语句问题
Caused by: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: “:“ “:“
zh_chong的博客
12-22 1万+
先把我的SQL贴出来看一下： <select id="getAnnualReport" resultType="map"> SELECT b.* FROM ( SELECT @rownum := @rownum + 1 AS sort, a.* FROM (SELECT @rownum := 0) r, ( SELECT user_id AS userId, SUM(d
CCJSqlParserUtil Caused by: net.sf.jsqlparser.parser.ParseException: Encountered
qq_38377190的博客
05-25 6091
最近在实现一个功能 就是所有的sql语句都多加上一个查询条件 例如 key='XXXXXXXXX' 实现了mybatis 的拦截器 在拦截器重获取sql语句进行调整，部分代码如下 其中使用了CCJSqlParserUtil 这个工具类对进行sql解析，进行添加查询条件 在此过程中我碰到两个问题，并解决。这里分享给大家 问题一： 框框中代码，statementHandler 对象无法获取 delegate 值，通过尝试 在拦截配置代码中，我将拦截器顺序提前，得以解决。 问题二：..
net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "(" "("
drose29的博客
01-08 3万+
SQL放在Navicat运行 没有问题。 造成这个原因是 因为框架用了 Mybatis-Plus 。 框架中，有用到多租户的功能，Mybatis-plus 会 进行数据权限的过滤。。 要对该条sql，进行租户放行。 参考Mybatis-plus官网，在Mapper的SQL上 加入注解 @SqlParser(filter=true) 如果版本是3.1.1以上的 直接 添加...
在sql中使用函数，遇到net.sf.jsqlparser.parser.ParseException异常
ShineupUP的博客
10-25 4171
在sql中使用函数，遇到net.sf.jsqlparser.parser.ParseException异常 异常详情如下 Caused by: net.sf.jsqlparser.parser.ParseException: Encountered " “->” "-> “” at line 1, column 31. Was expecting one of: “AS” … “DO” … “ANY” … “KEY” … ……(中间省略很多符号) at net.sf.jsqlparser.pa
Caused by: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "VALUESw"
07-20
`net.sf.jsqlparser.parser.ParseException`是一个解析器异常，表明jsqlparser库在处理SQL语句时，在预期的位置没有找到正确的语法结构，这里特别提到的是"Encountered unexpected token: "VALUESw"`。 "VALUESw...
Caused by: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token:<EOF> at line 1, column 39.
07-12
这个错误是由于在SQL语句中遇到了意外的token（即不符合语法的部分），具体是在第1行第39列遇到了问题。这可能意味着你的SQL语句存在语法错误或者缺少某些必要的部分。请确保你的SQL语句按照正确的语法进行编写，...
net.sf.jsqlparser.parser.ParseException:+MyBatis-Plus写SQL时，like和like concat()的区别?
小菜椒的博客
12-30 675
net.sf.jsqlparser.parser.ParseException:+MyBatis-Plus在写SQL时，like和like concat()的区别
java.util.concurrent.ExecutionException: net.sf.jsqlparser.parser.ParseException: Encountered unexpe
poem_2010的博客
05-06 2939
【代码】java.util.concurrent.ExecutionException: net.sf.jsqlparser.parser.ParseException: Encountered unexpe。
net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: “:“ “:“
andwd的博客
03-30 7103
mybatis-plus报错net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: “:” “:” 问题原因 只要你的sql语句从idea控制台拿出来在数据库中可以正常运行但是在项目中报错是因为mybatis-plus框架中使用到了多租户功能，Mybatis-plus 会 进行数据权限的过滤，但是有些接口，其实并不想被多租户过滤，所以要对该条sql，进行租户放行。关于这块Mybatis-plus官网说明了 SqlParse
net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: “(“ “(“ at line 10, colum
热门推荐
T
03-16 3万+
报错： Cause: com.baomidou.mybatisplus.core.exceptions.MybatisPlusException: Failed to process, please exclude the tableName or statementId. Error SQL: select id,field_name,image_url from field WHERE 1=1...
net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: “.“ “.“ at line 7, column
zbyzsj的博客
02-21 703
查了很多，有人说是mp对于多租户进行数据权限的过滤，mapper层加注解 @InterceptorIgnore(tenantLine = "true")还是sql异常， 最后又在注解的基础上加了sql解析的依赖 问题解决 com.github.jsqlparser jsqlparser 4.0
net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: “)“ “)“ at line 3, column
qq_43564245的博客
05-05 1万+
在使用mybatis-plus进行条件查询时，遇到一个需求：使用一个输入框查询多个属性。乍一看这不挺简单的嘛，于是一通操作代码如下： LambdaQueryWrapper<Student> queryWrapper = new LambdaQueryWrapper<Student>(); queryWrapper.and(wrapper -> wrapper.like(Strings.isNotEmpty(student.getStudentName()),
pgsql:net.sf.jsqlparser.parser.parseexception: encountered unexpected token: “offset“ “OFFSET“
sfreedt的博客
09-29 1615
查看sql发现字段名别名有个别的与系统名重复，需要加 “”，可以再application.yml添加配置如下。生成的sql在pg数据库中可以运行，但是在程序中报错。
解决：net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: “=“ “=“
xiaozhang的博客
10-07 3万+
网上看了很多，说是因为MyBatis_Plus框架中，有多租户的功能，MP会进行数据权限的过滤，但是都试了试发现并不生效，记着之前遇到过这个问题，是因为那个包的版本原因导致的，但是忘了，这次就记下来吧，免得自己又忘了。1.排除其他依赖中的jsqlparser的包，引入新的jsqlparser，也可以只排除在其中一个的，使用另一个的jsqlparser包，不用重新导入。mybatis-plus包与原本存在的pagehelper存在com.github.jsqlparser:jsqlparser冲突。
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

yizhi-w

你的鼓励将是我创作的最大动力

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付：¥1
获取中
扫码支付

您的余额不足，请更换扫码支付或充值

打赏作者

实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

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

余额充值