常见异常汇总

  1. 目录

    登录异常

    org.apache.ibatis.binding.BindingException: Invalid bound statement (not found): com.jt.mapper.UserMapper.findUserByUP

    用户修改无反应

    org.apache.ibatis.binding.BindingException: Invalid bound statement (not found): com.jt.mapper.UserMapper.findByUP

     java.lang.NullPointerException: null

    org.springframework.beans.factory.UnsatisfiedDependencyException

    进入后无左侧菜单栏

    用户界面没有一级菜单显示

    用户界面没有一级菜单显示

    org.apache.ibatis.binding.BindingException: Invalid bound statement (not found): com.jt.mapper.UserMappe

    java.sql.SQLSyntaxErrorException: Unknown column 'parent_id' in 'field list'

    org.springframework.web.multipart.MaxUploadSizeExceededException: Maximum upload size exceeded; nested exception is java.lang.IllegalStateException: org.apache.tomcat.util.http.fileupload.impl.FileSizeLimitExceededException: The field file exceeds its maximum permitted size of 1048576 bytes.   

    前端报错

    java.lang.IllegalStateException: No instances available for sca-provider

    org.springframework.beans.factory.UnsatisfiedDependencyException

    Invalid bound statement (not found)


  2. 报错

    1. 
      
      org.apache.ibatis.binding.BindingException: Invalid bound statement (not found): com.jt.mapper.UserMapper.findUserByUP
      

    1. 出现情景
      1. spring框架中
    2. 原因与解决方案
      1. 由于xml文件中id与UserServiceImpl中方法不符导致,修改即可
      2. <?xml version="1.0" encoding="UTF-8" ?>
        <!DOCTYPE mapper
                PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
                "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
        
        <!--namespace是mybatis映射文件的唯一标识,与接口对应-->
        <mapper namespace="com.jt.mapper.UserMapper">
        
            <select id="findByUP" resultType="User">
                select * from user where username=#{username} and password=#{password};
            </select>
        
        
        
        
        </mapper>
        

        a

  3. 登录异常

    1. 现象

      1. 报错

        E:\JDK\jdk1.8\bin\java.exe -XX:TieredStopAtLevel=1 -noverify -Dspring.output.ansi.enabled=always -Dcom.sun.management.jmxremote -Dspring.jmx.enabled=true -Dspring.liveBeansView.mbeanDomain -Dspring.application.admin.enabled=true "-javaagent:E:\IDEA\IntelliJ IDEA 2020.1.1\lib\idea_rt.jar=13796:E:\IDEA\IntelliJ IDEA 2020.1.1\bin" -Dfile.encoding=UTF-8 -classpath E:\JDK\jdk1.8\jre\lib\charsets.jar;E:\JDK\jdk1.8\jre\lib\deploy.jar;E:\JDK\jdk1.8\jre\lib\ext\access-bridge-64.jar;E:\JDK\jdk1.8\jre\lib\ext\cldrdata.jar;E:\JDK\jdk1.8\jre\lib\ext\dnsns.jar;E:\JDK\jdk1.8\jre\lib\ext\jaccess.jar;E:\JDK\jdk1.8\jre\lib\ext\jfxrt.jar;E:\JDK\jdk1.8\jre\lib\ext\localedata.jar;E:\JDK\jdk1.8\jre\lib\ext\nashorn.jar;E:\JDK\jdk1.8\jre\lib\ext\sunec.jar;E:\JDK\jdk1.8\jre\lib\ext\sunjce_provider.jar;E:\JDK\jdk1.8\jre\lib\ext\sunmscapi.jar;E:\JDK\jdk1.8\jre\lib\ext\sunpkcs11.jar;E:\JDK\jdk1.8\jre\lib\ext\zipfs.jar;E:\JDK\jdk1.8\jre\lib\javaws.jar;E:\JDK\jdk1.8\jre\lib\jce.jar;E:\JDK\jdk1.8\jre\lib\jfr.jar;E:\JDK\jdk1.8\jre\lib\jfxswt.jar;E:\JDK\jdk1.8\jre\lib\jsse.jar;E:\JDK\jdk1.8\jre\lib\management-agent.jar;E:\JDK\jdk1.8\jre\lib\plugin.jar;E:\JDK\jdk1.8\jre\lib\resources.jar;E:\JDK\jdk1.8\jre\lib\rt.jar;E:\JavaPhase03\2109\jt\target\classes;E:\maven\resp\org\springframework\boot\spring-boot-starter-web\2.3.7.RELEASE\spring-boot-starter-web-2.3.7.RELEASE.jar;E:\maven\resp\org\springframework\boot\spring-boot-starter\2.3.7.RELEASE\spring-boot-starter-2.3.7.RELEASE.jar;E:\maven\resp\org\springframework\boot\spring-boot\2.3.7.RELEASE\spring-boot-2.3.7.RELEASE.jar;E:\maven\resp\org\springframework\boot\spring-boot-autoconfigure\2.3.7.RELEASE\spring-boot-autoconfigure-2.3.7.RELEASE.jar;E:\maven\resp\org\springframework\boot\spring-boot-starter-logging\2.3.7.RELEASE\spring-boot-starter-logging-2.3.7.RELEASE.jar;E:\maven\resp\ch\qos\logback\logback-classic\1.2.3\logback-classic-1.2.3.jar;E:\maven\resp\ch\qos\logback\logback-core\1.2.3\logback-core-1.2.3.jar;E:\maven\resp\org\apache\logging\log4j\log4j-to-slf4j\2.13.3\log4j-to-slf4j-2.13.3.jar;E:\maven\resp\org\apache\logging\log4j\log4j-api\2.13.3\log4j-api-2.13.3.jar;E:\maven\resp\org\slf4j\jul-to-slf4j\1.7.30\jul-to-slf4j-1.7.30.jar;E:\maven\resp\jakarta\annotation\jakarta.annotation-api\1.3.5\jakarta.annotation-api-1.3.5.jar;E:\maven\resp\org\yaml\snakeyaml\1.26\snakeyaml-1.26.jar;E:\maven\resp\org\springframework\boot\spring-boot-starter-json\2.3.7.RELEASE\spring-boot-starter-json-2.3.7.RELEASE.jar;E:\maven\resp\com\fasterxml\jackson\core\jackson-databind\2.11.3\jackson-databind-2.11.3.jar;E:\maven\resp\com\fasterxml\jackson\core\jackson-annotations\2.11.3\jackson-annotations-2.11.3.jar;E:\maven\resp\com\fasterxml\jackson\core\jackson-core\2.11.3\jackson-core-2.11.3.jar;E:\maven\resp\com\fasterxml\jackson\datatype\jackson-datatype-jdk8\2.11.3\jackson-datatype-jdk8-2.11.3.jar;E:\maven\resp\com\fasterxml\jackson\datatype\jackson-datatype-jsr310\2.11.3\jackson-datatype-jsr310-2.11.3.jar;E:\maven\resp\com\fasterxml\jackson\module\jackson-module-parameter-names\2.11.3\jackson-module-parameter-names-2.11.3.jar;E:\maven\resp\org\springframework\boot\spring-boot-starter-tomcat\2.3.7.RELEASE\spring-boot-starter-tomcat-2.3.7.RELEASE.jar;E:\maven\resp\org\apache\tomcat\embed\tomcat-embed-core\9.0.41\tomcat-embed-core-9.0.41.jar;E:\maven\resp\org\glassfish\jakarta.el\3.0.3\jakarta.el-3.0.3.jar;E:\maven\resp\org\apache\tomcat\embed\tomcat-embed-websocket\9.0.41\tomcat-embed-websocket-9.0.41.jar;E:\maven\resp\org\springframework\spring-web\5.2.12.RELEASE\spring-web-5.2.12.RELEASE.jar;E:\maven\resp\org\springframework\spring-beans\5.2.12.RELEASE\spring-beans-5.2.12.RELEASE.jar;E:\maven\resp\org\springframework\spring-webmvc\5.2.12.RELEASE\spring-webmvc-5.2.12.RELEASE.jar;E:\maven\resp\org\springframework\spring-aop\5.2.12.RELEASE\spring-aop-5.2.12.RELEASE.jar;E:\maven\resp\org\springframework\spring-context\5.2.12.RELEASE\spring-context-5.2.12.RELEASE.jar;E:\maven\resp\org\springframework\spring-expression\5.2.12.RELEASE\spring-expression-5.2.12.RELEASE.jar;E:\maven\resp\org\slf4j\slf4j-api\1.7.30\slf4j-api-1.7.30.jar;E:\maven\resp\org\springframework\spring-core\5.2.12.RELEASE\spring-core-5.2.12.RELEASE.jar;E:\maven\resp\org\springframework\spring-jcl\5.2.12.RELEASE\spring-jcl-5.2.12.RELEASE.jar;E:\maven\resp\org\mybatis\spring\boot\mybatis-spring-boot-starter\2.2.0\mybatis-spring-boot-starter-2.2.0.jar;E:\maven\resp\org\springframework\boot\spring-boot-starter-jdbc\2.3.7.RELEASE\spring-boot-starter-jdbc-2.3.7.RELEASE.jar;E:\maven\resp\com\zaxxer\HikariCP\3.4.5\HikariCP-3.4.5.jar;E:\maven\resp\org\springframework\spring-jdbc\5.2.12.RELEASE\spring-jdbc-5.2.12.RELEASE.jar;E:\maven\resp\org\springframework\spring-tx\5.2.12.RELEASE\spring-tx-5.2.12.RELEASE.jar;E:\maven\resp\org\mybatis\spring\boot\mybatis-spring-boot-autoconfigure\2.2.0\mybatis-spring-boot-autoconfigure-2.2.0.jar;E:\maven\resp\org\mybatis\mybatis\3.5.7\mybatis-3.5.7.jar;E:\maven\resp\org\mybatis\mybatis-spring\2.0.6\mybatis-spring-2.0.6.jar;E:\maven\resp\mysql\mysql-connector-java\8.0.22\mysql-connector-java-8.0.22.jar;E:\maven\resp\org\projectlombok\maven-lombok-plugin\0.9.3.1\maven-lombok-plugin-0.9.3.1.jar;E:\maven\resp\org\apache\maven\maven-plugin-api\2.0.9\maven-plugin-api-2.0.9.jar;E:\maven\resp\org\projectlombok\lombok\1.18.16\lombok-1.18.16.jar com.jt.JtApplication
        
          .   ____          _            __ _ _
         /\\ / ___'_ __ _ _(_)_ __  __ _ \ \ \ \
        ( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \
         \\/  ___)| |_)| | | | | || (_| |  ) ) ) )
          '  |____| .__|_| |_|_| |_\__, | / / / /
         =========|_|==============|___/=/_/_/_/
         :: Spring Boot ::        (v2.3.7.RELEASE)
        
        2021-12-10 00:39:34.282  INFO 25936 --- [           main] com.jt.JtApplication                     : Starting JtApplication on DESKTOP-PSB7JAF with PID 25936 (E:\JavaPhase03\2109\jt\target\classes started by du542115972 in E:\JavaPhase03\2109)
        2021-12-10 00:39:34.283  INFO 25936 --- [           main] com.jt.JtApplication                     : No active profile set, falling back to default profiles: default
        2021-12-10 00:39:34.775  INFO 25936 --- [           main] o.s.b.w.embedded.tomcat.TomcatWebServer  : Tomcat initialized with port(s): 8091 (http)
        2021-12-10 00:39:34.781  INFO 25936 --- [           main] o.apache.catalina.core.StandardService   : Starting service [Tomcat]
        2021-12-10 00:39:34.781  INFO 25936 --- [           main] org.apache.catalina.core.StandardEngine  : Starting Servlet engine: [Apache Tomcat/9.0.41]
        2021-12-10 00:39:34.815  INFO 25936 --- [           main] o.a.c.c.C.[Tomcat].[localhost].[/]       : Initializing Spring embedded WebApplicationContext
        2021-12-10 00:39:34.815  INFO 25936 --- [           main] w.s.c.ServletWebServerApplicationContext : Root WebApplicationContext: initialization completed in 508 ms
        2021-12-10 00:39:35.023  INFO 25936 --- [           main] o.s.s.concurrent.ThreadPoolTaskExecutor  : Initializing ExecutorService 'applicationTaskExecutor'
        2021-12-10 00:39:35.116  INFO 25936 --- [           main] o.s.b.w.embedded.tomcat.TomcatWebServer  : Tomcat started on port(s): 8091 (http) with context path ''
        2021-12-10 00:39:35.122  INFO 25936 --- [           main] com.jt.JtApplication                     : Started JtApplication in 1.052 seconds (JVM running for 1.435)
        2021-12-10 00:39:49.678  INFO 25936 --- [nio-8091-exec-1] o.a.c.c.C.[Tomcat].[localhost].[/]       : Initializing Spring DispatcherServlet 'dispatcherServlet'
        2021-12-10 00:39:49.678  INFO 25936 --- [nio-8091-exec-1] o.s.web.servlet.DispatcherServlet        : Initializing Servlet 'dispatcherServlet'
        2021-12-10 00:39:49.680  INFO 25936 --- [nio-8091-exec-1] o.s.web.servlet.DispatcherServlet        : Completed initialization in 2 ms
        2021-12-10 00:39:49.787  INFO 25936 --- [nio-8091-exec-2] com.zaxxer.hikari.HikariDataSource       : HikariPool-1 - Starting...
        2021-12-10 00:39:49.870  INFO 25936 --- [nio-8091-exec-2] com.zaxxer.hikari.HikariDataSource       : HikariPool-1 - Start completed.
        2021-12-10 00:39:49.874 DEBUG 25936 --- [nio-8091-exec-2] com.jt.mapper.UserMapper.findUserByUP    : ==>  Preparing: select * from user where username=? and password=?;
        2021-12-10 00:39:49.886 DEBUG 25936 --- [nio-8091-exec-2] com.jt.mapper.UserMapper.findUserByUP    : ==> Parameters: null, null
        2021-12-10 00:39:49.895 DEBUG 25936 --- [nio-8091-exec-2] com.jt.mapper.UserMapper.findUserByUP    : <==      Total: 0
        2021-12-10 00:39:50.748 DEBUG 25936 --- [nio-8091-exec-5] com.jt.mapper.UserMapper.findUserByUP    : ==>  Preparing: select * from user where username=? and password=?;
        2021-12-10 00:39:50.748 DEBUG 25936 --- [nio-8091-exec-5] com.jt.mapper.UserMapper.findUserByUP    : ==> Parameters: null, null
        2021-12-10 00:39:50.749 DEBUG 25936 --- [nio-8091-exec-5] com.jt.mapper.UserMapper.findUserByUP    : <==      Total: 0
        2021-12-10 00:39:50.938 DEBUG 25936 --- [nio-8091-exec-6] com.jt.mapper.UserMapper.findUserByUP    : ==>  Preparing: select * from user where username=? and password=?;
        2021-12-10 00:39:50.939 DEBUG 25936 --- [nio-8091-exec-6] com.jt.mapper.UserMapper.findUserByUP    : ==> Parameters: null, null
        2021-12-10 00:39:50.939 DEBUG 25936 --- [nio-8091-exec-6] com.jt.mapper.UserMapper.findUserByUP    : <==      Total: 0
        2021-12-10 00:39:51.097 DEBUG 25936 --- [nio-8091-exec-9] com.jt.mapper.UserMapper.findUserByUP    : ==>  Preparing: select * from user where username=? and password=?;
        2021-12-10 00:39:51.097 DEBUG 25936 --- [nio-8091-exec-9] com.jt.mapper.UserMapper.findUserByUP    : ==> Parameters: null, null
        2021-12-10 00:39:51.098 DEBUG 25936 --- [nio-8091-exec-9] com.jt.mapper.UserMapper.findUserByUP    : <==      Total: 0
        2021-12-10 00:39:51.231 DEBUG 25936 --- [nio-8091-exec-4] com.jt.mapper.UserMapper.findUserByUP    : ==>  Preparing: select * from user where username=? and password=?;
        2021-12-10 00:39:51.232 DEBUG 25936 --- [nio-8091-exec-4] com.jt.mapper.UserMapper.findUserByUP    : ==> Parameters: null, null
        2021-12-10 00:39:51.232 DEBUG 25936 --- [nio-8091-exec-4] com.jt.mapper.UserMapper.findUserByUP    : <==      Total: 0
        2021-12-10 00:39:51.357 DEBUG 25936 --- [nio-8091-exec-7] com.jt.mapper.UserMapper.findUserByUP    : ==>  Preparing: select * from user where username=? and password=?;
        2021-12-10 00:39:51.357 DEBUG 25936 --- [nio-8091-exec-7] com.jt.mapper.UserMapper.findUserByUP    : ==> Parameters: null, null
        2021-12-10 00:39:51.358 DEBUG 25936 --- [nio-8091-exec-7] com.jt.mapper.UserMapper.findUserByUP    : <==      Total: 0
        2021-12-10 00:39:51.493 DEBUG 25936 --- [nio-8091-exec-8] com.jt.mapper.UserMapper.findUserByUP    : ==>  Preparing: select * from user where username=? and password=?;
        2021-12-10 00:39:51.493 DEBUG 25936 --- [nio-8091-exec-8] com.jt.mapper.UserMapper.findUserByUP    : ==> Parameters: null, null
        2021-12-10 00:39:51.494 DEBUG 25936 --- [nio-8091-exec-8] com.jt.mapper.UserMapper.findUserByUP    : <==      Total: 0
        2021-12-10 00:39:51.607 DEBUG 25936 --- [nio-8091-exec-3] com.jt.mapper.UserMapper.findUserByUP    : ==>  Preparing: select * from user where username=? and password=?;
        2021-12-10 00:39:51.607 DEBUG 25936 --- [nio-8091-exec-3] com.jt.mapper.UserMapper.findUserByUP    : ==> Parameters: null, null
        2021-12-10 00:39:51.608 DEBUG 25936 --- [nio-8091-exec-3] com.jt.mapper.UserMapper.findUserByUP    : <==      Total: 0
        2021-12-10 00:39:51.971 DEBUG 25936 --- [io-8091-exec-10] com.jt.mapper.UserMapper.findUserByUP    : ==>  Preparing: select * from user where username=? and password=?;
        2021-12-10 00:39:51.971 DEBUG 25936 --- [io-8091-exec-10] com.jt.mapper.UserMapper.findUserByUP    : ==> Parameters: null, null
        2021-12-10 00:39:51.972 DEBUG 25936 --- [io-8091-exec-10] com.jt.mapper.UserMapper.findUserByUP    : <==      Total: 0
        2021-12-10 00:40:59.647 DEBUG 25936 --- [nio-8091-exec-2] com.jt.mapper.UserMapper.findUserByUP    : ==>  Preparing: select * from user where username=? and password=?;
        2021-12-10 00:40:59.647 DEBUG 25936 --- [nio-8091-exec-2] com.jt.mapper.UserMapper.findUserByUP    : ==> Parameters: null, null
        2021-12-10 00:40:59.647 DEBUG 25936 --- [nio-8091-exec-2] com.jt.mapper.UserMapper.findUserByUP    : <==      Total: 0
        

    2. 出现场景

      1. spring,user

    3. 原因及解决方案

      1. 在UserServiceImpl层,未将user传递给UserMapper,导致用户名密码未上传,上传即可 

  4. org.apache.ibatis.binding.BindingException: Invalid bound statement (not found): com.jt.mapper.UserMapper.findUserByUP

    1. 现象

    2. 异常

      1. 
        2021-12-10 10:45:48.898 ERROR 16944 --- [nio-8091-exec-4] o.a.c.c.C.[.[.[/].[dispatcherServlet]    : Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception [Request processing failed; nested exception is org.apache.ibatis.binding.BindingException: Invalid bound statement (not found): com.jt.mapper.UserMapper.findUSerList] with root cause
        
        org.apache.ibatis.binding.BindingException: Invalid bound statement (not found): com.jt.mapper.UserMapper.findUSerList
        	

    3. 原因及解决方案

      1.  @Override
            public PageResult findUserList(PageResult pageResult) {
                long total = userMapper.findTotal();
                int start=(pageResult.getPageNum()-1)*pageResult.getPageSize();
                int size=pageResult.getPageSize();
                String query=pageResult.getQuery();
                List<User> rows = userMapper.findUserList(start, size, query);
                //此处方法名写成了findUSerList(),导致mapper层写错,映射文件无法找到相应方法
                return pageResult.setTotal(total).setRows(rows);
            }
        

        a

  5. 用户修改无反应

    1. 现象

      1. 点击更改无反应

    2. 报错

    3. 原因及解决方案

      1. 
            @Override
            public User findUserById(Integer id) {
                return userMapper.findUserById(id);
            }
        

        UserServiceImpl返回值错误,更改即可

  6. org.apache.ibatis.binding.BindingException: Invalid bound statement (not found): com.jt.mapper.UserMapper.findByUP

    1. 报错

      1.  1

      2. 
        org.apache.ibatis.binding.BindingException: Invalid bound statement (not found): com.jt.mapper.UserMapper.findByUP
        	

    2. 出现场景

      1. spring

    3. 原因及解决方案

      1. application.yml文件中配置与resources中文件夹名不同,如下图

      2.  更改即可

  7.  java.lang.NullPointerException: null

    1. 报错
      1. D:\software\jdk1.8\bin\java.exe -XX:TieredStopAtLevel=1 -noverify -Dspring.output.ansi.enabled=always -Dcom.sun.management.jmxremote -Dspring.jmx.enabled=true -Dspring.liveBeansView.mbeanDomain -Dspring.application.admin.enabled=true "-javaagent:E:\IDEA\IntelliJ IDEA 2020.1.4\lib\idea_rt.jar=58517:E:\IDEA\IntelliJ IDEA 2020.1.4\bin" -Dfile.encoding=UTF-8 -classpath D:\software\jdk1.8\jre\lib\charsets.jar;D:\software\jdk1.8\jre\lib\deploy.jar;D:\software\jdk1.8\jre\lib\ext\access-bridge-64.jar;D:\software\jdk1.8\jre\lib\ext\cldrdata.jar;D:\software\jdk1.8\jre\lib\ext\dnsns.jar;D:\software\jdk1.8\jre\lib\ext\jaccess.jar;D:\software\jdk1.8\jre\lib\ext\jfxrt.jar;D:\software\jdk1.8\jre\lib\ext\localedata.jar;D:\software\jdk1.8\jre\lib\ext\nashorn.jar;D:\software\jdk1.8\jre\lib\ext\sunec.jar;D:\software\jdk1.8\jre\lib\ext\sunjce_provider.jar;D:\software\jdk1.8\jre\lib\ext\sunmscapi.jar;D:\software\jdk1.8\jre\lib\ext\sunpkcs11.jar;D:\software\jdk1.8\jre\lib\ext\zipfs.jar;D:\software\jdk1.8\jre\lib\javaws.jar;D:\software\jdk1.8\jre\lib\jce.jar;D:\software\jdk1.8\jre\lib\jfr.jar;D:\software\jdk1.8\jre\lib\jfxswt.jar;D:\software\jdk1.8\jre\lib\jsse.jar;D:\software\jdk1.8\jre\lib\management-agent.jar;D:\software\jdk1.8\jre\lib\plugin.jar;D:\software\jdk1.8\jre\lib\resources.jar;D:\software\jdk1.8\jre\lib\rt.jar;E:\JavaPhase03\2109\jt_02\target\classes;E:\maven\resp\org\springframework\boot\spring-boot-starter-web\2.3.7.RELEASE\spring-boot-starter-web-2.3.7.RELEASE.jar;E:\maven\resp\org\springframework\boot\spring-boot-starter\2.3.7.RELEASE\spring-boot-starter-2.3.7.RELEASE.jar;E:\maven\resp\org\springframework\boot\spring-boot\2.3.7.RELEASE\spring-boot-2.3.7.RELEASE.jar;E:\maven\resp\org\springframework\boot\spring-boot-autoconfigure\2.3.7.RELEASE\spring-boot-autoconfigure-2.3.7.RELEASE.jar;E:\maven\resp\org\springframework\boot\spring-boot-starter-logging\2.3.7.RELEASE\spring-boot-starter-logging-2.3.7.RELEASE.jar;E:\maven\resp\ch\qos\logback\logback-classic\1.2.3\logback-classic-1.2.3.jar;E:\maven\resp\ch\qos\logback\logback-core\1.2.3\logback-core-1.2.3.jar;E:\maven\resp\org\apache\logging\log4j\log4j-to-slf4j\2.13.3\log4j-to-slf4j-2.13.3.jar;E:\maven\resp\org\apache\logging\log4j\log4j-api\2.13.3\log4j-api-2.13.3.jar;E:\maven\resp\org\slf4j\jul-to-slf4j\1.7.30\jul-to-slf4j-1.7.30.jar;E:\maven\resp\jakarta\annotation\jakarta.annotation-api\1.3.5\jakarta.annotation-api-1.3.5.jar;E:\maven\resp\org\yaml\snakeyaml\1.26\snakeyaml-1.26.jar;E:\maven\resp\org\springframework\boot\spring-boot-starter-json\2.3.7.RELEASE\spring-boot-starter-json-2.3.7.RELEASE.jar;E:\maven\resp\com\fasterxml\jackson\core\jackson-databind\2.11.3\jackson-databind-2.11.3.jar;E:\maven\resp\com\fasterxml\jackson\core\jackson-annotations\2.11.3\jackson-annotations-2.11.3.jar;E:\maven\resp\com\fasterxml\jackson\core\jackson-core\2.11.3\jackson-core-2.11.3.jar;E:\maven\resp\com\fasterxml\jackson\datatype\jackson-datatype-jdk8\2.11.3\jackson-datatype-jdk8-2.11.3.jar;E:\maven\resp\com\fasterxml\jackson\datatype\jackson-datatype-jsr310\2.11.3\jackson-datatype-jsr310-2.11.3.jar;E:\maven\resp\com\fasterxml\jackson\module\jackson-module-parameter-names\2.11.3\jackson-module-parameter-names-2.11.3.jar;E:\maven\resp\org\springframework\boot\spring-boot-starter-tomcat\2.3.7.RELEASE\spring-boot-starter-tomcat-2.3.7.RELEASE.jar;E:\maven\resp\org\apache\tomcat\embed\tomcat-embed-core\9.0.41\tomcat-embed-core-9.0.41.jar;E:\maven\resp\org\glassfish\jakarta.el\3.0.3\jakarta.el-3.0.3.jar;E:\maven\resp\org\apache\tomcat\embed\tomcat-embed-websocket\9.0.41\tomcat-embed-websocket-9.0.41.jar;E:\maven\resp\org\springframework\spring-web\5.2.12.RELEASE\spring-web-5.2.12.RELEASE.jar;E:\maven\resp\org\springframework\spring-beans\5.2.12.RELEASE\spring-beans-5.2.12.RELEASE.jar;E:\maven\resp\org\springframework\spring-webmvc\5.2.12.RELEASE\spring-webmvc-5.2.12.RELEASE.jar;E:\maven\resp\org\springframework\spring-aop\5.2.12.RELEASE\spring-aop-5.2.12.RELEASE.jar;E:\maven\resp\org\springframework\spring-context\5.2.12.RELEASE\spring-context-5.2.12.RELEASE.jar;E:\maven\resp\org\springframework\spring-expression\5.2.12.RELEASE\spring-expression-5.2.12.RELEASE.jar;E:\maven\resp\org\slf4j\slf4j-api\1.7.30\slf4j-api-1.7.30.jar;E:\maven\resp\org\springframework\spring-core\5.2.12.RELEASE\spring-core-5.2.12.RELEASE.jar;E:\maven\resp\org\springframework\spring-jcl\5.2.12.RELEASE\spring-jcl-5.2.12.RELEASE.jar;E:\maven\resp\org\mybatis\spring\boot\mybatis-spring-boot-starter\2.2.0\mybatis-spring-boot-starter-2.2.0.jar;E:\maven\resp\org\springframework\boot\spring-boot-starter-jdbc\2.3.7.RELEASE\spring-boot-starter-jdbc-2.3.7.RELEASE.jar;E:\maven\resp\com\zaxxer\HikariCP\3.4.5\HikariCP-3.4.5.jar;E:\maven\resp\org\springframework\spring-jdbc\5.2.12.RELEASE\spring-jdbc-5.2.12.RELEASE.jar;E:\maven\resp\org\springframework\spring-tx\5.2.12.RELEASE\spring-tx-5.2.12.RELEASE.jar;E:\maven\resp\org\mybatis\spring\boot\mybatis-spring-boot-autoconfigure\2.2.0\mybatis-spring-boot-autoconfigure-2.2.0.jar;E:\maven\resp\org\mybatis\mybatis\3.5.7\mybatis-3.5.7.jar;E:\maven\resp\org\mybatis\mybatis-spring\2.0.6\mybatis-spring-2.0.6.jar;E:\maven\resp\mysql\mysql-connector-java\8.0.22\mysql-connector-java-8.0.22.jar;E:\maven\resp\org\projectlombok\maven-lombok-plugin\0.9.3.1\maven-lombok-plugin-0.9.3.1.jar;E:\maven\resp\org\apache\maven\maven-plugin-api\2.0.9\maven-plugin-api-2.0.9.jar;E:\maven\resp\org\projectlombok\lombok\1.18.16\lombok-1.18.16.jar com.jt.Jt02Application
        
          .   ____          _            __ _ _
         /\\ / ___'_ __ _ _(_)_ __  __ _ \ \ \ \
        ( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \
         \\/  ___)| |_)| | | | | || (_| |  ) ) ) )
          '  |____| .__|_| |_|_| |_\__, | / / / /
         =========|_|==============|___/=/_/_/_/
         :: Spring Boot ::        (v2.3.7.RELEASE)
        
        2021-12-11 15:27:06.743  INFO 10388 --- [           main] com.jt.Jt02Application                   : Starting Jt02Application on I91T1FM30VWNVX5 with PID 10388 (E:\JavaPhase03\2109\jt_02\target\classes started by Administrator in E:\JavaPhase03\2109)
        2021-12-11 15:27:06.747  INFO 10388 --- [           main] com.jt.Jt02Application                   : No active profile set, falling back to default profiles: default
        2021-12-11 15:27:08.081  INFO 10388 --- [           main] o.s.b.w.embedded.tomcat.TomcatWebServer  : Tomcat initialized with port(s): 8091 (http)
        2021-12-11 15:27:08.090  INFO 10388 --- [           main] o.apache.catalina.core.StandardService   : Starting service [Tomcat]
        2021-12-11 15:27:08.090  INFO 10388 --- [           main] org.apache.catalina.core.StandardEngine  : Starting Servlet engine: [Apache Tomcat/9.0.41]
        2021-12-11 15:27:08.151  INFO 10388 --- [           main] o.a.c.c.C.[Tomcat].[localhost].[/]       : Initializing Spring embedded WebApplicationContext
        2021-12-11 15:27:08.151  INFO 10388 --- [           main] w.s.c.ServletWebServerApplicationContext : Root WebApplicationContext: initialization completed in 1290 ms
        2021-12-11 15:27:08.514  INFO 10388 --- [           main] o.s.s.concurrent.ThreadPoolTaskExecutor  : Initializing ExecutorService 'applicationTaskExecutor'
        2021-12-11 15:27:08.702  INFO 10388 --- [           main] o.s.b.w.embedded.tomcat.TomcatWebServer  : Tomcat started on port(s): 8091 (http) with context path ''
        2021-12-11 15:27:08.711  INFO 10388 --- [           main] com.jt.Jt02Application                   : Started Jt02Application in 2.811 seconds (JVM running for 3.556)
        2021-12-11 15:27:19.588  INFO 10388 --- [nio-8091-exec-2] o.a.c.c.C.[Tomcat].[localhost].[/]       : Initializing Spring DispatcherServlet 'dispatcherServlet'
        2021-12-11 15:27:19.588  INFO 10388 --- [nio-8091-exec-2] o.s.web.servlet.DispatcherServlet        : Initializing Servlet 'dispatcherServlet'
        2021-12-11 15:27:19.594  INFO 10388 --- [nio-8091-exec-2] o.s.web.servlet.DispatcherServlet        : Completed initialization in 6 ms
        2021-12-11 15:27:19.653 ERROR 10388 --- [nio-8091-exec-2] o.a.c.c.C.[.[.[/].[dispatcherServlet]    : Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception [Request processing failed; nested exception is java.lang.NullPointerException] with root cause
        
        java.lang.NullPointerException: null
        	at com.jt.service.UserServiceImpl.login(UserServiceImpl.java:19) ~[classes/:na]
        	at com.jt.controller.UserController.login(UserController.java:21) ~[classes/:na]
        	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_45]
        	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) ~[na:1.8.0_45]
        	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) ~[na:1.8.0_45]
        	at java.lang.reflect.Method.invoke(Unknown Source) ~[na:1.8.0_45]
        	at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:190) ~[spring-web-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        	at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:138) ~[spring-web-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        	at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:105) ~[spring-webmvc-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:878) ~[spring-webmvc-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:792) ~[spring-webmvc-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        	at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87) ~[spring-webmvc-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        	at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1040) ~[spring-webmvc-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        	at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:943) ~[spring-webmvc-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        	at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006) ~[spring-webmvc-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        	at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:909) ~[spring-webmvc-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        	at javax.servlet.http.HttpServlet.service(HttpServlet.java:652) ~[tomcat-embed-core-9.0.41.jar:4.0.FR]
        	at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883) ~[spring-webmvc-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        	at javax.servlet.http.HttpServlet.service(HttpServlet.java:733) ~[tomcat-embed-core-9.0.41.jar:4.0.FR]
        	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) ~[tomcat-embed-core-9.0.41.jar:9.0.41]
        	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-9.0.41.jar:9.0.41]
        	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) ~[tomcat-embed-websocket-9.0.41.jar:9.0.41]
        	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[tomcat-embed-core-9.0.41.jar:9.0.41]
        	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-9.0.41.jar:9.0.41]
        	at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100) ~[spring-web-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) ~[spring-web-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[tomcat-embed-core-9.0.41.jar:9.0.41]
        	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-9.0.41.jar:9.0.41]
        	at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93) ~[spring-web-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) ~[spring-web-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[tomcat-embed-core-9.0.41.jar:9.0.41]
        	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-9.0.41.jar:9.0.41]
        	at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201) ~[spring-web-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) ~[spring-web-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[tomcat-embed-core-9.0.41.jar:9.0.41]
        	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-9.0.41.jar:9.0.41]
        	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202) ~[tomcat-embed-core-9.0.41.jar:9.0.41]
        	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97) [tomcat-embed-core-9.0.41.jar:9.0.41]
        	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:542) [tomcat-embed-core-9.0.41.jar:9.0.41]
        	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:143) [tomcat-embed-core-9.0.41.jar:9.0.41]
        	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) [tomcat-embed-core-9.0.41.jar:9.0.41]
        	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78) [tomcat-embed-core-9.0.41.jar:9.0.41]
        	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) [tomcat-embed-core-9.0.41.jar:9.0.41]
        	at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:374) [tomcat-embed-core-9.0.41.jar:9.0.41]
        	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) [tomcat-embed-core-9.0.41.jar:9.0.41]
        	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:888) [tomcat-embed-core-9.0.41.jar:9.0.41]
        	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1597) [tomcat-embed-core-9.0.41.jar:9.0.41]
        	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) [tomcat-embed-core-9.0.41.jar:9.0.41]
        	at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) [na:1.8.0_45]
        	at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [na:1.8.0_45]
        	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-embed-core-9.0.41.jar:9.0.41]
        	at java.lang.Thread.run(Unknown Source) [na:1.8.0_45]
        

        1

    2. 出现场景
      1. springboot
    3. 原因及解决方法
      1. package com.jt.controller;
        
        import com.jt.pojo.User;
        import com.jt.service.UserService;
        import com.jt.vo.SysResult;
        import org.springframework.beans.factory.annotation.Autowired;
        import org.springframework.web.bind.annotation.*;
        
        @RestController
        @RequestMapping("/user")
        @CrossOrigin
        public class UserController {
            @Autowired
            private UserService userService;
        
            @PostMapping("/login")
            public SysResult login(@RequestBody User user){
                String token=userService.login(user);
                if (token==null){
                    return SysResult.fail();
                }
                return SysResult.success(token);
            }
        }
        

        1

      2. Controller层没有加@RequestBody注解,导致后台没有接受到user的数据,报空指针异常

  8. org.springframework.beans.factory.UnsatisfiedDependencyException

    1. 报错

      1. 登录界面无反应

      2. D:\software\jdk1.8\bin\java.exe -XX:TieredStopAtLevel=1 -noverify -Dspring.output.ansi.enabled=always -Dcom.sun.management.jmxremote -Dspring.jmx.enabled=true -Dspring.liveBeansView.mbeanDomain -Dspring.application.admin.enabled=true "-javaagent:E:\IDEA\IntelliJ IDEA 2020.1.4\lib\idea_rt.jar=62024:E:\IDEA\IntelliJ IDEA 2020.1.4\bin" -Dfile.encoding=UTF-8 -classpath D:\software\jdk1.8\jre\lib\charsets.jar;D:\software\jdk1.8\jre\lib\deploy.jar;D:\software\jdk1.8\jre\lib\ext\access-bridge-64.jar;D:\software\jdk1.8\jre\lib\ext\cldrdata.jar;D:\software\jdk1.8\jre\lib\ext\dnsns.jar;D:\software\jdk1.8\jre\lib\ext\jaccess.jar;D:\software\jdk1.8\jre\lib\ext\jfxrt.jar;D:\software\jdk1.8\jre\lib\ext\localedata.jar;D:\software\jdk1.8\jre\lib\ext\nashorn.jar;D:\software\jdk1.8\jre\lib\ext\sunec.jar;D:\software\jdk1.8\jre\lib\ext\sunjce_provider.jar;D:\software\jdk1.8\jre\lib\ext\sunmscapi.jar;D:\software\jdk1.8\jre\lib\ext\sunpkcs11.jar;D:\software\jdk1.8\jre\lib\ext\zipfs.jar;D:\software\jdk1.8\jre\lib\javaws.jar;D:\software\jdk1.8\jre\lib\jce.jar;D:\software\jdk1.8\jre\lib\jfr.jar;D:\software\jdk1.8\jre\lib\jfxswt.jar;D:\software\jdk1.8\jre\lib\jsse.jar;D:\software\jdk1.8\jre\lib\management-agent.jar;D:\software\jdk1.8\jre\lib\plugin.jar;D:\software\jdk1.8\jre\lib\resources.jar;D:\software\jdk1.8\jre\lib\rt.jar;E:\JavaPhase03\2109\jt_02\target\classes;E:\maven\resp\org\springframework\boot\spring-boot-starter-web\2.3.7.RELEASE\spring-boot-starter-web-2.3.7.RELEASE.jar;E:\maven\resp\org\springframework\boot\spring-boot-starter\2.3.7.RELEASE\spring-boot-starter-2.3.7.RELEASE.jar;E:\maven\resp\org\springframework\boot\spring-boot\2.3.7.RELEASE\spring-boot-2.3.7.RELEASE.jar;E:\maven\resp\org\springframework\boot\spring-boot-autoconfigure\2.3.7.RELEASE\spring-boot-autoconfigure-2.3.7.RELEASE.jar;E:\maven\resp\org\springframework\boot\spring-boot-starter-logging\2.3.7.RELEASE\spring-boot-starter-logging-2.3.7.RELEASE.jar;E:\maven\resp\ch\qos\logback\logback-classic\1.2.3\logback-classic-1.2.3.jar;E:\maven\resp\ch\qos\logback\logback-core\1.2.3\logback-core-1.2.3.jar;E:\maven\resp\org\apache\logging\log4j\log4j-to-slf4j\2.13.3\log4j-to-slf4j-2.13.3.jar;E:\maven\resp\org\apache\logging\log4j\log4j-api\2.13.3\log4j-api-2.13.3.jar;E:\maven\resp\org\slf4j\jul-to-slf4j\1.7.30\jul-to-slf4j-1.7.30.jar;E:\maven\resp\jakarta\annotation\jakarta.annotation-api\1.3.5\jakarta.annotation-api-1.3.5.jar;E:\maven\resp\org\yaml\snakeyaml\1.26\snakeyaml-1.26.jar;E:\maven\resp\org\springframework\boot\spring-boot-starter-json\2.3.7.RELEASE\spring-boot-starter-json-2.3.7.RELEASE.jar;E:\maven\resp\com\fasterxml\jackson\core\jackson-databind\2.11.3\jackson-databind-2.11.3.jar;E:\maven\resp\com\fasterxml\jackson\core\jackson-annotations\2.11.3\jackson-annotations-2.11.3.jar;E:\maven\resp\com\fasterxml\jackson\core\jackson-core\2.11.3\jackson-core-2.11.3.jar;E:\maven\resp\com\fasterxml\jackson\datatype\jackson-datatype-jdk8\2.11.3\jackson-datatype-jdk8-2.11.3.jar;E:\maven\resp\com\fasterxml\jackson\datatype\jackson-datatype-jsr310\2.11.3\jackson-datatype-jsr310-2.11.3.jar;E:\maven\resp\com\fasterxml\jackson\module\jackson-module-parameter-names\2.11.3\jackson-module-parameter-names-2.11.3.jar;E:\maven\resp\org\springframework\boot\spring-boot-starter-tomcat\2.3.7.RELEASE\spring-boot-starter-tomcat-2.3.7.RELEASE.jar;E:\maven\resp\org\apache\tomcat\embed\tomcat-embed-core\9.0.41\tomcat-embed-core-9.0.41.jar;E:\maven\resp\org\glassfish\jakarta.el\3.0.3\jakarta.el-3.0.3.jar;E:\maven\resp\org\apache\tomcat\embed\tomcat-embed-websocket\9.0.41\tomcat-embed-websocket-9.0.41.jar;E:\maven\resp\org\springframework\spring-web\5.2.12.RELEASE\spring-web-5.2.12.RELEASE.jar;E:\maven\resp\org\springframework\spring-beans\5.2.12.RELEASE\spring-beans-5.2.12.RELEASE.jar;E:\maven\resp\org\springframework\spring-webmvc\5.2.12.RELEASE\spring-webmvc-5.2.12.RELEASE.jar;E:\maven\resp\org\springframework\spring-aop\5.2.12.RELEASE\spring-aop-5.2.12.RELEASE.jar;E:\maven\resp\org\springframework\spring-context\5.2.12.RELEASE\spring-context-5.2.12.RELEASE.jar;E:\maven\resp\org\springframework\spring-expression\5.2.12.RELEASE\spring-expression-5.2.12.RELEASE.jar;E:\maven\resp\org\slf4j\slf4j-api\1.7.30\slf4j-api-1.7.30.jar;E:\maven\resp\org\springframework\spring-core\5.2.12.RELEASE\spring-core-5.2.12.RELEASE.jar;E:\maven\resp\org\springframework\spring-jcl\5.2.12.RELEASE\spring-jcl-5.2.12.RELEASE.jar;E:\maven\resp\org\mybatis\spring\boot\mybatis-spring-boot-starter\2.2.0\mybatis-spring-boot-starter-2.2.0.jar;E:\maven\resp\org\springframework\boot\spring-boot-starter-jdbc\2.3.7.RELEASE\spring-boot-starter-jdbc-2.3.7.RELEASE.jar;E:\maven\resp\com\zaxxer\HikariCP\3.4.5\HikariCP-3.4.5.jar;E:\maven\resp\org\springframework\spring-jdbc\5.2.12.RELEASE\spring-jdbc-5.2.12.RELEASE.jar;E:\maven\resp\org\springframework\spring-tx\5.2.12.RELEASE\spring-tx-5.2.12.RELEASE.jar;E:\maven\resp\org\mybatis\spring\boot\mybatis-spring-boot-autoconfigure\2.2.0\mybatis-spring-boot-autoconfigure-2.2.0.jar;E:\maven\resp\org\mybatis\mybatis\3.5.7\mybatis-3.5.7.jar;E:\maven\resp\org\mybatis\mybatis-spring\2.0.6\mybatis-spring-2.0.6.jar;E:\maven\resp\mysql\mysql-connector-java\8.0.22\mysql-connector-java-8.0.22.jar;E:\maven\resp\org\projectlombok\maven-lombok-plugin\0.9.3.1\maven-lombok-plugin-0.9.3.1.jar;E:\maven\resp\org\apache\maven\maven-plugin-api\2.0.9\maven-plugin-api-2.0.9.jar;E:\maven\resp\org\projectlombok\lombok\1.18.16\lombok-1.18.16.jar com.jt.Jt02Application
        
          .   ____          _            __ _ _
         /\\ / ___'_ __ _ _(_)_ __  __ _ \ \ \ \
        ( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \
         \\/  ___)| |_)| | | | | || (_| |  ) ) ) )
          '  |____| .__|_| |_|_| |_\__, | / / / /
         =========|_|==============|___/=/_/_/_/
         :: Spring Boot ::        (v2.3.7.RELEASE)
        
        2021-12-11 17:09:28.790  INFO 12164 --- [           main] com.jt.Jt02Application                   : Starting Jt02Application on I91T1FM30VWNVX5 with PID 12164 (E:\JavaPhase03\2109\jt_02\target\classes started by Administrator in E:\JavaPhase03\2109)
        2021-12-11 17:09:28.795  INFO 12164 --- [           main] com.jt.Jt02Application                   : No active profile set, falling back to default profiles: default
        2021-12-11 17:09:30.110  INFO 12164 --- [           main] o.s.b.w.embedded.tomcat.TomcatWebServer  : Tomcat initialized with port(s): 8091 (http)
        2021-12-11 17:09:30.117  INFO 12164 --- [           main] o.apache.catalina.core.StandardService   : Starting service [Tomcat]
        2021-12-11 17:09:30.118  INFO 12164 --- [           main] org.apache.catalina.core.StandardEngine  : Starting Servlet engine: [Apache Tomcat/9.0.41]
        2021-12-11 17:09:30.188  INFO 12164 --- [           main] o.a.c.c.C.[Tomcat].[localhost].[/]       : Initializing Spring embedded WebApplicationContext
        2021-12-11 17:09:30.188  INFO 12164 --- [           main] w.s.c.ServletWebServerApplicationContext : Root WebApplicationContext: initialization completed in 1267 ms
        2021-12-11 17:09:30.441  WARN 12164 --- [           main] ConfigServletWebServerApplicationContext : Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'rightsController': Unsatisfied dependency expressed through field 'rightsService'; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'rightsServiceImpl': Unsatisfied dependency expressed through field 'rightsMapper'; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'rightsMapper' defined in file [E:\JavaPhase03\2109\jt_02\target\classes\com\jt\mapper\RightsMapper.class]: Unsatisfied dependency expressed through bean property 'sqlSessionFactory'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sqlSessionFactory' defined in class path resource [org/mybatis/spring/boot/autoconfigure/MybatisAutoConfiguration.class]: Bean instantiation via factory method failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [org.apache.ibatis.session.SqlSessionFactory]: Factory method 'sqlSessionFactory' threw exception; nested exception is org.springframework.core.NestedIOException: Failed to parse mapping resource: 'file [E:\JavaPhase03\2109\jt_02\target\classes\mappers\RightsMapper.xml]'; nested exception is org.apache.ibatis.builder.BuilderException: Error parsing Mapper XML. The XML location is 'file [E:\JavaPhase03\2109\jt_02\target\classes\mappers\RightsMapper.xml]'. Cause: org.apache.ibatis.builder.BuilderException: Ambiguous collection type for property 'children'. You must specify 'javaType' or 'resultMap'.
        2021-12-11 17:09:30.444  INFO 12164 --- [           main] o.apache.catalina.core.StandardService   : Stopping service [Tomcat]
        2021-12-11 17:09:30.452  INFO 12164 --- [           main] ConditionEvaluationReportLoggingListener : 
        
        Error starting ApplicationContext. To display the conditions report re-run your application with 'debug' enabled.
        2021-12-11 17:09:30.463 ERROR 12164 --- [           main] o.s.boot.SpringApplication               : Application run failed
        
        org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'rightsController': Unsatisfied dependency expressed through field 'rightsService'; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'rightsServiceImpl': Unsatisfied dependency expressed through field 'rightsMapper'; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'rightsMapper' defined in file [E:\JavaPhase03\2109\jt_02\target\classes\com\jt\mapper\RightsMapper.class]: Unsatisfied dependency expressed through bean property 'sqlSessionFactory'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sqlSessionFactory' defined in class path resource [org/mybatis/spring/boot/autoconfigure/MybatisAutoConfiguration.class]: Bean instantiation via factory method failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [org.apache.ibatis.session.SqlSessionFactory]: Factory method 'sqlSessionFactory' threw exception; nested exception is org.springframework.core.NestedIOException: Failed to parse mapping resource: 'file [E:\JavaPhase03\2109\jt_02\target\classes\mappers\RightsMapper.xml]'; nested exception is org.apache.ibatis.builder.BuilderException: Error parsing Mapper XML. The XML location is 'file [E:\JavaPhase03\2109\jt_02\target\classes\mappers\RightsMapper.xml]'. Cause: org.apache.ibatis.builder.BuilderException: Ambiguous collection type for property 'children'. You must specify 'javaType' or 'resultMap'.
        	at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:643) ~[spring-beans-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        	at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:119) ~[spring-beans-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        	at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessProperties(AutowiredAnnotationBeanPostProcessor.java:399) ~[spring-beans-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1420) ~[spring-beans-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:593) ~[spring-beans-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:516) ~[spring-beans-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        	at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:324) ~[spring-beans-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        	at org.springframework.beans.factory.support.AbstractBeanFactory$$Lambda$168/1963862935.getObject(Unknown Source) ~[na:na]
        	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234) ~[spring-beans-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:322) ~[spring-beans-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202) ~[spring-beans-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        	at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:897) ~[spring-beans-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        	at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:879) ~[spring-context-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        	at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:551) ~[spring-context-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        	at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:143) ~[spring-boot-2.3.7.RELEASE.jar:2.3.7.RELEASE]
        	at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:758) [spring-boot-2.3.7.RELEASE.jar:2.3.7.RELEASE]
        	at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:750) [spring-boot-2.3.7.RELEASE.jar:2.3.7.RELEASE]
        	at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:405) [spring-boot-2.3.7.RELEASE.jar:2.3.7.RELEASE]
        	at org.springframework.boot.SpringApplication.run(SpringApplication.java:315) [spring-boot-2.3.7.RELEASE.jar:2.3.7.RELEASE]
        	at org.springframework.boot.SpringApplication.run(SpringApplication.java:1237) [spring-boot-2.3.7.RELEASE.jar:2.3.7.RELEASE]
        	at org.springframework.boot.SpringApplication.run(SpringApplication.java:1226) [spring-boot-2.3.7.RELEASE.jar:2.3.7.RELEASE]
        	at com.jt.Jt02Application.main(Jt02Application.java:12) [classes/:na]
        Caused by: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'rightsServiceImpl': Unsatisfied dependency expressed through field 'rightsMapper'; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'rightsMapper' defined in file [E:\JavaPhase03\2109\jt_02\target\classes\com\jt\mapper\RightsMapper.class]: Unsatisfied dependency expressed through bean property 'sqlSessionFactory'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sqlSessionFactory' defined in class path resource [org/mybatis/spring/boot/autoconfigure/MybatisAutoConfiguration.class]: Bean instantiation via factory method failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [org.apache.ibatis.session.SqlSessionFactory]: Factory method 'sqlSessionFactory' threw exception; nested exception is org.springframework.core.NestedIOException: Failed to parse mapping resource: 'file [E:\JavaPhase03\2109\jt_02\target\classes\mappers\RightsMapper.xml]'; nested exception is org.apache.ibatis.builder.BuilderException: Error parsing Mapper XML. The XML location is 'file [E:\JavaPhase03\2109\jt_02\target\classes\mappers\RightsMapper.xml]'. Cause: org.apache.ibatis.builder.BuilderException: Ambiguous collection type for property 'children'. You must specify 'javaType' or 'resultMap'.
        	at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:643) ~[spring-beans-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        	at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:119) ~[spring-beans-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        	at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessProperties(AutowiredAnnotationBeanPostProcessor.java:399) ~[spring-beans-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1420) ~[spring-beans-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:593) ~[spring-beans-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:516) ~[spring-beans-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        	at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:324) ~[spring-beans-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        	at org.springframework.beans.factory.support.AbstractBeanFactory$$Lambda$168/1963862935.getObject(Unknown Source) ~[na:na]
        	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234) ~[spring-beans-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:322) ~[spring-beans-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202) ~[spring-beans-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        	at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:276) ~[spring-beans-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        	at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1307) ~[spring-beans-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        	at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1227) ~[spring-beans-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        	at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:640) ~[spring-beans-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        	... 21 common frames omitted
        Caused by: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'rightsMapper' defined in file [E:\JavaPhase03\2109\jt_02\target\classes\com\jt\mapper\RightsMapper.class]: Unsatisfied dependency expressed through bean property 'sqlSessionFactory'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sqlSessionFactory' defined in class path resource [org/mybatis/spring/boot/autoconfigure/MybatisAutoConfiguration.class]: Bean instantiation via factory method failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [org.apache.ibatis.session.SqlSessionFactory]: Factory method 'sqlSessionFactory' threw exception; nested exception is org.springframework.core.NestedIOException: Failed to parse mapping resource: 'file [E:\JavaPhase03\2109\jt_02\target\classes\mappers\RightsMapper.xml]'; nested exception is org.apache.ibatis.builder.BuilderException: Error parsing Mapper XML. The XML location is 'file [E:\JavaPhase03\2109\jt_02\target\classes\mappers\RightsMapper.xml]'. Cause: org.apache.ibatis.builder.BuilderException: Ambiguous collection type for property 'children'. You must specify 'javaType' or 'resultMap'.
        	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireByType(AbstractAutowireCapableBeanFactory.java:1524) ~[spring-beans-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1404) ~[spring-beans-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:593) ~[spring-beans-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:516) ~[spring-beans-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        	at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:324) ~[spring-beans-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        	at org.springframework.beans.factory.support.AbstractBeanFactory$$Lambda$168/1963862935.getObject(Unknown Source) ~[na:na]
        	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234) ~[spring-beans-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:322) ~[spring-beans-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202) ~[spring-beans-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        	at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:276) ~[spring-beans-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        	at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1307) ~[spring-beans-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        	at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1227) ~[spring-beans-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        	at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:640) ~[spring-beans-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        	... 35 common frames omitted
        Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sqlSessionFactory' defined in class path resource [org/mybatis/spring/boot/autoconfigure/MybatisAutoConfiguration.class]: Bean instantiation via factory method failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [org.apache.ibatis.session.SqlSessionFactory]: Factory method 'sqlSessionFactory' threw exception; nested exception is org.springframework.core.NestedIOException: Failed to parse mapping resource: 'file [E:\JavaPhase03\2109\jt_02\target\classes\mappers\RightsMapper.xml]'; nested exception is org.apache.ibatis.builder.BuilderException: Error parsing Mapper XML. The XML location is 'file [E:\JavaPhase03\2109\jt_02\target\classes\mappers\RightsMapper.xml]'. Cause: org.apache.ibatis.builder.BuilderException: Ambiguous collection type for property 'children'. You must specify 'javaType' or 'resultMap'.
        	at org.springframework.beans.factory.support.ConstructorResolver.instantiate(ConstructorResolver.java:657) ~[spring-beans-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        	at org.springframework.beans.factory.support.ConstructorResolver.instantiateUsingFactoryMethod(ConstructorResolver.java:637) ~[spring-beans-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateUsingFactoryMethod(AbstractAutowireCapableBeanFactory.java:1336) ~[spring-beans-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1176) ~[spring-beans-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:556) ~[spring-beans-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:516) ~[spring-beans-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        	at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:324) ~[spring-beans-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        	at org.springframework.beans.factory.support.AbstractBeanFactory$$Lambda$168/1963862935.getObject(Unknown Source) ~[na:na]
        	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234) ~[spring-beans-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:322) ~[spring-beans-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202) ~[spring-beans-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        	at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:276) ~[spring-beans-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        	at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1307) ~[spring-beans-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        	at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1227) ~[spring-beans-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireByType(AbstractAutowireCapableBeanFactory.java:1509) ~[spring-beans-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        	... 47 common frames omitted
        Caused by: org.springframework.beans.BeanInstantiationException: Failed to instantiate [org.apache.ibatis.session.SqlSessionFactory]: Factory method 'sqlSessionFactory' threw exception; nested exception is org.springframework.core.NestedIOException: Failed to parse mapping resource: 'file [E:\JavaPhase03\2109\jt_02\target\classes\mappers\RightsMapper.xml]'; nested exception is org.apache.ibatis.builder.BuilderException: Error parsing Mapper XML. The XML location is 'file [E:\JavaPhase03\2109\jt_02\target\classes\mappers\RightsMapper.xml]'. Cause: org.apache.ibatis.builder.BuilderException: Ambiguous collection type for property 'children'. You must specify 'javaType' or 'resultMap'.
        	at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:185) ~[spring-beans-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        	at org.springframework.beans.factory.support.ConstructorResolver.instantiate(ConstructorResolver.java:652) ~[spring-beans-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        	... 61 common frames omitted
        Caused by: org.springframework.core.NestedIOException: Failed to parse mapping resource: 'file [E:\JavaPhase03\2109\jt_02\target\classes\mappers\RightsMapper.xml]'; nested exception is org.apache.ibatis.builder.BuilderException: Error parsing Mapper XML. The XML location is 'file [E:\JavaPhase03\2109\jt_02\target\classes\mappers\RightsMapper.xml]'. Cause: org.apache.ibatis.builder.BuilderException: Ambiguous collection type for property 'children'. You must specify 'javaType' or 'resultMap'.
        	at org.mybatis.spring.SqlSessionFactoryBean.buildSqlSessionFactory(SqlSessionFactoryBean.java:613) ~[mybatis-spring-2.0.6.jar:2.0.6]
        	at org.mybatis.spring.SqlSessionFactoryBean.afterPropertiesSet(SqlSessionFactoryBean.java:491) ~[mybatis-spring-2.0.6.jar:2.0.6]
        	at org.mybatis.spring.SqlSessionFactoryBean.getObject(SqlSessionFactoryBean.java:633) ~[mybatis-spring-2.0.6.jar:2.0.6]
        	at org.mybatis.spring.boot.autoconfigure.MybatisAutoConfiguration.sqlSessionFactory(MybatisAutoConfiguration.java:179) ~[mybatis-spring-boot-autoconfigure-2.2.0.jar:2.2.0]
        	at org.mybatis.spring.boot.autoconfigure.MybatisAutoConfiguration$$EnhancerBySpringCGLIB$$e1fe1551.CGLIB$sqlSessionFactory$2(<generated>) ~[mybatis-spring-boot-autoconfigure-2.2.0.jar:2.2.0]
        	at org.mybatis.spring.boot.autoconfigure.MybatisAutoConfiguration$$EnhancerBySpringCGLIB$$e1fe1551$$FastClassBySpringCGLIB$$9e87ea99.invoke(<generated>) ~[mybatis-spring-boot-autoconfigure-2.2.0.jar:2.2.0]
        	at org.springframework.cglib.proxy.MethodProxy.invokeSuper(MethodProxy.java:244) ~[spring-core-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        	at org.springframework.context.annotation.ConfigurationClassEnhancer$BeanMethodInterceptor.intercept(ConfigurationClassEnhancer.java:331) ~[spring-context-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        	at org.mybatis.spring.boot.autoconfigure.MybatisAutoConfiguration$$EnhancerBySpringCGLIB$$e1fe1551.sqlSessionFactory(<generated>) ~[mybatis-spring-boot-autoconfigure-2.2.0.jar:2.2.0]
        	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_45]
        	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) ~[na:1.8.0_45]
        	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) ~[na:1.8.0_45]
        	at java.lang.reflect.Method.invoke(Unknown Source) ~[na:1.8.0_45]
        	at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:154) ~[spring-beans-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        	... 62 common frames omitted
        Caused by: org.apache.ibatis.builder.BuilderException: Error parsing Mapper XML. The XML location is 'file [E:\JavaPhase03\2109\jt_02\target\classes\mappers\RightsMapper.xml]'. Cause: org.apache.ibatis.builder.BuilderException: Ambiguous collection type for property 'children'. You must specify 'javaType' or 'resultMap'.
        	at org.apache.ibatis.builder.xml.XMLMapperBuilder.configurationElement(XMLMapperBuilder.java:123) ~[mybatis-3.5.7.jar:3.5.7]
        	at org.apache.ibatis.builder.xml.XMLMapperBuilder.parse(XMLMapperBuilder.java:95) ~[mybatis-3.5.7.jar:3.5.7]
        	at org.mybatis.spring.SqlSessionFactoryBean.buildSqlSessionFactory(SqlSessionFactoryBean.java:611) ~[mybatis-spring-2.0.6.jar:2.0.6]
        	... 75 common frames omitted
        Caused by: org.apache.ibatis.builder.BuilderException: Ambiguous collection type for property 'children'. You must specify 'javaType' or 'resultMap'.
        	at org.apache.ibatis.builder.xml.XMLMapperBuilder.validateCollection(XMLMapperBuilder.java:412) ~[mybatis-3.5.7.jar:3.5.7]
        	at org.apache.ibatis.builder.xml.XMLMapperBuilder.processNestedResultMappings(XMLMapperBuilder.java:399) ~[mybatis-3.5.7.jar:3.5.7]
        	at org.apache.ibatis.builder.xml.XMLMapperBuilder.lambda$buildResultMappingFromContext$0(XMLMapperBuilder.java:383) ~[mybatis-3.5.7.jar:3.5.7]
        	at org.apache.ibatis.builder.xml.XMLMapperBuilder$$Lambda$434/1472036907.get(Unknown Source) ~[na:na]
        	at org.apache.ibatis.parsing.XNode.getStringAttribute(XNode.java:200) ~[mybatis-3.5.7.jar:3.5.7]
        	at org.apache.ibatis.builder.xml.XMLMapperBuilder.buildResultMappingFromContext(XMLMapperBuilder.java:382) ~[mybatis-3.5.7.jar:3.5.7]
        	at org.apache.ibatis.builder.xml.XMLMapperBuilder.resultMapElement(XMLMapperBuilder.java:280) ~[mybatis-3.5.7.jar:3.5.7]
        	at org.apache.ibatis.builder.xml.XMLMapperBuilder.resultMapElement(XMLMapperBuilder.java:254) ~[mybatis-3.5.7.jar:3.5.7]
        	at org.apache.ibatis.builder.xml.XMLMapperBuilder.resultMapElements(XMLMapperBuilder.java:246) ~[mybatis-3.5.7.jar:3.5.7]
        	at org.apache.ibatis.builder.xml.XMLMapperBuilder.configurationElement(XMLMapperBuilder.java:119) ~[mybatis-3.5.7.jar:3.5.7]
        	... 77 common frames omitted
        
        
        Process finished with exit code 1
        

        1

    2. 出现场景

      1. springboot

    3. 原因及解决方案

      1. <resultMap id="rightsRM" type="Rights" autoMapping="true">
                <id column="id" property="id"/>
                <collection property="children" ofType="Rights">
                    <id column="c_id" property="id"/>
                    <result column="c_name" property="name"/>
                    <result column="c_parent_id" property="parentId"/>
                    <result column="c_path" property="path"/>
                    <result column="c_level" property="level"/>
                    <result column="c_created" property="created"/>
                    <result column="c_updated" property="updated"/>
                </collection>
            </resultMap>

        type后的类型填错,写成了"User",改正后正常运行

  9. 进入后无左侧菜单栏

    1. 报错

      1. 仅前端getRighsList报404,后端无错误显示

    2. 出现场景

      1. springboot

    3. 原因及解决方案

      1.     @GetMapping("/getRightsList")
            public SysResult getRightsList(){
                List<Rights> list =rightsService.getRightsList();
                return SysResult.success(list);
            }

        controller注解层没有写后缀,增加即可

  10. 用户界面没有一级菜单显示

    1. 现象

      1. 1

    2. 场景

      1. springboot

    3. 原因及解决方案

      1.  <resultMap id="rightsRM" type="Rights" autoMapping="true">

        映射文件中没加autoMapping,加上即可

      2. auotoMapping,自动关联映射,有自动关联映射时需要打开,相当于调用驼峰规则

  11. 用户界面没有一级菜单显示

    1. 现象

    2. 出现场景

      1. springboot

    3. 原因及解决方案

      1.     <select id="getRightsList" resultMap="rightsRM">
                select * from /*此处多加了rights表格名,删除即可*/
                (select * from rights where parent_id=0) p
                left join
                (select id c_id,
                NAME c_name,
                parent_id c_parent_id,
                path c_path,
                LEVEL c_level,
                created c_created,
                updated c_updated
                from rights) c
                on p.id=c.c_parent_id;
            </select>

        映射文件出错,改正即可

  12. org.apache.ibatis.binding.BindingException: Invalid bound statement (not found): com.jt.mapper.UserMappe

    1. 现象

      1. 前端分页页面不显示

      2. 后端报错

        E:\JDK\jdk1.8\bin\java.exe -XX:TieredStopAtLevel=1 -noverify -Dspring.output.ansi.enabled=always -Dcom.sun.management.jmxremote -Dspring.jmx.enabled=true -Dspring.liveBeansView.mbeanDomain -Dspring.application.admin.enabled=true "-javaagent:E:\IDEA\IntelliJ IDEA 2020.1.1\lib\idea_rt.jar=2257:E:\IDEA\IntelliJ IDEA 2020.1.1\bin" -Dfile.encoding=UTF-8 -classpath E:\JDK\jdk1.8\jre\lib\charsets.jar;E:\JDK\jdk1.8\jre\lib\deploy.jar;E:\JDK\jdk1.8\jre\lib\ext\access-bridge-64.jar;E:\JDK\jdk1.8\jre\lib\ext\cldrdata.jar;E:\JDK\jdk1.8\jre\lib\ext\dnsns.jar;E:\JDK\jdk1.8\jre\lib\ext\jaccess.jar;E:\JDK\jdk1.8\jre\lib\ext\jfxrt.jar;E:\JDK\jdk1.8\jre\lib\ext\localedata.jar;E:\JDK\jdk1.8\jre\lib\ext\nashorn.jar;E:\JDK\jdk1.8\jre\lib\ext\sunec.jar;E:\JDK\jdk1.8\jre\lib\ext\sunjce_provider.jar;E:\JDK\jdk1.8\jre\lib\ext\sunmscapi.jar;E:\JDK\jdk1.8\jre\lib\ext\sunpkcs11.jar;E:\JDK\jdk1.8\jre\lib\ext\zipfs.jar;E:\JDK\jdk1.8\jre\lib\javaws.jar;E:\JDK\jdk1.8\jre\lib\jce.jar;E:\JDK\jdk1.8\jre\lib\jfr.jar;E:\JDK\jdk1.8\jre\lib\jfxswt.jar;E:\JDK\jdk1.8\jre\lib\jsse.jar;E:\JDK\jdk1.8\jre\lib\management-agent.jar;E:\JDK\jdk1.8\jre\lib\plugin.jar;E:\JDK\jdk1.8\jre\lib\resources.jar;E:\JDK\jdk1.8\jre\lib\rt.jar;E:\JavaPhase03\2109\jt_02\target\classes;E:\maven\resp\org\springframework\boot\spring-boot-starter-web\2.3.7.RELEASE\spring-boot-starter-web-2.3.7.RELEASE.jar;E:\maven\resp\org\springframework\boot\spring-boot-starter\2.3.7.RELEASE\spring-boot-starter-2.3.7.RELEASE.jar;E:\maven\resp\org\springframework\boot\spring-boot\2.3.7.RELEASE\spring-boot-2.3.7.RELEASE.jar;E:\maven\resp\org\springframework\boot\spring-boot-autoconfigure\2.3.7.RELEASE\spring-boot-autoconfigure-2.3.7.RELEASE.jar;E:\maven\resp\org\springframework\boot\spring-boot-starter-logging\2.3.7.RELEASE\spring-boot-starter-logging-2.3.7.RELEASE.jar;E:\maven\resp\ch\qos\logback\logback-classic\1.2.3\logback-classic-1.2.3.jar;E:\maven\resp\ch\qos\logback\logback-core\1.2.3\logback-core-1.2.3.jar;E:\maven\resp\org\apache\logging\log4j\log4j-to-slf4j\2.13.3\log4j-to-slf4j-2.13.3.jar;E:\maven\resp\org\apache\logging\log4j\log4j-api\2.13.3\log4j-api-2.13.3.jar;E:\maven\resp\org\slf4j\jul-to-slf4j\1.7.30\jul-to-slf4j-1.7.30.jar;E:\maven\resp\jakarta\annotation\jakarta.annotation-api\1.3.5\jakarta.annotation-api-1.3.5.jar;E:\maven\resp\org\yaml\snakeyaml\1.26\snakeyaml-1.26.jar;E:\maven\resp\org\springframework\boot\spring-boot-starter-json\2.3.7.RELEASE\spring-boot-starter-json-2.3.7.RELEASE.jar;E:\maven\resp\com\fasterxml\jackson\core\jackson-databind\2.11.3\jackson-databind-2.11.3.jar;E:\maven\resp\com\fasterxml\jackson\core\jackson-annotations\2.11.3\jackson-annotations-2.11.3.jar;E:\maven\resp\com\fasterxml\jackson\core\jackson-core\2.11.3\jackson-core-2.11.3.jar;E:\maven\resp\com\fasterxml\jackson\datatype\jackson-datatype-jdk8\2.11.3\jackson-datatype-jdk8-2.11.3.jar;E:\maven\resp\com\fasterxml\jackson\datatype\jackson-datatype-jsr310\2.11.3\jackson-datatype-jsr310-2.11.3.jar;E:\maven\resp\com\fasterxml\jackson\module\jackson-module-parameter-names\2.11.3\jackson-module-parameter-names-2.11.3.jar;E:\maven\resp\org\springframework\boot\spring-boot-starter-tomcat\2.3.7.RELEASE\spring-boot-starter-tomcat-2.3.7.RELEASE.jar;E:\maven\resp\org\apache\tomcat\embed\tomcat-embed-core\9.0.41\tomcat-embed-core-9.0.41.jar;E:\maven\resp\org\glassfish\jakarta.el\3.0.3\jakarta.el-3.0.3.jar;E:\maven\resp\org\apache\tomcat\embed\tomcat-embed-websocket\9.0.41\tomcat-embed-websocket-9.0.41.jar;E:\maven\resp\org\springframework\spring-web\5.2.12.RELEASE\spring-web-5.2.12.RELEASE.jar;E:\maven\resp\org\springframework\spring-beans\5.2.12.RELEASE\spring-beans-5.2.12.RELEASE.jar;E:\maven\resp\org\springframework\spring-webmvc\5.2.12.RELEASE\spring-webmvc-5.2.12.RELEASE.jar;E:\maven\resp\org\springframework\spring-aop\5.2.12.RELEASE\spring-aop-5.2.12.RELEASE.jar;E:\maven\resp\org\springframework\spring-context\5.2.12.RELEASE\spring-context-5.2.12.RELEASE.jar;E:\maven\resp\org\springframework\spring-expression\5.2.12.RELEASE\spring-expression-5.2.12.RELEASE.jar;E:\maven\resp\org\slf4j\slf4j-api\1.7.30\slf4j-api-1.7.30.jar;E:\maven\resp\org\springframework\spring-core\5.2.12.RELEASE\spring-core-5.2.12.RELEASE.jar;E:\maven\resp\org\springframework\spring-jcl\5.2.12.RELEASE\spring-jcl-5.2.12.RELEASE.jar;E:\maven\resp\org\mybatis\spring\boot\mybatis-spring-boot-starter\2.2.0\mybatis-spring-boot-starter-2.2.0.jar;E:\maven\resp\org\springframework\boot\spring-boot-starter-jdbc\2.3.7.RELEASE\spring-boot-starter-jdbc-2.3.7.RELEASE.jar;E:\maven\resp\com\zaxxer\HikariCP\3.4.5\HikariCP-3.4.5.jar;E:\maven\resp\org\springframework\spring-jdbc\5.2.12.RELEASE\spring-jdbc-5.2.12.RELEASE.jar;E:\maven\resp\org\springframework\spring-tx\5.2.12.RELEASE\spring-tx-5.2.12.RELEASE.jar;E:\maven\resp\org\mybatis\spring\boot\mybatis-spring-boot-autoconfigure\2.2.0\mybatis-spring-boot-autoconfigure-2.2.0.jar;E:\maven\resp\org\mybatis\mybatis\3.5.7\mybatis-3.5.7.jar;E:\maven\resp\org\mybatis\mybatis-spring\2.0.6\mybatis-spring-2.0.6.jar;E:\maven\resp\mysql\mysql-connector-java\8.0.22\mysql-connector-java-8.0.22.jar;E:\maven\resp\org\projectlombok\maven-lombok-plugin\0.9.3.1\maven-lombok-plugin-0.9.3.1.jar;E:\maven\resp\org\apache\maven\maven-plugin-api\2.0.9\maven-plugin-api-2.0.9.jar;E:\maven\resp\org\projectlombok\lombok\1.18.16\lombok-1.18.16.jar com.jt.Jt02Application
        
          .   ____          _            __ _ _
         /\\ / ___'_ __ _ _(_)_ __  __ _ \ \ \ \
        ( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \
         \\/  ___)| |_)| | | | | || (_| |  ) ) ) )
          '  |____| .__|_| |_|_| |_\__, | / / / /
         =========|_|==============|___/=/_/_/_/
         :: Spring Boot ::        (v2.3.7.RELEASE)
        
        2021-12-12 17:06:09.701  INFO 1100 --- [           main] com.jt.Jt02Application                   : Starting Jt02Application on DESKTOP-PSB7JAF with PID 1100 (E:\JavaPhase03\2109\jt_02\target\classes started by du542115972 in E:\JavaPhase03\2109)
        2021-12-12 17:06:09.702  INFO 1100 --- [           main] com.jt.Jt02Application                   : No active profile set, falling back to default profiles: default
        2021-12-12 17:06:10.194  INFO 1100 --- [           main] o.s.b.w.embedded.tomcat.TomcatWebServer  : Tomcat initialized with port(s): 8091 (http)
        2021-12-12 17:06:10.199  INFO 1100 --- [           main] o.apache.catalina.core.StandardService   : Starting service [Tomcat]
        2021-12-12 17:06:10.199  INFO 1100 --- [           main] org.apache.catalina.core.StandardEngine  : Starting Servlet engine: [Apache Tomcat/9.0.41]
        2021-12-12 17:06:10.234  INFO 1100 --- [           main] o.a.c.c.C.[Tomcat].[localhost].[/]       : Initializing Spring embedded WebApplicationContext
        2021-12-12 17:06:10.234  INFO 1100 --- [           main] w.s.c.ServletWebServerApplicationContext : Root WebApplicationContext: initialization completed in 507 ms
        2021-12-12 17:06:10.456  INFO 1100 --- [           main] o.s.s.concurrent.ThreadPoolTaskExecutor  : Initializing ExecutorService 'applicationTaskExecutor'
        2021-12-12 17:06:10.564  INFO 1100 --- [           main] o.s.b.w.embedded.tomcat.TomcatWebServer  : Tomcat started on port(s): 8091 (http) with context path ''
        2021-12-12 17:06:10.570  INFO 1100 --- [           main] com.jt.Jt02Application                   : Started Jt02Application in 1.119 seconds (JVM running for 1.502)
        2021-12-12 17:06:17.576  INFO 1100 --- [nio-8091-exec-1] o.a.c.c.C.[Tomcat].[localhost].[/]       : Initializing Spring DispatcherServlet 'dispatcherServlet'
        2021-12-12 17:06:17.576  INFO 1100 --- [nio-8091-exec-1] o.s.web.servlet.DispatcherServlet        : Initializing Servlet 'dispatcherServlet'
        2021-12-12 17:06:17.579  INFO 1100 --- [nio-8091-exec-1] o.s.web.servlet.DispatcherServlet        : Completed initialization in 3 ms
        2021-12-12 17:06:17.608  INFO 1100 --- [nio-8091-exec-2] com.zaxxer.hikari.HikariDataSource       : HikariPool-1 - Starting...
        2021-12-12 17:06:17.645 ERROR 1100 --- [nio-8091-exec-1] o.a.c.c.C.[.[.[/].[dispatcherServlet]    : Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception [Request processing failed; nested exception is org.apache.ibatis.binding.BindingException: Invalid bound statement (not found): com.jt.mapper.UserMapper.findTotal] with root cause
        
        org.apache.ibatis.binding.BindingException: Invalid bound statement (not found): com.jt.mapper.UserMapper.findTotal
        	at org.apache.ibatis.binding.MapperMethod$SqlCommand.<init>(MapperMethod.java:235) ~[mybatis-3.5.7.jar:3.5.7]
        	at org.apache.ibatis.binding.MapperMethod.<init>(MapperMethod.java:53) ~[mybatis-3.5.7.jar:3.5.7]
        	at org.apache.ibatis.binding.MapperProxy.lambda$cachedInvoker$0(MapperProxy.java:108) ~[mybatis-3.5.7.jar:3.5.7]
        	at org.apache.ibatis.binding.MapperProxy$$Lambda$575/496528415.apply(Unknown Source) ~[na:na]
        	at org.apache.ibatis.util.MapUtil$$Lambda$406/399653041.apply(Unknown Source) ~[na:na]
        	at java.util.concurrent.ConcurrentHashMap.computeIfAbsent(Unknown Source) ~[na:1.8.0_45]
        	at org.apache.ibatis.util.MapUtil.computeIfAbsent(MapUtil.java:36) ~[mybatis-3.5.7.jar:3.5.7]
        	at org.apache.ibatis.binding.MapperProxy.cachedInvoker(MapperProxy.java:95) ~[mybatis-3.5.7.jar:3.5.7]
        	at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:86) ~[mybatis-3.5.7.jar:3.5.7]
        	at com.sun.proxy.$Proxy57.findTotal(Unknown Source) ~[na:na]
        	at com.jt.service.UserServiceImpl.findUserList(UserServiceImpl.java:34) ~[classes/:na]
        	at com.jt.controller.UserController.findUserList(UserController.java:30) ~[classes/:na]
        	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_45]
        	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) ~[na:1.8.0_45]
        	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) ~[na:1.8.0_45]
        	at java.lang.reflect.Method.invoke(Unknown Source) ~[na:1.8.0_45]
        	at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:190) ~[spring-web-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        	at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:138) ~[spring-web-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        	at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:105) ~[spring-webmvc-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:878) ~[spring-webmvc-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:792) ~[spring-webmvc-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        	at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87) ~[spring-webmvc-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        	at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1040) ~[spring-webmvc-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        	at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:943) ~[spring-webmvc-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        	at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006) ~[spring-webmvc-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        	at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:898) ~[spring-webmvc-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        	at javax.servlet.http.HttpServlet.service(HttpServlet.java:626) ~[tomcat-embed-core-9.0.41.jar:4.0.FR]
        	at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883) ~[spring-webmvc-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        	at javax.servlet.http.HttpServlet.service(HttpServlet.java:733) ~[tomcat-embed-core-9.0.41.jar:4.0.FR]
        	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) ~[tomcat-embed-core-9.0.41.jar:9.0.41]
        	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-9.0.41.jar:9.0.41]
        	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) ~[tomcat-embed-websocket-9.0.41.jar:9.0.41]
        	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[tomcat-embed-core-9.0.41.jar:9.0.41]
        	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-9.0.41.jar:9.0.41]
        	at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100) ~[spring-web-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) ~[spring-web-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[tomcat-embed-core-9.0.41.jar:9.0.41]
        	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-9.0.41.jar:9.0.41]
        	at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93) ~[spring-web-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) ~[spring-web-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[tomcat-embed-core-9.0.41.jar:9.0.41]
        	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-9.0.41.jar:9.0.41]
        	at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201) ~[spring-web-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) ~[spring-web-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[tomcat-embed-core-9.0.41.jar:9.0.41]
        	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-9.0.41.jar:9.0.41]
        	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202) ~[tomcat-embed-core-9.0.41.jar:9.0.41]
        	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97) [tomcat-embed-core-9.0.41.jar:9.0.41]
        	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:542) [tomcat-embed-core-9.0.41.jar:9.0.41]
        	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:143) [tomcat-embed-core-9.0.41.jar:9.0.41]
        	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) [tomcat-embed-core-9.0.41.jar:9.0.41]
        	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78) [tomcat-embed-core-9.0.41.jar:9.0.41]
        	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) [tomcat-embed-core-9.0.41.jar:9.0.41]
        	at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:374) [tomcat-embed-core-9.0.41.jar:9.0.41]
        	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) [tomcat-embed-core-9.0.41.jar:9.0.41]
        	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:888) [tomcat-embed-core-9.0.41.jar:9.0.41]
        	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1597) [tomcat-embed-core-9.0.41.jar:9.0.41]
        	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) [tomcat-embed-core-9.0.41.jar:9.0.41]
        	at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) [na:1.8.0_45]
        	at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [na:1.8.0_45]
        	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-embed-core-9.0.41.jar:9.0.41]
        	at java.lang.Thread.run(Unknown Source) [na:1.8.0_45]
        
        2021-12-12 17:06:17.733  INFO 1100 --- [nio-8091-exec-2] com.zaxxer.hikari.HikariDataSource       : HikariPool-1 - Start completed.
        2021-12-12 17:06:17.737 DEBUG 1100 --- [nio-8091-exec-2] c.jt.mapper.RightsMapper.getRightsList   : ==>  Preparing: select * from (select * from rights where parent_id=0) p left join (select id c_id, NAME c_name, parent_id c_parent_id, path c_path, LEVEL c_level, created c_created, updated c_updated from rights) c on p.id=c.c_parent_id;
        2021-12-12 17:06:17.750 DEBUG 1100 --- [nio-8091-exec-2] c.jt.mapper.RightsMapper.getRightsList   : ==> Parameters: 
        2021-12-12 17:06:17.765 DEBUG 1100 --- [nio-8091-exec-2] c.jt.mapper.RightsMapper.getRightsList   : <==      Total: 6
        2021-12-12 17:07:18.183 ERROR 1100 --- [nio-8091-exec-3] o.a.c.c.C.[.[.[/].[dispatcherServlet]    : Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception [Request processing failed; nested exception is org.apache.ibatis.binding.BindingException: Invalid bound statement (not found): com.jt.mapper.UserMapper.findTotal] with root cause
        
        org.apache.ibatis.binding.BindingException: Invalid bound statement (not found): com.jt.mapper.UserMapper.findTotal
        	at org.apache.ibatis.binding.MapperMethod$SqlCommand.<init>(MapperMethod.java:235) ~[mybatis-3.5.7.jar:3.5.7]
        	at org.apache.ibatis.binding.MapperMethod.<init>(MapperMethod.java:53) ~[mybatis-3.5.7.jar:3.5.7]
        	at org.apache.ibatis.binding.MapperProxy.lambda$cachedInvoker$0(MapperProxy.java:108) ~[mybatis-3.5.7.jar:3.5.7]
        	at org.apache.ibatis.binding.MapperProxy$$Lambda$575/496528415.apply(Unknown Source) ~[na:na]
        	at org.apache.ibatis.util.MapUtil$$Lambda$406/399653041.apply(Unknown Source) ~[na:na]
        	at java.util.concurrent.ConcurrentHashMap.computeIfAbsent(Unknown Source) ~[na:1.8.0_45]
        	at org.apache.ibatis.util.MapUtil.computeIfAbsent(MapUtil.java:36) ~[mybatis-3.5.7.jar:3.5.7]
        	at org.apache.ibatis.binding.MapperProxy.cachedInvoker(MapperProxy.java:95) ~[mybatis-3.5.7.jar:3.5.7]
        	at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:86) ~[mybatis-3.5.7.jar:3.5.7]
        	at com.sun.proxy.$Proxy57.findTotal(Unknown Source) ~[na:na]
        	at com.jt.service.UserServiceImpl.findUserList(UserServiceImpl.java:34) ~[classes/:na]
        	at com.jt.controller.UserController.findUserList(UserController.java:30) ~[classes/:na]
        	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_45]
        	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) ~[na:1.8.0_45]
        	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) ~[na:1.8.0_45]
        	at java.lang.reflect.Method.invoke(Unknown Source) ~[na:1.8.0_45]
        	at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:190) ~[spring-web-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        	at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:138) ~[spring-web-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        	at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:105) ~[spring-webmvc-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:878) ~[spring-webmvc-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:792) ~[spring-webmvc-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        	at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87) ~[spring-webmvc-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        	at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1040) ~[spring-webmvc-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        	at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:943) ~[spring-webmvc-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        	at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006) ~[spring-webmvc-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        	at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:898) ~[spring-webmvc-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        	at javax.servlet.http.HttpServlet.service(HttpServlet.java:626) ~[tomcat-embed-core-9.0.41.jar:4.0.FR]
        	at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883) ~[spring-webmvc-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        	at javax.servlet.http.HttpServlet.service(HttpServlet.java:733) ~[tomcat-embed-core-9.0.41.jar:4.0.FR]
        	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) ~[tomcat-embed-core-9.0.41.jar:9.0.41]
        	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-9.0.41.jar:9.0.41]
        	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) ~[tomcat-embed-websocket-9.0.41.jar:9.0.41]
        	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[tomcat-embed-core-9.0.41.jar:9.0.41]
        	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-9.0.41.jar:9.0.41]
        	at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100) ~[spring-web-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) ~[spring-web-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[tomcat-embed-core-9.0.41.jar:9.0.41]
        	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-9.0.41.jar:9.0.41]
        	at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93) ~[spring-web-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) ~[spring-web-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[tomcat-embed-core-9.0.41.jar:9.0.41]
        	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-9.0.41.jar:9.0.41]
        	at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201) ~[spring-web-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) ~[spring-web-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[tomcat-embed-core-9.0.41.jar:9.0.41]
        	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-9.0.41.jar:9.0.41]
        	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202) ~[tomcat-embed-core-9.0.41.jar:9.0.41]
        	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97) [tomcat-embed-core-9.0.41.jar:9.0.41]
        	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:542) [tomcat-embed-core-9.0.41.jar:9.0.41]
        	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:143) [tomcat-embed-core-9.0.41.jar:9.0.41]
        	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) [tomcat-embed-core-9.0.41.jar:9.0.41]
        	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78) [tomcat-embed-core-9.0.41.jar:9.0.41]
        	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) [tomcat-embed-core-9.0.41.jar:9.0.41]
        	at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:374) [tomcat-embed-core-9.0.41.jar:9.0.41]
        	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) [tomcat-embed-core-9.0.41.jar:9.0.41]
        	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:888) [tomcat-embed-core-9.0.41.jar:9.0.41]
        	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1597) [tomcat-embed-core-9.0.41.jar:9.0.41]
        	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) [tomcat-embed-core-9.0.41.jar:9.0.41]
        	at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) [na:1.8.0_45]
        	at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [na:1.8.0_45]
        	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-embed-core-9.0.41.jar:9.0.41]
        	at java.lang.Thread.run(Unknown Source) [na:1.8.0_45]
        
        

        1

    2. 出现场景

      1. springboot

    3. 原因及解决方案

      1.     @Select("select count(1) from user")
            long findTotal();

        mapper中未加注解,加上即可

  13. java.sql.SQLSyntaxErrorException: Unknown column 'parent_id' in 'field list'

    1. 现象

      1. 前段无显示,后端报java.sql.SQLSyntaxErrorException: Unknown column 'parent_id' in 'field list'错误

    2. 出现场景

    3. 原因及解决方案

      1. package com.jt.pojo;
        
        import com.baomidou.mybatisplus.annotation.IdType;
        import com.baomidou.mybatisplus.annotation.TableField;
        import com.baomidou.mybatisplus.annotation.TableId;
        import com.baomidou.mybatisplus.annotation.TableName;
        import lombok.Data;
        import lombok.experimental.Accessors;
        
        import java.util.List;
        
        
        @Data
        @Accessors(chain = true)
        @TableName("item_cat")
        public class ItemCat extends BasePojo {
            @TableId(type = IdType.AUTO)
            private Integer id;         //定义主键
        //    @TableField(username)
            private Integer parentId;   //定义父级菜单 开启驼峰规则映射
            private String name;        //分类名称
            private Boolean status;     //分类状态 0 停用 1 正常
            private Integer level;      //商品分类等级  1 2 3
            @TableField(exist = false)
            private List<ItemCat> children;
        }
        

        @Tablename后应填写表名,之前填写错误 ,改正即可

  14. org.springframework.web.multipart.MaxUploadSizeExceededException: Maximum upload size exceeded; nested exception is java.lang.IllegalStateException: org.apache.tomcat.util.http.fileupload.impl.FileSizeLimitExceededException: The field file exceeds its maximum permitted size of 1048576 bytes.
       

    1. 报错

      1.  1

      2. org.springframework.web.multipart.MaxUploadSizeExceededException: Maximum upload size exceeded; nested exception is java.lang.IllegalStateException: org.apache.tomcat.util.http.fileupload.impl.FileSizeLimitExceededException: The field file exceeds its maximum permitted size of 1048576 bytes.
        	at org.springframework.web.multipart.support.StandardMultipartHttpServletRequest.handleParseFailure(StandardMultipartHttpServletRequest.java:122)

        1

    2. 现象

    3. 原因及解决方案

  15. 前端报错

    1. status:500:服务端错误

    2. 404:路径错误

  16. java.lang.IllegalStateException: No instances available for sca-provider

    1. java.lang.IllegalStateException: No instances available for sca-provider
      	at org.springframework.cloud.netflix.ribbon.RibbonLoadBalancerClient.execute(RibbonLoadBalancerClient.java:119) ~[spring-cloud-netflix-ribbon-2.2.6.RELEASE.jar:2.2.6.RELEASE]
      	at org.springframework.cloud.netflix.ribbon.RibbonLoadBalancerClient.execute(RibbonLoadBalancerClient.java:99) ~[spring-cloud-netflix-ribbon-2.2.6.RELEASE.jar:2.2.6.RELEASE]
      	at org.springframework.cloud.client.loadbalancer.LoadBalancerInterceptor.intercept(LoadBalancerInterceptor.java:58) ~[spring-cloud-commons-2.2.6.RELEASE.jar:2.2.6.RELEASE]
      	at org.springframework.http.client.InterceptingClientHttpRequest$InterceptingRequestExecution.execute(InterceptingClientHttpRequest.java:93) ~[spring-web-5.2.8.RELEASE.jar:5.2.8.RELEASE]
      	at org.springframework.http.client.InterceptingClientHttpRequest.executeInternal(InterceptingClientHttpRequest.java:77) ~[spring-web-5.2.8.RELEASE.jar:5.2.8.RELEASE]
      	at org.springframework.http.client.AbstractBufferingClientHttpRequest.executeInternal(AbstractBufferingClientHttpRequest.java:48) ~[spring-web-5.2.8.RELEASE.jar:5.2.8.RELEASE]
      	at org.springframework.http.client.AbstractClientHttpRequest.execute(AbstractClientHttpRequest.java:53) ~[spring-web-5.2.8.RELEASE.jar:5.2.8.RELEASE]
      	at org.springframework.web.client.RestTemplate.doExecute(RestTemplate.java:739) ~[spring-web-5.2.8.RELEASE.jar:5.2.8.RELEASE]
      	at org.springframework.web.client.RestTemplate.execute(RestTemplate.java:674) ~[spring-web-5.2.8.RELEASE.jar:5.2.8.RELEASE]
      	at org.springframework.web.client.RestTemplate.getForObject(RestTemplate.java:315) ~[spring-web-5.2.8.RELEASE.jar:5.2.8.RELEASE]
      	at com.jt.consumer.controller.ConsumerController.doRestEcho03(ConsumerController.java:54) ~[classes/:na]
      	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_45]
      	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) ~[na:1.8.0_45]
      	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) ~[na:1.8.0_45]
      	at java.lang.reflect.Method.invoke(Unknown Source) ~[na:1.8.0_45]
      	at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:190) ~[spring-web-5.2.8.RELEASE.jar:5.2.8.RELEASE]
      	at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:138) ~[spring-web-5.2.8.RELEASE.jar:5.2.8.RELEASE]
      	at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:105) ~[spring-webmvc-5.2.8.RELEASE.jar:5.2.8.RELEASE]
      	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:878) ~[spring-webmvc-5.2.8.RELEASE.jar:5.2.8.RELEASE]
      	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:792) ~[spring-webmvc-5.2.8.RELEASE.jar:5.2.8.RELEASE]
      	at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87) ~[spring-webmvc-5.2.8.RELEASE.jar:5.2.8.RELEASE]
      	at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1040) ~[spring-webmvc-5.2.8.RELEASE.jar:5.2.8.RELEASE]
      	at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:943) ~[spring-webmvc-5.2.8.RELEASE.jar:5.2.8.RELEASE]
      	at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006) ~[spring-webmvc-5.2.8.RELEASE.jar:5.2.8.RELEASE]
      	at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:898) ~[spring-webmvc-5.2.8.RELEASE.jar:5.2.8.RELEASE]
      	at javax.servlet.http.HttpServlet.service(HttpServlet.java:626) ~[tomcat-embed-core-9.0.37.jar:4.0.FR]
      	at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883) ~[spring-webmvc-5.2.8.RELEASE.jar:5.2.8.RELEASE]
      	at javax.servlet.http.HttpServlet.service(HttpServlet.java:733) ~[tomcat-embed-core-9.0.37.jar:4.0.FR]
      	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) ~[tomcat-embed-core-9.0.37.jar:9.0.37]
      	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-9.0.37.jar:9.0.37]
      	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) ~[tomcat-embed-websocket-9.0.37.jar:9.0.37]
      	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[tomcat-embed-core-9.0.37.jar:9.0.37]
      	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-9.0.37.jar:9.0.37]
      	at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100) ~[spring-web-5.2.8.RELEASE.jar:5.2.8.RELEASE]
      	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) ~[spring-web-5.2.8.RELEASE.jar:5.2.8.RELEASE]
      	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[tomcat-embed-core-9.0.37.jar:9.0.37]
      	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-9.0.37.jar:9.0.37]
      	at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93) ~[spring-web-5.2.8.RELEASE.jar:5.2.8.RELEASE]
      	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) ~[spring-web-5.2.8.RELEASE.jar:5.2.8.RELEASE]
      	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[tomcat-embed-core-9.0.37.jar:9.0.37]
      	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-9.0.37.jar:9.0.37]
      	at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201) ~[spring-web-5.2.8.RELEASE.jar:5.2.8.RELEASE]
      	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) ~[spring-web-5.2.8.RELEASE.jar:5.2.8.RELEASE]
      	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[tomcat-embed-core-9.0.37.jar:9.0.37]
      	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-9.0.37.jar:9.0.37]
      	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202) ~[tomcat-embed-core-9.0.37.jar:9.0.37]
      	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) [tomcat-embed-core-9.0.37.jar:9.0.37]
      	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541) [tomcat-embed-core-9.0.37.jar:9.0.37]
      	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) [tomcat-embed-core-9.0.37.jar:9.0.37]
      	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) [tomcat-embed-core-9.0.37.jar:9.0.37]
      	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) [tomcat-embed-core-9.0.37.jar:9.0.37]
      	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) [tomcat-embed-core-9.0.37.jar:9.0.37]
      	at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:373) [tomcat-embed-core-9.0.37.jar:9.0.37]
      	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) [tomcat-embed-core-9.0.37.jar:9.0.37]
      	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:868) [tomcat-embed-core-9.0.37.jar:9.0.37]
      	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1589) [tomcat-embed-core-9.0.37.jar:9.0.37]
      	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) [tomcat-embed-core-9.0.37.jar:9.0.37]
      	at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) [na:1.8.0_45]
      	at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [na:1.8.0_45]
      	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-embed-core-9.0.37.jar:9.0.37]
      	at java.lang.Thread.run(Unknown Source) [na:1.8.0_45]
      
      

      1

    2. 出现场景

    3. 原因及解决方案

      1. 重新启动解决

  17. org.springframework.beans.factory.UnsatisfiedDependencyException

    1. E:\JDK\jdk1.8\bin\java.exe -XX:TieredStopAtLevel=1 -noverify -Dspring.output.ansi.enabled=always -Dcom.sun.management.jmxremote -Dspring.jmx.enabled=true -Dspring.liveBeansView.mbeanDomain -Dspring.application.admin.enabled=true "-javaagent:E:\IDEA\IntelliJ IDEA 2020.1.1\lib\idea_rt.jar=4937:E:\IDEA\IntelliJ IDEA 2020.1.1\bin" -Dfile.encoding=UTF-8 -classpath E:\JDK\jdk1.8\jre\lib\charsets.jar;E:\JDK\jdk1.8\jre\lib\deploy.jar;E:\JDK\jdk1.8\jre\lib\ext\access-bridge-64.jar;E:\JDK\jdk1.8\jre\lib\ext\cldrdata.jar;E:\JDK\jdk1.8\jre\lib\ext\dnsns.jar;E:\JDK\jdk1.8\jre\lib\ext\jaccess.jar;E:\JDK\jdk1.8\jre\lib\ext\jfxrt.jar;E:\JDK\jdk1.8\jre\lib\ext\localedata.jar;E:\JDK\jdk1.8\jre\lib\ext\nashorn.jar;E:\JDK\jdk1.8\jre\lib\ext\sunec.jar;E:\JDK\jdk1.8\jre\lib\ext\sunjce_provider.jar;E:\JDK\jdk1.8\jre\lib\ext\sunmscapi.jar;E:\JDK\jdk1.8\jre\lib\ext\sunpkcs11.jar;E:\JDK\jdk1.8\jre\lib\ext\zipfs.jar;E:\JDK\jdk1.8\jre\lib\javaws.jar;E:\JDK\jdk1.8\jre\lib\jce.jar;E:\JDK\jdk1.8\jre\lib\jfr.jar;E:\JDK\jdk1.8\jre\lib\jfxswt.jar;E:\JDK\jdk1.8\jre\lib\jsse.jar;E:\JDK\jdk1.8\jre\lib\management-agent.jar;E:\JDK\jdk1.8\jre\lib\plugin.jar;E:\JDK\jdk1.8\jre\lib\resources.jar;E:\JDK\jdk1.8\jre\lib\rt.jar;E:\JavaPhase04\GitCGB2109IVProjects\01-sca\sca-consumer\target\classes;C:\Users\-\.m2\repository\org\springframework\boot\spring-boot-starter-web\2.3.2.RELEASE\spring-boot-starter-web-2.3.2.RELEASE.jar;C:\Users\-\.m2\repository\org\springframework\boot\spring-boot-starter\2.3.2.RELEASE\spring-boot-starter-2.3.2.RELEASE.jar;C:\Users\-\.m2\repository\org\springframework\boot\spring-boot\2.3.2.RELEASE\spring-boot-2.3.2.RELEASE.jar;C:\Users\-\.m2\repository\org\springframework\boot\spring-boot-autoconfigure\2.3.2.RELEASE\spring-boot-autoconfigure-2.3.2.RELEASE.jar;C:\Users\-\.m2\repository\org\springframework\boot\spring-boot-starter-logging\2.3.2.RELEASE\spring-boot-starter-logging-2.3.2.RELEASE.jar;C:\Users\-\.m2\repository\ch\qos\logback\logback-classic\1.2.3\logback-classic-1.2.3.jar;C:\Users\-\.m2\repository\ch\qos\logback\logback-core\1.2.3\logback-core-1.2.3.jar;C:\Users\-\.m2\repository\org\apache\logging\log4j\log4j-to-slf4j\2.13.3\log4j-to-slf4j-2.13.3.jar;C:\Users\-\.m2\repository\org\apache\logging\log4j\log4j-api\2.13.3\log4j-api-2.13.3.jar;C:\Users\-\.m2\repository\org\slf4j\jul-to-slf4j\1.7.30\jul-to-slf4j-1.7.30.jar;C:\Users\-\.m2\repository\jakarta\annotation\jakarta.annotation-api\1.3.5\jakarta.annotation-api-1.3.5.jar;C:\Users\-\.m2\repository\org\yaml\snakeyaml\1.26\snakeyaml-1.26.jar;C:\Users\-\.m2\repository\org\springframework\boot\spring-boot-starter-json\2.3.2.RELEASE\spring-boot-starter-json-2.3.2.RELEASE.jar;C:\Users\-\.m2\repository\com\fasterxml\jackson\core\jackson-databind\2.11.1\jackson-databind-2.11.1.jar;C:\Users\-\.m2\repository\com\fasterxml\jackson\core\jackson-annotations\2.11.1\jackson-annotations-2.11.1.jar;C:\Users\-\.m2\repository\com\fasterxml\jackson\datatype\jackson-datatype-jdk8\2.11.1\jackson-datatype-jdk8-2.11.1.jar;C:\Users\-\.m2\repository\com\fasterxml\jackson\datatype\jackson-datatype-jsr310\2.11.1\jackson-datatype-jsr310-2.11.1.jar;C:\Users\-\.m2\repository\com\fasterxml\jackson\module\jackson-module-parameter-names\2.11.1\jackson-module-parameter-names-2.11.1.jar;C:\Users\-\.m2\repository\org\springframework\boot\spring-boot-starter-tomcat\2.3.2.RELEASE\spring-boot-starter-tomcat-2.3.2.RELEASE.jar;C:\Users\-\.m2\repository\org\apache\tomcat\embed\tomcat-embed-core\9.0.37\tomcat-embed-core-9.0.37.jar;C:\Users\-\.m2\repository\org\glassfish\jakarta.el\3.0.3\jakarta.el-3.0.3.jar;C:\Users\-\.m2\repository\org\apache\tomcat\embed\tomcat-embed-websocket\9.0.37\tomcat-embed-websocket-9.0.37.jar;C:\Users\-\.m2\repository\org\springframework\spring-web\5.2.8.RELEASE\spring-web-5.2.8.RELEASE.jar;C:\Users\-\.m2\repository\org\springframework\spring-beans\5.2.8.RELEASE\spring-beans-5.2.8.RELEASE.jar;C:\Users\-\.m2\repository\org\springframework\spring-webmvc\5.2.8.RELEASE\spring-webmvc-5.2.8.RELEASE.jar;C:\Users\-\.m2\repository\org\springframework\spring-aop\5.2.8.RELEASE\spring-aop-5.2.8.RELEASE.jar;C:\Users\-\.m2\repository\org\springframework\spring-context\5.2.8.RELEASE\spring-context-5.2.8.RELEASE.jar;C:\Users\-\.m2\repository\org\springframework\spring-expression\5.2.8.RELEASE\spring-expression-5.2.8.RELEASE.jar;C:\Users\-\.m2\repository\com\alibaba\cloud\spring-cloud-starter-alibaba-nacos-discovery\2.2.6.RELEASE\spring-cloud-starter-alibaba-nacos-discovery-2.2.6.RELEASE.jar;C:\Users\-\.m2\repository\com\alibaba\cloud\spring-cloud-alibaba-commons\2.2.6.RELEASE\spring-cloud-alibaba-commons-2.2.6.RELEASE.jar;C:\Users\-\.m2\repository\com\alibaba\nacos\nacos-client\1.4.2\nacos-client-1.4.2.jar;C:\Users\-\.m2\repository\com\alibaba\nacos\nacos-common\1.4.2\nacos-common-1.4.2.jar;C:\Users\-\.m2\repository\commons-io\commons-io\2.7\commons-io-2.7.jar;C:\Users\-\.m2\repository\org\apache\httpcomponents\httpasyncclient\4.1.4\httpasyncclient-4.1.4.jar;C:\Users\-\.m2\repository\org\apache\httpcomponents\httpcore\4.4.13\httpcore-4.4.13.jar;C:\Users\-\.m2\repository\org\apache\httpcomponents\httpcore-nio\4.4.13\httpcore-nio-4.4.13.jar;C:\Users\-\.m2\repository\com\alibaba\nacos\nacos-api\1.4.2\nacos-api-1.4.2.jar;C:\Users\-\.m2\repository\com\google\guava\guava\29.0-jre\guava-29.0-jre.jar;C:\Users\-\.m2\repository\com\google\guava\failureaccess\1.0.1\failureaccess-1.0.1.jar;C:\Users\-\.m2\repository\com\google\guava\listenablefuture\9999.0-empty-to-avoid-conflict-with-guava\listenablefuture-9999.0-empty-to-avoid-conflict-with-guava.jar;C:\Users\-\.m2\repository\com\google\code\findbugs\jsr305\3.0.2\jsr305-3.0.2.jar;C:\Users\-\.m2\repository\org\checkerframework\checker-qual\2.11.1\checker-qual-2.11.1.jar;C:\Users\-\.m2\repository\com\google\errorprone\error_prone_annotations\2.3.4\error_prone_annotations-2.3.4.jar;C:\Users\-\.m2\repository\com\google\j2objc\j2objc-annotations\1.3\j2objc-annotations-1.3.jar;C:\Users\-\.m2\repository\commons-codec\commons-codec\1.14\commons-codec-1.14.jar;C:\Users\-\.m2\repository\com\fasterxml\jackson\core\jackson-core\2.11.1\jackson-core-2.11.1.jar;C:\Users\-\.m2\repository\io\prometheus\simpleclient\0.5.0\simpleclient-0.5.0.jar;C:\Users\-\.m2\repository\com\alibaba\spring\spring-context-support\1.0.10\spring-context-support-1.0.10.jar;C:\Users\-\.m2\repository\org\springframework\cloud\spring-cloud-commons\2.2.6.RELEASE\spring-cloud-commons-2.2.6.RELEASE.jar;C:\Users\-\.m2\repository\org\springframework\security\spring-security-crypto\5.3.3.RELEASE\spring-security-crypto-5.3.3.RELEASE.jar;C:\Users\-\.m2\repository\org\springframework\cloud\spring-cloud-context\2.2.6.RELEASE\spring-cloud-context-2.2.6.RELEASE.jar;C:\Users\-\.m2\repository\org\springframework\cloud\spring-cloud-starter-netflix-ribbon\2.2.6.RELEASE\spring-cloud-starter-netflix-ribbon-2.2.6.RELEASE.jar;C:\Users\-\.m2\repository\org\springframework\cloud\spring-cloud-netflix-ribbon\2.2.6.RELEASE\spring-cloud-netflix-ribbon-2.2.6.RELEASE.jar;C:\Users\-\.m2\repository\org\springframework\cloud\spring-cloud-netflix-archaius\2.2.6.RELEASE\spring-cloud-netflix-archaius-2.2.6.RELEASE.jar;C:\Users\-\.m2\repository\org\springframework\cloud\spring-cloud-starter-netflix-archaius\2.2.6.RELEASE\spring-cloud-starter-netflix-archaius-2.2.6.RELEASE.jar;C:\Users\-\.m2\repository\commons-configuration\commons-configuration\1.8\commons-configuration-1.8.jar;C:\Users\-\.m2\repository\com\netflix\ribbon\ribbon\2.3.0\ribbon-2.3.0.jar;C:\Users\-\.m2\repository\com\netflix\ribbon\ribbon-transport\2.3.0\ribbon-transport-2.3.0.jar;C:\Users\-\.m2\repository\io\reactivex\rxnetty-contexts\0.4.9\rxnetty-contexts-0.4.9.jar;C:\Users\-\.m2\repository\io\reactivex\rxnetty-servo\0.4.9\rxnetty-servo-0.4.9.jar;C:\Users\-\.m2\repository\javax\inject\javax.inject\1\javax.inject-1.jar;C:\Users\-\.m2\repository\io\reactivex\rxnetty\0.4.9\rxnetty-0.4.9.jar;C:\Users\-\.m2\repository\com\netflix\ribbon\ribbon-core\2.3.0\ribbon-core-2.3.0.jar;C:\Users\-\.m2\repository\commons-lang\commons-lang\2.6\commons-lang-2.6.jar;C:\Users\-\.m2\repository\com\netflix\ribbon\ribbon-httpclient\2.3.0\ribbon-httpclient-2.3.0.jar;C:\Users\-\.m2\repository\commons-collections\commons-collections\3.2.2\commons-collections-3.2.2.jar;C:\Users\-\.m2\repository\org\apache\httpcomponents\httpclient\4.5.12\httpclient-4.5.12.jar;C:\Users\-\.m2\repository\com\sun\jersey\jersey-client\1.19.1\jersey-client-1.19.1.jar;C:\Users\-\.m2\repository\com\sun\jersey\jersey-core\1.19.1\jersey-core-1.19.1.jar;C:\Users\-\.m2\repository\javax\ws\rs\jsr311-api\1.1.1\jsr311-api-1.1.1.jar;C:\Users\-\.m2\repository\com\sun\jersey\contribs\jersey-apache-client4\1.19.1\jersey-apache-client4-1.19.1.jar;C:\Users\-\.m2\repository\com\netflix\servo\servo-core\0.12.21\servo-core-0.12.21.jar;C:\Users\-\.m2\repository\com\netflix\netflix-commons\netflix-commons-util\0.3.0\netflix-commons-util-0.3.0.jar;C:\Users\-\.m2\repository\com\netflix\ribbon\ribbon-loadbalancer\2.3.0\ribbon-loadbalancer-2.3.0.jar;C:\Users\-\.m2\repository\com\netflix\netflix-commons\netflix-statistics\0.1.1\netflix-statistics-0.1.1.jar;C:\Users\-\.m2\repository\io\reactivex\rxjava\1.3.8\rxjava-1.3.8.jar;C:\Users\-\.m2\repository\org\springframework\cloud\spring-cloud-starter-openfeign\2.2.6.RELEASE\spring-cloud-starter-openfeign-2.2.6.RELEASE.jar;C:\Users\-\.m2\repository\org\springframework\cloud\spring-cloud-starter\2.2.6.RELEASE\spring-cloud-starter-2.2.6.RELEASE.jar;C:\Users\-\.m2\repository\org\springframework\security\spring-security-rsa\1.0.9.RELEASE\spring-security-rsa-1.0.9.RELEASE.jar;C:\Users\-\.m2\repository\org\bouncycastle\bcpkix-jdk15on\1.64\bcpkix-jdk15on-1.64.jar;C:\Users\-\.m2\repository\org\bouncycastle\bcprov-jdk15on\1.64\bcprov-jdk15on-1.64.jar;C:\Users\-\.m2\repository\org\springframework\cloud\spring-cloud-openfeign-core\2.2.6.RELEASE\spring-cloud-openfeign-core-2.2.6.RELEASE.jar;C:\Users\-\.m2\repository\org\springframework\boot\spring-boot-starter-aop\2.3.2.RELEASE\spring-boot-starter-aop-2.3.2.RELEASE.jar;C:\Users\-\.m2\repository\org\aspectj\aspectjweaver\1.9.6\aspectjweaver-1.9.6.jar;C:\Users\-\.m2\repository\io\github\openfeign\form\feign-form-spring\3.8.0\feign-form-spring-3.8.0.jar;C:\Users\-\.m2\repository\io\github\openfeign\form\feign-form\3.8.0\feign-form-3.8.0.jar;C:\Users\-\.m2\repository\commons-fileupload\commons-fileupload\1.4\commons-fileupload-1.4.jar;C:\Users\-\.m2\repository\io\github\openfeign\feign-core\10.10.1\feign-core-10.10.1.jar;C:\Users\-\.m2\repository\io\github\openfeign\feign-slf4j\10.10.1\feign-slf4j-10.10.1.jar;C:\Users\-\.m2\repository\org\slf4j\slf4j-api\1.7.30\slf4j-api-1.7.30.jar;C:\Users\-\.m2\repository\io\github\openfeign\feign-hystrix\10.10.1\feign-hystrix-10.10.1.jar;C:\Users\-\.m2\repository\com\netflix\archaius\archaius-core\0.7.6\archaius-core-0.7.6.jar;C:\Users\-\.m2\repository\com\netflix\hystrix\hystrix-core\1.5.18\hystrix-core-1.5.18.jar;C:\Users\-\.m2\repository\org\hdrhistogram\HdrHistogram\2.1.9\HdrHistogram-2.1.9.jar;C:\Users\-\.m2\repository\org\projectlombok\lombok\1.18.12\lombok-1.18.12.jar;C:\Users\-\.m2\repository\org\springframework\spring-core\5.2.8.RELEASE\spring-core-5.2.8.RELEASE.jar;C:\Users\-\.m2\repository\org\springframework\spring-jcl\5.2.8.RELEASE\spring-jcl-5.2.8.RELEASE.jar com.jt.ConsumerApplication
      
        .   ____          _            __ _ _
       /\\ / ___'_ __ _ _(_)_ __  __ _ \ \ \ \
      ( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \
       \\/  ___)| |_)| | | | | || (_| |  ) ) ) )
        '  |____| .__|_| |_|_| |_\__, | / / / /
       =========|_|==============|___/=/_/_/_/
       :: Spring Boot ::        (v2.3.2.RELEASE)
      
      2021-12-22 22:55:35.667  INFO 13992 --- [           main] com.jt.ConsumerApplication               : No active profile set, falling back to default profiles: default
      2021-12-22 22:55:35.943  INFO 13992 --- [           main] o.s.cloud.context.scope.GenericScope     : BeanFactory id=d7950377-33a7-3ad4-9dba-84d3a0dae5f5
      2021-12-22 22:55:35.971  INFO 13992 --- [           main] trationDelegate$BeanPostProcessorChecker : Bean 'com.jt.consumer.service.RemoteProviderService' of type [org.springframework.cloud.openfeign.FeignClientFactoryBean] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
      2021-12-22 22:55:36.089  INFO 13992 --- [           main] o.s.b.w.embedded.tomcat.TomcatWebServer  : Tomcat initialized with port(s): 8090 (http)
      2021-12-22 22:55:36.093  INFO 13992 --- [           main] o.apache.catalina.core.StandardService   : Starting service [Tomcat]
      2021-12-22 22:55:36.093  INFO 13992 --- [           main] org.apache.catalina.core.StandardEngine  : Starting Servlet engine: [Apache Tomcat/9.0.37]
      2021-12-22 22:55:36.150  INFO 13992 --- [           main] o.a.c.c.C.[Tomcat].[localhost].[/]       : Initializing Spring embedded WebApplicationContext
      2021-12-22 22:55:36.150  INFO 13992 --- [           main] w.s.c.ServletWebServerApplicationContext : Root WebApplicationContext: initialization completed in 475 ms
      2021-12-22 22:55:36.261  WARN 13992 --- [           main] ConfigServletWebServerApplicationContext : Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'feignConsumerController': Unsatisfied dependency expressed through field 'remoteProviderService'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'com.jt.consumer.service.RemoteProviderService': FactoryBean threw exception on object creation; nested exception is java.lang.IllegalStateException: No fallbackFactory instance of type class com.cy.service.factory.ProviderFallbackFactory found for feign client remoteProviderService
      2021-12-22 22:55:36.262  INFO 13992 --- [           main] o.apache.catalina.core.StandardService   : Stopping service [Tomcat]
      2021-12-22 22:55:36.269  INFO 13992 --- [           main] ConditionEvaluationReportLoggingListener : 
      
      Error starting ApplicationContext. To display the conditions report re-run your application with 'debug' enabled.
      2021-12-22 22:55:36.276 ERROR 13992 --- [           main] o.s.boot.SpringApplication               : Application run failed
      
      org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'feignConsumerController': Unsatisfied dependency expressed through field 'remoteProviderService'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'com.jt.consumer.service.RemoteProviderService': FactoryBean threw exception on object creation; nested exception is java.lang.IllegalStateException: No fallbackFactory instance of type class com.cy.service.factory.ProviderFallbackFactory found for feign client remoteProviderService
      	at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:643) ~[spring-beans-5.2.8.RELEASE.jar:5.2.8.RELEASE]
      	at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:130) ~[spring-beans-5.2.8.RELEASE.jar:5.2.8.RELEASE]
      	at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessProperties(AutowiredAnnotationBeanPostProcessor.java:399) ~[spring-beans-5.2.8.RELEASE.jar:5.2.8.RELEASE]
      	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1420) ~[spring-beans-5.2.8.RELEASE.jar:5.2.8.RELEASE]
      	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:593) ~[spring-beans-5.2.8.RELEASE.jar:5.2.8.RELEASE]
      	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:516) ~[spring-beans-5.2.8.RELEASE.jar:5.2.8.RELEASE]
      	at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:324) ~[spring-beans-5.2.8.RELEASE.jar:5.2.8.RELEASE]
      	at org.springframework.beans.factory.support.AbstractBeanFactory$$Lambda$163/1473205473.getObject(Unknown Source) ~[na:na]
      	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:226) ~[spring-beans-5.2.8.RELEASE.jar:5.2.8.RELEASE]
      	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:322) ~[spring-beans-5.2.8.RELEASE.jar:5.2.8.RELEASE]
      	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202) ~[spring-beans-5.2.8.RELEASE.jar:5.2.8.RELEASE]
      	at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:897) ~[spring-beans-5.2.8.RELEASE.jar:5.2.8.RELEASE]
      	at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:879) ~[spring-context-5.2.8.RELEASE.jar:5.2.8.RELEASE]
      	at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:551) ~[spring-context-5.2.8.RELEASE.jar:5.2.8.RELEASE]
      	at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:143) ~[spring-boot-2.3.2.RELEASE.jar:2.3.2.RELEASE]
      	at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:758) [spring-boot-2.3.2.RELEASE.jar:2.3.2.RELEASE]
      	at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:750) [spring-boot-2.3.2.RELEASE.jar:2.3.2.RELEASE]
      	at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:397) [spring-boot-2.3.2.RELEASE.jar:2.3.2.RELEASE]
      	at org.springframework.boot.SpringApplication.run(SpringApplication.java:315) [spring-boot-2.3.2.RELEASE.jar:2.3.2.RELEASE]
      	at org.springframework.boot.SpringApplication.run(SpringApplication.java:1237) [spring-boot-2.3.2.RELEASE.jar:2.3.2.RELEASE]
      	at org.springframework.boot.SpringApplication.run(SpringApplication.java:1226) [spring-boot-2.3.2.RELEASE.jar:2.3.2.RELEASE]
      	at com.jt.ConsumerApplication.main(ConsumerApplication.java:16) [classes/:na]
      Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'com.jt.consumer.service.RemoteProviderService': FactoryBean threw exception on object creation; nested exception is java.lang.IllegalStateException: No fallbackFactory instance of type class com.cy.service.factory.ProviderFallbackFactory found for feign client remoteProviderService
      	at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.doGetObjectFromFactoryBean(FactoryBeanRegistrySupport.java:176) ~[spring-beans-5.2.8.RELEASE.jar:5.2.8.RELEASE]
      	at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.getObjectFromFactoryBean(FactoryBeanRegistrySupport.java:101) ~[spring-beans-5.2.8.RELEASE.jar:5.2.8.RELEASE]
      	at org.springframework.beans.factory.support.AbstractBeanFactory.getObjectForBeanInstance(AbstractBeanFactory.java:1827) ~[spring-beans-5.2.8.RELEASE.jar:5.2.8.RELEASE]
      	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.getObjectForBeanInstance(AbstractAutowireCapableBeanFactory.java:1265) ~[spring-beans-5.2.8.RELEASE.jar:5.2.8.RELEASE]
      	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:261) ~[spring-beans-5.2.8.RELEASE.jar:5.2.8.RELEASE]
      	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202) ~[spring-beans-5.2.8.RELEASE.jar:5.2.8.RELEASE]
      	at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:276) ~[spring-beans-5.2.8.RELEASE.jar:5.2.8.RELEASE]
      	at org.springframework.beans.factory.support.DefaultListableBeanFactory.addCandidateEntry(DefaultListableBeanFactory.java:1532) ~[spring-beans-5.2.8.RELEASE.jar:5.2.8.RELEASE]
      	at org.springframework.beans.factory.support.DefaultListableBeanFactory.findAutowireCandidates(DefaultListableBeanFactory.java:1489) ~[spring-beans-5.2.8.RELEASE.jar:5.2.8.RELEASE]
      	at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1270) ~[spring-beans-5.2.8.RELEASE.jar:5.2.8.RELEASE]
      	at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1227) ~[spring-beans-5.2.8.RELEASE.jar:5.2.8.RELEASE]
      	at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:640) ~[spring-beans-5.2.8.RELEASE.jar:5.2.8.RELEASE]
      	... 21 common frames omitted
      Caused by: java.lang.IllegalStateException: No fallbackFactory instance of type class com.cy.service.factory.ProviderFallbackFactory found for feign client remoteProviderService
      	at org.springframework.cloud.openfeign.HystrixTargeter.getFromContext(HystrixTargeter.java:81) ~[spring-cloud-openfeign-core-2.2.6.RELEASE.jar:2.2.6.RELEASE]
      	at org.springframework.cloud.openfeign.HystrixTargeter.targetWithFallbackFactory(HystrixTargeter.java:63) ~[spring-cloud-openfeign-core-2.2.6.RELEASE.jar:2.2.6.RELEASE]
      	at org.springframework.cloud.openfeign.HystrixTargeter.target(HystrixTargeter.java:53) ~[spring-cloud-openfeign-core-2.2.6.RELEASE.jar:2.2.6.RELEASE]
      	at org.springframework.cloud.openfeign.FeignClientFactoryBean.loadBalance(FeignClientFactoryBean.java:318) ~[spring-cloud-openfeign-core-2.2.6.RELEASE.jar:2.2.6.RELEASE]
      	at org.springframework.cloud.openfeign.FeignClientFactoryBean.getTarget(FeignClientFactoryBean.java:347) ~[spring-cloud-openfeign-core-2.2.6.RELEASE.jar:2.2.6.RELEASE]
      	at org.springframework.cloud.openfeign.FeignClientFactoryBean.getObject(FeignClientFactoryBean.java:327) ~[spring-cloud-openfeign-core-2.2.6.RELEASE.jar:2.2.6.RELEASE]
      	at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.doGetObjectFromFactoryBean(FactoryBeanRegistrySupport.java:169) ~[spring-beans-5.2.8.RELEASE.jar:5.2.8.RELEASE]
      	... 32 common frames omitted
      
      
      Process finished with exit code 1
      

      1

    2. 出现场景

    3. 原因及解决方案

      1. 将接口中的fallback去掉即可 

  18. Invalid bound statement (not found)

    "C:\Program Files\Java\jdk1.8.0_301\bin\java.exe" -XX:TieredStopAtLevel=1 -noverify -Dspring.output.ansi.enabled=always -Dcom.sun.management.jmxremote -Dspring.jmx.enabled=true -Dspring.liveBeansView.mbeanDomain -Dspring.application.admin.enabled=true "-javaagent:E:\IDEA\IntelliJ IDEA 2020.1.1\lib\idea_rt.jar=1942:E:\IDEA\IntelliJ IDEA 2020.1.1\bin" -Dfile.encoding=UTF-8 -classpath "C:\Program Files\Java\jdk1.8.0_301\jre\lib\charsets.jar;C:\Program Files\Java\jdk1.8.0_301\jre\lib\deploy.jar;C:\Program Files\Java\jdk1.8.0_301\jre\lib\ext\access-bridge-64.jar;C:\Program Files\Java\jdk1.8.0_301\jre\lib\ext\cldrdata.jar;C:\Program Files\Java\jdk1.8.0_301\jre\lib\ext\dnsns.jar;C:\Program Files\Java\jdk1.8.0_301\jre\lib\ext\jaccess.jar;C:\Program Files\Java\jdk1.8.0_301\jre\lib\ext\jfxrt.jar;C:\Program Files\Java\jdk1.8.0_301\jre\lib\ext\localedata.jar;C:\Program Files\Java\jdk1.8.0_301\jre\lib\ext\nashorn.jar;C:\Program Files\Java\jdk1.8.0_301\jre\lib\ext\sunec.jar;C:\Program Files\Java\jdk1.8.0_301\jre\lib\ext\sunjce_provider.jar;C:\Program Files\Java\jdk1.8.0_301\jre\lib\ext\sunmscapi.jar;C:\Program Files\Java\jdk1.8.0_301\jre\lib\ext\sunpkcs11.jar;C:\Program Files\Java\jdk1.8.0_301\jre\lib\ext\zipfs.jar;C:\Program Files\Java\jdk1.8.0_301\jre\lib\javaws.jar;C:\Program Files\Java\jdk1.8.0_301\jre\lib\jce.jar;C:\Program Files\Java\jdk1.8.0_301\jre\lib\jfr.jar;C:\Program Files\Java\jdk1.8.0_301\jre\lib\jfxswt.jar;C:\Program Files\Java\jdk1.8.0_301\jre\lib\jsse.jar;C:\Program Files\Java\jdk1.8.0_301\jre\lib\management-agent.jar;C:\Program Files\Java\jdk1.8.0_301\jre\lib\plugin.jar;C:\Program Files\Java\jdk1.8.0_301\jre\lib\resources.jar;C:\Program Files\Java\jdk1.8.0_301\jre\lib\rt.jar;E:\Javaworkspace\blogprojectmp\blog-api\target\classes;E:\Javaworkspace\mavenblogmp\org\springframework\boot\spring-boot-starter\2.5.0\spring-boot-starter-2.5.0.jar;E:\Javaworkspace\mavenblogmp\org\springframework\boot\spring-boot\2.5.0\spring-boot-2.5.0.jar;E:\Javaworkspace\mavenblogmp\org\springframework\spring-context\5.3.7\spring-context-5.3.7.jar;E:\Javaworkspace\mavenblogmp\org\springframework\boot\spring-boot-autoconfigure\2.5.0\spring-boot-autoconfigure-2.5.0.jar;E:\Javaworkspace\mavenblogmp\jakarta\annotation\jakarta.annotation-api\1.3.5\jakarta.annotation-api-1.3.5.jar;E:\Javaworkspace\mavenblogmp\org\springframework\spring-core\5.3.7\spring-core-5.3.7.jar;E:\Javaworkspace\mavenblogmp\org\springframework\spring-jcl\5.3.7\spring-jcl-5.3.7.jar;E:\Javaworkspace\mavenblogmp\org\yaml\snakeyaml\1.28\snakeyaml-1.28.jar;E:\Javaworkspace\mavenblogmp\org\springframework\boot\spring-boot-starter-log4j2\2.5.0\spring-boot-starter-log4j2-2.5.0.jar;E:\Javaworkspace\mavenblogmp\org\apache\logging\log4j\log4j-slf4j-impl\2.14.1\log4j-slf4j-impl-2.14.1.jar;E:\Javaworkspace\mavenblogmp\org\slf4j\slf4j-api\1.7.30\slf4j-api-1.7.30.jar;E:\Javaworkspace\mavenblogmp\org\apache\logging\log4j\log4j-api\2.14.1\log4j-api-2.14.1.jar;E:\Javaworkspace\mavenblogmp\org\apache\logging\log4j\log4j-core\2.14.1\log4j-core-2.14.1.jar;E:\Javaworkspace\mavenblogmp\org\apache\logging\log4j\log4j-jul\2.14.1\log4j-jul-2.14.1.jar;E:\Javaworkspace\mavenblogmp\org\slf4j\jul-to-slf4j\1.7.30\jul-to-slf4j-1.7.30.jar;E:\Javaworkspace\mavenblogmp\org\springframework\boot\spring-boot-starter-aop\2.5.0\spring-boot-starter-aop-2.5.0.jar;E:\Javaworkspace\mavenblogmp\org\springframework\spring-aop\5.3.7\spring-aop-5.3.7.jar;E:\Javaworkspace\mavenblogmp\org\springframework\spring-beans\5.3.7\spring-beans-5.3.7.jar;E:\Javaworkspace\mavenblogmp\org\aspectj\aspectjweaver\1.9.6\aspectjweaver-1.9.6.jar;E:\Javaworkspace\mavenblogmp\org\springframework\boot\spring-boot-starter-mail\2.5.0\spring-boot-starter-mail-2.5.0.jar;E:\Javaworkspace\mavenblogmp\org\springframework\spring-context-support\5.3.7\spring-context-support-5.3.7.jar;E:\Javaworkspace\mavenblogmp\com\sun\mail\jakarta.mail\1.6.7\jakarta.mail-1.6.7.jar;E:\Javaworkspace\mavenblogmp\com\sun\activation\jakarta.activation\1.2.2\jakarta.activation-1.2.2.jar;E:\Javaworkspace\mavenblogmp\org\springframework\boot\spring-boot-starter-web\2.5.0\spring-boot-starter-web-2.5.0.jar;E:\Javaworkspace\mavenblogmp\org\springframework\boot\spring-boot-starter-json\2.5.0\spring-boot-starter-json-2.5.0.jar;E:\Javaworkspace\mavenblogmp\com\fasterxml\jackson\datatype\jackson-datatype-jdk8\2.12.3\jackson-datatype-jdk8-2.12.3.jar;E:\Javaworkspace\mavenblogmp\com\fasterxml\jackson\datatype\jackson-datatype-jsr310\2.12.3\jackson-datatype-jsr310-2.12.3.jar;E:\Javaworkspace\mavenblogmp\com\fasterxml\jackson\module\jackson-module-parameter-names\2.12.3\jackson-module-parameter-names-2.12.3.jar;E:\Javaworkspace\mavenblogmp\org\springframework\boot\spring-boot-starter-tomcat\2.5.0\spring-boot-starter-tomcat-2.5.0.jar;E:\Javaworkspace\mavenblogmp\org\apache\tomcat\embed\tomcat-embed-core\9.0.46\tomcat-embed-core-9.0.46.jar;E:\Javaworkspace\mavenblogmp\org\apache\tomcat\embed\tomcat-embed-el\9.0.46\tomcat-embed-el-9.0.46.jar;E:\Javaworkspace\mavenblogmp\org\apache\tomcat\embed\tomcat-embed-websocket\9.0.46\tomcat-embed-websocket-9.0.46.jar;E:\Javaworkspace\mavenblogmp\org\springframework\spring-web\5.3.7\spring-web-5.3.7.jar;E:\Javaworkspace\mavenblogmp\org\springframework\spring-webmvc\5.3.7\spring-webmvc-5.3.7.jar;E:\Javaworkspace\mavenblogmp\org\springframework\spring-expression\5.3.7\spring-expression-5.3.7.jar;E:\Javaworkspace\mavenblogmp\org\springframework\boot\spring-boot-starter-data-redis\2.5.0\spring-boot-starter-data-redis-2.5.0.jar;E:\Javaworkspace\mavenblogmp\org\springframework\data\spring-data-redis\2.5.1\spring-data-redis-2.5.1.jar;E:\Javaworkspace\mavenblogmp\org\springframework\data\spring-data-keyvalue\2.5.1\spring-data-keyvalue-2.5.1.jar;E:\Javaworkspace\mavenblogmp\org\springframework\data\spring-data-commons\2.5.1\spring-data-commons-2.5.1.jar;E:\Javaworkspace\mavenblogmp\org\springframework\spring-tx\5.3.7\spring-tx-5.3.7.jar;E:\Javaworkspace\mavenblogmp\org\springframework\spring-oxm\5.3.7\spring-oxm-5.3.7.jar;E:\Javaworkspace\mavenblogmp\io\lettuce\lettuce-core\6.1.2.RELEASE\lettuce-core-6.1.2.RELEASE.jar;E:\Javaworkspace\mavenblogmp\io\netty\netty-common\4.1.65.Final\netty-common-4.1.65.Final.jar;E:\Javaworkspace\mavenblogmp\io\netty\netty-handler\4.1.65.Final\netty-handler-4.1.65.Final.jar;E:\Javaworkspace\mavenblogmp\io\netty\netty-resolver\4.1.65.Final\netty-resolver-4.1.65.Final.jar;E:\Javaworkspace\mavenblogmp\io\netty\netty-buffer\4.1.65.Final\netty-buffer-4.1.65.Final.jar;E:\Javaworkspace\mavenblogmp\io\netty\netty-codec\4.1.65.Final\netty-codec-4.1.65.Final.jar;E:\Javaworkspace\mavenblogmp\io\netty\netty-transport\4.1.65.Final\netty-transport-4.1.65.Final.jar;E:\Javaworkspace\mavenblogmp\io\projectreactor\reactor-core\3.4.6\reactor-core-3.4.6.jar;E:\Javaworkspace\mavenblogmp\org\reactivestreams\reactive-streams\1.0.3\reactive-streams-1.0.3.jar;E:\Javaworkspace\mavenblogmp\com\alibaba\fastjson\1.2.76\fastjson-1.2.76.jar;E:\Javaworkspace\mavenblogmp\mysql\mysql-connector-java\8.0.25\mysql-connector-java-8.0.25.jar;E:\Javaworkspace\mavenblogmp\org\springframework\boot\spring-boot-configuration-processor\2.5.0\spring-boot-configuration-processor-2.5.0.jar;E:\Javaworkspace\mavenblogmp\org\apache\commons\commons-lang3\3.12.0\commons-lang3-3.12.0.jar;E:\Javaworkspace\mavenblogmp\commons-collections\commons-collections\3.2.2\commons-collections-3.2.2.jar;E:\Javaworkspace\mavenblogmp\commons-codec\commons-codec\1.15\commons-codec-1.15.jar;E:\Javaworkspace\mavenblogmp\com\baomidou\mybatis-plus-boot-starter\3.4.3\mybatis-plus-boot-starter-3.4.3.jar;E:\Javaworkspace\mavenblogmp\com\baomidou\mybatis-plus\3.4.3\mybatis-plus-3.4.3.jar;E:\Javaworkspace\mavenblogmp\com\baomidou\mybatis-plus-extension\3.4.3\mybatis-plus-extension-3.4.3.jar;E:\Javaworkspace\mavenblogmp\com\baomidou\mybatis-plus-core\3.4.3\mybatis-plus-core-3.4.3.jar;E:\Javaworkspace\mavenblogmp\com\baomidou\mybatis-plus-annotation\3.4.3\mybatis-plus-annotation-3.4.3.jar;E:\Javaworkspace\mavenblogmp\com\github\jsqlparser\jsqlparser\4.0\jsqlparser-4.0.jar;E:\Javaworkspace\mavenblogmp\org\mybatis\mybatis\3.5.7\mybatis-3.5.7.jar;E:\Javaworkspace\mavenblogmp\org\mybatis\mybatis-spring\2.0.6\mybatis-spring-2.0.6.jar;E:\Javaworkspace\mavenblogmp\org\springframework\boot\spring-boot-starter-jdbc\2.5.0\spring-boot-starter-jdbc-2.5.0.jar;E:\Javaworkspace\mavenblogmp\com\zaxxer\HikariCP\4.0.3\HikariCP-4.0.3.jar;E:\Javaworkspace\mavenblogmp\org\springframework\spring-jdbc\5.3.7\spring-jdbc-5.3.7.jar;E:\Javaworkspace\mavenblogmp\org\projectlombok\lombok\1.18.20\lombok-1.18.20.jar;E:\Javaworkspace\mavenblogmp\joda-time\joda-time\2.10.10\joda-time-2.10.10.jar;E:\Javaworkspace\mavenblogmp\io\jsonwebtoken\jjwt\0.9.1\jjwt-0.9.1.jar;E:\Javaworkspace\mavenblogmp\com\fasterxml\jackson\core\jackson-databind\2.12.3\jackson-databind-2.12.3.jar;E:\Javaworkspace\mavenblogmp\com\fasterxml\jackson\core\jackson-annotations\2.12.3\jackson-annotations-2.12.3.jar;E:\Javaworkspace\mavenblogmp\com\fasterxml\jackson\core\jackson-core\2.12.3\jackson-core-2.12.3.jar;E:\Javaworkspace\mavenblogmp\com\qiniu\qiniu-java-sdk\7.7.0\qiniu-java-sdk-7.7.0.jar;E:\Javaworkspace\mavenblogmp\com\squareup\okhttp3\okhttp\3.14.9\okhttp-3.14.9.jar;E:\Javaworkspace\mavenblogmp\com\squareup\okio\okio\1.17.2\okio-1.17.2.jar;E:\Javaworkspace\mavenblogmp\com\google\code\gson\gson\2.8.6\gson-2.8.6.jar" cn.dbt.blog.BlogApp
    
      .   ____          _            __ _ _
     /\\ / ___'_ __ _ _(_)_ __  __ _ \ \ \ \
    ( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \
     \\/  ___)| |_)| | | | | || (_| |  ) ) ) )
      '  |____| .__|_| |_|_| |_\__, | / / / /
     =========|_|==============|___/=/_/_/_/
     :: Spring Boot ::                (v2.5.0)
    
    2022-02-05 17:14:33.121  INFO 3152 --- [           main] c.d.b.BlogApp                            : Starting BlogApp using Java 1.8.0_301 on DESKTOP-PSB7JAF with PID 3152 (E:\Javaworkspace\blogprojectmp\blog-api\target\classes started by du542115972 in E:\Javaworkspace\blogprojectmp)
    2022-02-05 17:14:33.125  INFO 3152 --- [           main] c.d.b.BlogApp                            : No active profile set, falling back to default profiles: default
    2022-02-05 17:14:33.463  INFO 3152 --- [           main] .s.d.r.c.RepositoryConfigurationDelegate : Multiple Spring Data modules found, entering strict repository configuration mode!
    2022-02-05 17:14:33.465  INFO 3152 --- [           main] .s.d.r.c.RepositoryConfigurationDelegate : Bootstrapping Spring Data Redis repositories in DEFAULT mode.
    2022-02-05 17:14:33.478  INFO 3152 --- [           main] .s.d.r.c.RepositoryConfigurationDelegate : Finished Spring Data repository scanning in 5 ms. Found 0 Redis repository interfaces.
    2022-02-05 17:14:33.734  INFO 3152 --- [           main] o.s.b.w.e.t.TomcatWebServer              : Tomcat initialized with port(s): 8888 (http)
    2022-02-05 17:14:33.739  INFO 3152 --- [           main] o.a.c.c.StandardService                  : Starting service [Tomcat]
    2022-02-05 17:14:33.739  INFO 3152 --- [           main] o.a.c.c.StandardEngine                   : Starting Servlet engine: [Apache Tomcat/9.0.46]
    2022-02-05 17:14:33.787  INFO 3152 --- [           main] o.a.c.c.C.[.[.[/]                        : Initializing Spring embedded WebApplicationContext
    2022-02-05 17:14:33.787  INFO 3152 --- [           main] w.s.c.ServletWebServerApplicationContext : Root WebApplicationContext: initialization completed in 625 ms
    Logging initialized using 'class org.apache.ibatis.logging.stdout.StdOutImpl' adapter.
    Registered plugin: 'com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor@7a7cc52c'
    Property 'mapperLocations' was not specified.
     _ _   |_  _ _|_. ___ _ |    _ 
    | | |\/|_)(_| | |_\  |_)||_|_\ 
         /               |         
                            3.4.3 
    2022-02-05 17:14:34.564  INFO 3152 --- [           main] o.s.b.w.e.t.TomcatWebServer              : Tomcat started on port(s): 8888 (http) with context path ''
    2022-02-05 17:14:34.569  INFO 3152 --- [           main] c.d.b.BlogApp                            : Started BlogApp in 1.678 seconds (JVM running for 2.322)
    2022-02-05 17:14:34.570  INFO 3152 --- [           main] o.s.b.a.ApplicationAvailabilityBean      : Application availability state LivenessState changed to CORRECT
    2022-02-05 17:14:34.571  INFO 3152 --- [           main] o.s.b.a.ApplicationAvailabilityBean      : Application availability state ReadinessState changed to ACCEPTING_TRAFFIC
    2022-02-05 17:14:39.778  INFO 3152 --- [nio-8888-exec-2] o.a.c.c.C.[.[.[/]                        : Initializing Spring DispatcherServlet 'dispatcherServlet'
    2022-02-05 17:14:39.778  INFO 3152 --- [nio-8888-exec-2] o.s.w.s.DispatcherServlet                : Initializing Servlet 'dispatcherServlet'
    2022-02-05 17:14:39.779  INFO 3152 --- [nio-8888-exec-2] o.s.w.s.DispatcherServlet                : Completed initialization in 1 ms
    Creating a new SqlSession
    SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@2bdc11e7] was not registered for synchronization because synchronization is not active
    2022-02-05 17:14:39.888  INFO 3152 --- [nio-8888-exec-1] c.z.h.HikariDataSource                   : HikariPool-1 - Starting...
    2022-02-05 17:14:39.951  INFO 3152 --- [nio-8888-exec-1] c.z.h.HikariDataSource                   : HikariPool-1 - Start completed.
    JDBC Connection [HikariProxyConnection@83906633 wrapping com.mysql.cj.jdbc.ConnectionImpl@3d6c5bee] will not be managed by Spring
    ==>  Preparing: SELECT COUNT(*) FROM ms_article
    ==> Parameters: 
    <==    Columns: COUNT(*)
    <==        Row: 6
    <==      Total: 1
    ==>  Preparing: SELECT id,title,summary,comment_counts,view_counts,author_id,body_id,category_id,weight,create_date FROM ms_article ORDER BY weight DESC,create_date DESC LIMIT ?
    ==> Parameters: 5(Long)
    <==    Columns: id, title, summary, comment_counts, view_counts, author_id, body_id, category_id, weight, create_date
    <==        Row: 1405916999732707330, SpringBoot入门案例, springboot入门案例, 0, 5, 1, 1405916999854342146, 2, 0, 1624031708047
    <==        Row: 1405909844724051969, 123123, 123, 0, 2, 1, 1405909844828909569, 3, 0, 1624030002164
    <==        Row: 1405564731300831233, 666666666666666, 66666666666, 0, 2, 1, 1405564731351162882, 2, 0, 1623947720727
    <==        Row: 1, springboot介绍以及入门案例, 通过Spring Boot实现的服务,只需要依靠一个Java类,把它打包成jar,并通过`java -jar`命令就可以运行起来。
    
    这一切相较于传统Spring应用来说,已经变得非常的轻便、简单。, 1, 125, 1, 1, 2, 0, 1621947720727
    <==        Row: 9, Vue.js 到底是什么, Vue (读音 /vjuː/,类似于 view) 是一套用于构建用户界面的渐进式框架。, 0, 3, 1, 20, 2, 0, 1613947720727
    <==      Total: 5
    Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@2bdc11e7]
    2022-02-05 17:14:40.011 ERROR 3152 --- [nio-8888-exec-1] o.a.c.c.C.[.[.[.[dispatcherServlet]      : Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception [Request processing failed; nested exception is org.apache.ibatis.binding.BindingException: Invalid bound statement (not found): cn.dbt.blog.dao.mapper.TagMapper.findTagsByArticleId] with root cause
    
    org.apache.ibatis.binding.BindingException: Invalid bound statement (not found): cn.dbt.blog.dao.mapper.TagMapper.findTagsByArticleId
    	at org.apache.ibatis.binding.MapperMethod$SqlCommand.<init>(MapperMethod.java:235) ~[mybatis-3.5.7.jar:3.5.7]
    	at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.<init>(MybatisMapperMethod.java:50) ~[mybatis-plus-core-3.4.3.jar:3.4.3]
    	at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.lambda$cachedInvoker$0(MybatisMapperProxy.java:111) ~[mybatis-plus-core-3.4.3.jar:3.4.3]
    	at java.util.concurrent.ConcurrentHashMap.computeIfAbsent(ConcurrentHashMap.java:1660) ~[?:1.8.0_301]
    	at com.baomidou.mybatisplus.core.toolkit.CollectionUtils.computeIfAbsent(CollectionUtils.java:117) ~[mybatis-plus-core-3.4.3.jar:3.4.3]
    	at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.cachedInvoker(MybatisMapperProxy.java:98) ~[mybatis-plus-core-3.4.3.jar:3.4.3]
    	at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:89) ~[mybatis-plus-core-3.4.3.jar:3.4.3]
    	at com.sun.proxy.$Proxy78.findTagsByArticleId(Unknown Source) ~[?:?]
    	at cn.dbt.blog.service.impl.TagServiceImpl.findTagsByArticleId(TagServiceImpl.java:23) ~[classes/:?]
    	at cn.dbt.blog.service.impl.ArticleServiceImpl.copy(ArticleServiceImpl.java:69) ~[classes/:?]
    	at cn.dbt.blog.service.impl.ArticleServiceImpl.copyList(ArticleServiceImpl.java:54) ~[classes/:?]
    	at cn.dbt.blog.service.impl.ArticleServiceImpl.listArticle(ArticleServiceImpl.java:45) ~[classes/:?]
    	at cn.dbt.blog.controller.ArticleController.listArticle(ArticleController.java:25) ~[classes/:?]
    	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_301]
    	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_301]
    	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_301]
    	at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_301]
    	at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:197) ~[spring-web-5.3.7.jar:5.3.7]
    	at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:141) ~[spring-web-5.3.7.jar:5.3.7]
    	at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:106) ~[spring-webmvc-5.3.7.jar:5.3.7]
    	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:894) ~[spring-webmvc-5.3.7.jar:5.3.7]
    	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:808) ~[spring-webmvc-5.3.7.jar:5.3.7]
    	at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87) ~[spring-webmvc-5.3.7.jar:5.3.7]
    	at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1063) ~[spring-webmvc-5.3.7.jar:5.3.7]
    	at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:963) ~[spring-webmvc-5.3.7.jar:5.3.7]
    	at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006) ~[spring-webmvc-5.3.7.jar:5.3.7]
    	at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:909) ~[spring-webmvc-5.3.7.jar:5.3.7]
    	at javax.servlet.http.HttpServlet.service(HttpServlet.java:652) ~[tomcat-embed-core-9.0.46.jar:4.0.FR]
    	at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883) ~[spring-webmvc-5.3.7.jar:5.3.7]
    	at javax.servlet.http.HttpServlet.service(HttpServlet.java:733) ~[tomcat-embed-core-9.0.46.jar:4.0.FR]
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227) ~[tomcat-embed-core-9.0.46.jar:9.0.46]
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) ~[tomcat-embed-core-9.0.46.jar:9.0.46]
    	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) ~[tomcat-embed-websocket-9.0.46.jar:9.0.46]
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) ~[tomcat-embed-core-9.0.46.jar:9.0.46]
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) ~[tomcat-embed-core-9.0.46.jar:9.0.46]
    	at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100) ~[spring-web-5.3.7.jar:5.3.7]
    	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) ~[spring-web-5.3.7.jar:5.3.7]
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) ~[tomcat-embed-core-9.0.46.jar:9.0.46]
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) ~[tomcat-embed-core-9.0.46.jar:9.0.46]
    	at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93) ~[spring-web-5.3.7.jar:5.3.7]
    	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) ~[spring-web-5.3.7.jar:5.3.7]
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) ~[tomcat-embed-core-9.0.46.jar:9.0.46]
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) ~[tomcat-embed-core-9.0.46.jar:9.0.46]
    	at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201) ~[spring-web-5.3.7.jar:5.3.7]
    	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) ~[spring-web-5.3.7.jar:5.3.7]
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) ~[tomcat-embed-core-9.0.46.jar:9.0.46]
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) ~[tomcat-embed-core-9.0.46.jar:9.0.46]
    	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202) [tomcat-embed-core-9.0.46.jar:9.0.46]
    	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97) [tomcat-embed-core-9.0.46.jar:9.0.46]
    	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:542) [tomcat-embed-core-9.0.46.jar:9.0.46]
    	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:143) [tomcat-embed-core-9.0.46.jar:9.0.46]
    	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) [tomcat-embed-core-9.0.46.jar:9.0.46]
    	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78) [tomcat-embed-core-9.0.46.jar:9.0.46]
    	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:357) [tomcat-embed-core-9.0.46.jar:9.0.46]
    	at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:374) [tomcat-embed-core-9.0.46.jar:9.0.46]
    	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) [tomcat-embed-core-9.0.46.jar:9.0.46]
    	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:893) [tomcat-embed-core-9.0.46.jar:9.0.46]
    	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1707) [tomcat-embed-core-9.0.46.jar:9.0.46]
    	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) [tomcat-embed-core-9.0.46.jar:9.0.46]
    	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_301]
    	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_301]
    	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-embed-core-9.0.46.jar:9.0.46]
    	at java.lang.Thread.run(Thread.java:748) [?:1.8.0_301]
    
    
    1. 出现场景:个人blog标签处理

    2. 原因及解决方案:

      1. 在resources下创建目录时,应使用“/”而不是“.”,否则目录名称会变成“cn.dbt.blog.dao.mapper”

      2. 详见解决org.apache.ibatis.binding.BindingException: Invalid bound statement (not found)问题_大吉的博客-CSDN博客

  • 2
    点赞
  • 3
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值