美文网首页
疫苗-mybatis:[org.apache.ibatis.og

疫苗-mybatis:[org.apache.ibatis.og

作者: ontheway_sh | 来源:发表于2020-07-17 11:28 被阅读0次

    ERROR o.a.c.c.C.[.[localhost].[/].[dispatcherServlet] - Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception [Request processing failed; nested exception is org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.builder.BuilderException: Error evaluating expression 'brandId != null AND brandId > 0'. Cause: org.apache.ibatis.ognl.ExpressionSyntaxException: Malformed OGNL expression: brandId != null AND brandId > 0 [org.apache.ibatis.ognl.ParseException: Encountered " <IDENT> "AND "" at line 1, column 17.

    Was expecting one of:

        <EOF>

        "," ...

        "=" ...

        "?" ...

        "||" ...

        "or" ...

        "&&" ...

        "and" ...

        "|" ...

        "bor" ...

        "^" ...

        "xor" ...

        "&" ...

        "band" ...

        "==" ...

        "eq" ...

        "!=" ...

        "neq" ...

        "<" ...

        "lt" ...

        ">" ...

        "gt" ...

        "<=" ...

        "lte" ...

        ">=" ...

        "gte" ...

        "in" ...

        "not" ...

        "<<" ...

        "shl" ...

        ">>" ...

        "shr" ...

        ">>>" ...

        "ushr" ...

        "+" ...

        "-" ...

        "*" ...

        "/" ...

        "%" ...

        "instanceof" ...

        "." ...

        "(" ...

        "[" ...

        <DYNAMIC_SUBSCRIPT> ...

        ]] with root cause

    org.apache.ibatis.ognl.ParseException: Encountered " <IDENT> "AND "" at line 1, column 17.

    Was expecting one of:

        <EOF>

        "," ...

        "=" ...

        "?" ...

        "||" ...

        "or" ...

        "&&" ...

        "and" ...

        "|" ...

        "bor" ...

        "^" ...

        "xor" ...

        "&" ...

        "band" ...

        "==" ...

        "eq" ...

        "!=" ...

        "neq" ...

        "<" ...

        "lt" ...

        ">" ...

        "gt" ...

        "<=" ...

        "lte" ...

        ">=" ...

        "gte" ...

        "in" ...

        "not" ...

        "<<" ...

        "shl" ...

        ">>" ...

        "shr" ...

        ">>>" ...

        "ushr" ...

        "+" ...

        "-" ...

        "*" ...

        "/" ...

        "%" ...

        "instanceof" ...

        "." ...

        "(" ...

        "[" ...

        <DYNAMIC_SUBSCRIPT> ...

            at org.apache.ibatis.ognl.OgnlParser.generateParseException(OgnlParser.java:3172)

            at org.apache.ibatis.ognl.OgnlParser.jj_consume_token(OgnlParser.java:3051)

            at org.apache.ibatis.ognl.OgnlParser.topLevelExpression(OgnlParser.java:16)

            at org.apache.ibatis.ognl.Ognl.parseExpression(Ognl.java:110)

            at org.apache.ibatis.scripting.xmltags.OgnlCache.parseExpression(OgnlCache.java:55)

            at org.apache.ibatis.scripting.xmltags.OgnlCache.getValue(OgnlCache.java:46)

            at org.apache.ibatis.scripting.xmltags.ExpressionEvaluator.evaluateBoolean(ExpressionEvaluator.java:32)

            at org.apache.ibatis.scripting.xmltags.IfSqlNode.apply(IfSqlNode.java:34)

            at org.apache.ibatis.scripting.xmltags.MixedSqlNode.lambda$apply$0(MixedSqlNode.java:32)

            at java.util.ArrayList.forEach(ArrayList.java:1257)

            at org.apache.ibatis.scripting.xmltags.MixedSqlNode.apply(MixedSqlNode.java:32)

            at org.apache.ibatis.scripting.xmltags.DynamicSqlSource.getBoundSql(DynamicSqlSource.java:39)

            at org.apache.ibatis.mapping.MappedStatement.getBoundSql(MappedStatement.java:297)

            at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:134)

            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.apache.ibatis.plugin.Invocation.proceed(Invocation.java:49)

            at com.iiasaas.cic.intercept.mybatis.ImageCompleteIntercept.intercept(ImageCompleteIntercept.java:28)

            at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:61)

            at com.sun.proxy.$Proxy320.query(Unknown Source)

            at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:147)

            at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140)

            at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:76)

            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:426)

            at com.sun.proxy.$Proxy140.selectOne(Unknown Source)

            at org.mybatis.spring.SqlSessionTemplate.selectOne(SqlSessionTemplate.java:159)

            at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:87)

            at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:93)

            at com.sun.proxy.$Proxy157.countListPage(Unknown Source)

            at com.iiasaas.cic.service.merchant.DisBrandService.listPage(DisBrandService.java:65)

            at com.iiasaas.cic.controller.merchant.DisBrandController.listPage(DisBrandController.java:34)

            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:190)

            at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:138)

            at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:104)

            at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:892)

            at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:797)

            at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)

            at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1039)

            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.doGet(FrameworkServlet.java:897)

            at javax.servlet.http.HttpServlet.service(HttpServlet.java:634)

            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.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.cloud.sleuth.instrument.web.ExceptionLoggingFilter.doFilter(ExceptionLoggingFilter.java:50)

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

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

            at brave.servlet.TracingFilter.doFilter(TracingFilter.java:99)

            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:202)

            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:853)

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

            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)

    mybatis where-if中if不能识别大写AND,OR导致的异常,改成小写即可解决

    相关文章

      网友评论

          本文标题:疫苗-mybatis:[org.apache.ibatis.og

          本文链接:https://www.haomeiwen.com/subject/vgtghktx.html