“SqlSession[xxx] was not registered for synchronization because synchronization is not active”问题成功解决

普通网友 2023-04-10 原文

一、问题详情：

spring boot项目控制台打印如下日志，但程序可正常运行，并未报错：

????D:JavaJDKjdk1.8.0_261injava.exe -XX:TieredStopAtLevel=1 -noverify -Dspring.output.ansi.enabled=always "-javaagent:D:idea安装包IntelliJ IDEA 2021.2.1libidea_rt.jar=53940:D:idea安装包IntelliJ IDEA 2021.2.1in" -Dcom.sun.management.jmxremote -Dspring.jmx.enabled=true -Dspring.liveBeansView.mbeanDomain -Dspring.application.admin.enabled=true -Dfile.encoding=UTF-8 -classpath D:JavaJDKjdk1.8.0_261jrelibcharsets.jar;D:JavaJDKjdk1.8.0_261jrelibdeploy.jar;D:JavaJDKjdk1.8.0_261jrelibextaccess-bridge-64.jar;D:JavaJDKjdk1.8.0_261jrelibextcldrdata.jar;D:JavaJDKjdk1.8.0_261jrelibextdnsns.jar;D:JavaJDKjdk1.8.0_261jrelibextjaccess.jar;D:JavaJDKjdk1.8.0_261jrelibextjfxrt.jar;D:JavaJDKjdk1.8.0_261jrelibextlocaledata.jar;D:JavaJDKjdk1.8.0_261jrelibext
ashorn.jar;D:JavaJDKjdk1.8.0_261jrelibextsunec.jar;D:JavaJDKjdk1.8.0_261jrelibextsunjce_provider.jar;D:JavaJDKjdk1.8.0_261jrelibextsunmscapi.jar;D:JavaJDKjdk1.8.0_261jrelibextsunpkcs11.jar;D:JavaJDKjdk1.8.0_261jrelibextzipfs.jar;D:JavaJDKjdk1.8.0_261jrelibjavaws.jar;D:JavaJDKjdk1.8.0_261jrelibjce.jar;D:JavaJDKjdk1.8.0_261jrelibjfr.jar;D:JavaJDKjdk1.8.0_261jrelibjfxswt.jar;D:JavaJDKjdk1.8.0_261jrelibjsse.jar;D:JavaJDKjdk1.8.0_261jrelibmanagement-agent.jar;D:JavaJDKjdk1.8.0_261jrelibplugin.jar;D:JavaJDKjdk1.8.0_261jrelib
esources.jar;D:JavaJDKjdk1.8.0_261jrelib
t.jar;E:ideajavaee19-2spring_mybatic	argetclasses;C:Users99732726AppDataRoamingJetBrainsIntelliJIdea2021.2javascriptextLibshttp_cdn.staticfile.org_vue_2.4.2_vue.js;D:MAVEN安装包apache-maven-3.8.2maven-repoorgspringframeworkootspring-boot-starter-web.6.4spring-boot-starter-web-2.6.4.jar;D:MAVEN安装包apache-maven-3.8.2maven-repoorgspringframeworkootspring-boot-starter.6.4spring-boot-starter-2.6.4.jar;D:MAVEN安装包apache-maven-3.8.2maven-repoorgspringframeworkootspring-boot.6.4spring-boot-2.6.4.jar;D:MAVEN安装包apache-maven-3.8.2maven-repoorgspringframeworkootspring-boot-autoconfigure.6.4spring-boot-autoconfigure-2.6.4.jar;D:MAVEN安装包apache-maven-3.8.2maven-repoorgspringframeworkootspring-boot-starter-logging.6.4spring-boot-starter-logging-2.6.4.jar;D:MAVEN安装包apache-maven-3.8.2maven-repochqoslogbacklogback-classic.2.10logback-classic-1.2.10.jar;D:MAVEN安装包apache-maven-3.8.2maven-repochqoslogbacklogback-core.2.10logback-core-1.2.10.jar;D:MAVEN安装包apache-maven-3.8.2maven-repoorgapachelogginglog4jlog4j-to-slf4j.17.1log4j-to-slf4j-2.17.1.jar;D:MAVEN安装包apache-maven-3.8.2maven-repoorgapachelogginglog4jlog4j-api.17.1log4j-api-2.17.1.jar;D:MAVEN安装包apache-maven-3.8.2maven-repoorgslf4jjul-to-slf4j.7.36jul-to-slf4j-1.7.36.jar;D:MAVEN安装包apache-maven-3.8.2maven-repojakartaannotationjakarta.annotation-api.3.5jakarta.annotation-api-1.3.5.jar;D:MAVEN安装包apache-maven-3.8.2maven-repoorgspringframeworkspring-core.3.16spring-core-5.3.16.jar;D:MAVEN安装包apache-maven-3.8.2maven-repoorgspringframeworkspring-jcl.3.16spring-jcl-5.3.16.jar;D:MAVEN安装包apache-maven-3.8.2maven-repoorgyamlsnakeyaml.29snakeyaml-1.29.jar;D:MAVEN安装包apache-maven-3.8.2maven-repoorgspringframeworkootspring-boot-starter-json.6.4spring-boot-starter-json-2.6.4.jar;D:MAVEN安装包apache-maven-3.8.2maven-repocomasterxmljacksoncorejackson-databind.13.1jackson-databind-2.13.1.jar;D:MAVEN安装包apache-maven-3.8.2maven-repocomasterxmljacksoncorejackson-annotations.13.1jackson-annotations-2.13.1.jar;D:MAVEN安装包apache-maven-3.8.2maven-repocomasterxmljacksoncorejackson-core.13.1jackson-core-2.13.1.jar;D:MAVEN安装包apache-maven-3.8.2maven-repocomasterxmljacksondatatypejackson-datatype-jdk8.13.1jackson-datatype-jdk8-2.13.1.jar;D:MAVEN安装包apache-maven-3.8.2maven-repocomasterxmljacksondatatypejackson-datatype-jsr310.13.1jackson-datatype-jsr310-2.13.1.jar;D:MAVEN安装包apache-maven-3.8.2maven-repocomasterxmljacksonmodulejackson-module-parameter-names.13.1jackson-module-parameter-names-2.13.1.jar;D:MAVEN安装包apache-maven-3.8.2maven-repoorgspringframeworkootspring-boot-starter-tomcat.6.4spring-boot-starter-tomcat-2.6.4.jar;D:MAVEN安装包apache-maven-3.8.2maven-repoorgapache	omcatembed	omcat-embed-core9.0.58	omcat-embed-core-9.0.58.jar;D:MAVEN安装包apache-maven-3.8.2maven-repoorgapache	omcatembed	omcat-embed-el9.0.58	omcat-embed-el-9.0.58.jar;D:MAVEN安装包apache-maven-3.8.2maven-repoorgapache	omcatembed	omcat-embed-websocket9.0.58	omcat-embed-websocket-9.0.58.jar;D:MAVEN安装包apache-maven-3.8.2maven-repoorgspringframeworkspring-web.3.16spring-web-5.3.16.jar;D:MAVEN安装包apache-maven-3.8.2maven-repoorgspringframeworkspring-beans.3.16spring-beans-5.3.16.jar;D:MAVEN安装包apache-maven-3.8.2maven-repoorgspringframeworkspring-webmvc.3.16spring-webmvc-5.3.16.jar;D:MAVEN安装包apache-maven-3.8.2maven-repoorgspringframeworkspring-aop.3.16spring-aop-5.3.16.jar;D:MAVEN安装包apache-maven-3.8.2maven-repoorgspringframeworkspring-context.3.16spring-context-5.3.16.jar;D:MAVEN安装包apache-maven-3.8.2maven-repoorgspringframeworkspring-expression.3.16spring-expression-5.3.16.jar;D:MAVEN安装包apache-maven-3.8.2maven-repoorgmybatisspringootmybatis-spring-boot-starter.1.4mybatis-spring-boot-starter-2.1.4.jar;D:MAVEN安装包apache-maven-3.8.2maven-repoorgspringframeworkootspring-boot-starter-jdbc.6.4spring-boot-starter-jdbc-2.6.4.jar;D:MAVEN安装包apache-maven-3.8.2maven-repocomzaxxerHikariCP.0.3HikariCP-4.0.3.jar;D:MAVEN安装包apache-maven-3.8.2maven-repoorgslf4jslf4j-api.7.36slf4j-api-1.7.36.jar;D:MAVEN安装包apache-maven-3.8.2maven-repoorgspringframeworkspring-jdbc.3.16spring-jdbc-5.3.16.jar;D:MAVEN安装包apache-maven-3.8.2maven-repoorgspringframeworkspring-tx.3.16spring-tx-5.3.16.jar;D:MAVEN安装包apache-maven-3.8.2maven-repoorgmybatisspringootmybatis-spring-boot-autoconfigure.1.4mybatis-spring-boot-autoconfigure-2.1.4.jar;D:MAVEN安装包apache-maven-3.8.2maven-repoorgmybatismybatis.5.6mybatis-3.5.6.jar;D:MAVEN安装包apache-maven-3.8.2maven-repoorgmybatismybatis-spring.0.6mybatis-spring-2.0.6.jar;D:MAVEN安装包apache-maven-3.8.2maven-repomysqlmysql-connector-java.1.45mysql-connector-java-5.1.45.jar com.SpringMysticApplication

  .   ____          _            __ _ _
 /\ / ___'_ __ _ _(_)_ __  __ _

( ( )___ | '_ | '| | ’ / ` |
/ )| |)| | | | | || (| | ) ) ) )
’ || .__|| ||| |, | / / / /
=========||==============|/=///_/
:: Spring Boot :: (v2.6.4)

2022-03-11 16:35:26.438  INFO 7352 --- [           main] com.SpringMysticApplication              : Starting SpringMysticApplication using Java 1.8.0_261 on 沐曦辰 with PID 7352 (E:ideajavaee19-2spring_mybatic	argetclasses started by 2799732726 in E:ideajavaee19-2)
2022-03-11 16:35:26.439  INFO 7352 --- [           main] com.SpringMysticApplication              : The following 1 profile is active: "default"
2022-03-11 16:35:27.338  INFO 7352 --- [           main] o.s.b.w.embedded.tomcat.TomcatWebServer  : Tomcat initialized with port(s): 8080 (http)
2022-03-11 16:35:27.343  INFO 7352 --- [           main] o.apache.catalina.core.StandardService   : Starting service [Tomcat]
2022-03-11 16:35:27.343  INFO 7352 --- [           main] org.apache.catalina.core.StandardEngine  : Starting Servlet engine: [Apache Tomcat/9.0.58]
2022-03-11 16:35:27.390  INFO 7352 --- [           main] o.a.c.c.C.[Tomcat].[localhost].[/]       : Initializing Spring embedded WebApplicationContext
2022-03-11 16:35:27.391  INFO 7352 --- [           main] w.s.c.ServletWebServerApplicationContext : Root WebApplicationContext: initialization completed in 926 ms
Logging initialized using 'class org.apache.ibatis.logging.stdout.StdOutImpl' adapter.
Parsed mapper file: 'file [E:ideajavaee19-2spring_mybatic	argetclassesmappercustomerMapper.xml]'
Parsed mapper file: 'file [E:ideajavaee19-2spring_mybatic	argetclassesmapperstudentMapper.xml]'
2022-03-11 16:35:27.804  INFO 7352 --- [           main] o.s.b.w.embedded.tomcat.TomcatWebServer  : Tomcat started on port(s): 8080 (http) with context path ''
2022-03-11 16:35:27.810  INFO 7352 --- [           main] com.SpringMysticApplication              : Started SpringMysticApplication in 1.603 seconds (JVM running for 2.103)
2022-03-11 16:35:34.801  INFO 7352 --- [nio-8080-exec-1] o.a.c.c.C.[Tomcat].[localhost].[/]       : Initializing Spring DispatcherServlet 'dispatcherServlet'
2022-03-11 16:35:34.801  INFO 7352 --- [nio-8080-exec-1] o.s.web.servlet.DispatcherServlet        : Initializing Servlet 'dispatcherServlet'
2022-03-11 16:35:34.802  INFO 7352 --- [nio-8080-exec-1] o.s.web.servlet.DispatcherServlet        : Completed initialization in 1 ms
Creating a new SqlSession
SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@37ad2985] was not registered for synchronization because synchronization is not active
2022-03-11 16:35:34.852  INFO 7352 --- [nio-8080-exec-1] com.zaxxer.hikari.HikariDataSource       : HikariPool-1 - Starting...
2022-03-11 16:35:34.970  INFO 7352 --- [nio-8080-exec-1] com.zaxxer.hikari.HikariDataSource       : HikariPool-1 - Start completed.
JDBC Connection [HikariProxyConnection@1020688105 wrapping com.mysql.jdbc.JDBC4Connection@277aa294] will not be managed by Spring
==>  Preparing: select * from mybatic.customer limit 0,?
==> Parameters: 2(Integer)
<==    Columns: id, username, jobs, phone
<==        Row: 2, 小李, 教授, 132131
<==        Row: 3, 李明, 教授, 132131
<==      Total: 2
Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@37ad2985]

上述错误讲述的是：Sqlsession未注册同步，同步注册未激活，JDBC connection不能被Spring所托管