SqlSession was not registered for synchronization because synchronization is not JDBC Connection
时间: 2023-11-08 12:03:02 浏览: 49
这是一个来自 Spring 框架的警告信息,提示当前的事务管理器未注册一个用于 JDBC 连接的 SqlSession。可能会影响到事务的正确性。
这个问题通常发生在使用 MyBatis 持久层框架时,需要在 Spring 配置文件中添加如下代码:
```xml
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
<property name="dataSource" ref="dataSource" />
</bean>
<bean id="sqlSession" class="org.mybatis.spring.SqlSessionTemplate">
<constructor-arg ref="sqlSessionFactory" />
</bean>
```
相关问题
was not registered for synchronization because synchronization is not active JDBC Connection
这段引用中的句子是在描述一个错误信息,即"SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@19e35973] was not registered for synchronization because synchronization is not active JDBC Connection [com.mchange.v2.c3p0.impl.NewProxyConnection@7b51e83e] will not be managed by Spring"。这个错误信息的意思是SqlSession没有被注册为同步的,因为同步未激活,所以JDBC Connection也不能被Spring所托管。这可能是因为在代码中未正确配置或激活同步机制导致的。<span class="em">1</span><span class="em">2</span><span class="em">3</span>
#### 引用[.reference_title]
- *1* *3* [“SqlSession[xxx] was not registered for synchronization because synchronization is not active”问题...](https://blog.csdn.net/qq_46174906/article/details/123428719)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_1"}}] [.reference_item style="max-width: 50%"]
- *2* [was not registered for synchronization because synchronization is not active JDBC Connection [com.mc](https://blog.csdn.net/qq_20867981/article/details/79713538)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_1"}}] [.reference_item style="max-width: 50%"]
[ .reference_list ]
sqlsession was not registered
引用\[1\]:在做ssm整合项目中出现了这样的问题 出现了这样的错误信息 SqlSession \[org.apache.ibatis.session.defaults.DefaultSqlSession@ec18b38\] was not registered for synchronization because synchronization is not active JDBC Connection \[com.mysql.jdbc.JDBC4Connection@749d2bf5\] will not be managed by Spring 。
引用\[3\]:在搞SpringBoot项目的时候,把Mybatis打印日志的配置打开后,发现每条Sql打印的时候都会在前面打印如下的信息,强迫症受不了,得查查为什么; Creating a new SqlSession SqlSession \[org.apache.ibatis.session.defaults.DefaultSqlSession@521978e4\] was not registered for synchronization because synchronization is not active JDBC Connection \[com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl@5bb2b956\] will not be managed by Spring ==> Preparing: select * from xxx where xxx = ? and xxx = ? ==> Parameters: opHQA5gq2qfn1DRl069YOLv1Wv0Q(String), 0(Integer) <== Columns: xxx, xxx, xxx, xxx <== Row: xxx, xxx, xxx, xxx <== Total: 1 Closing non transactional SqlSession \[org.apache.ibatis.session.defaults.DefaultSqlSession@521978e4\] 。
问题:sqlsession was not registered for synchronization是什么意思?
回答: 当出现"sqlsession was not registered for synchronization"的错误信息时,意味着在当前的上下文中,没有为SqlSession注册事务同步。这通常是因为没有启用事务管理或者事务同步未激活所导致的。在这种情况下,JDBC连接也不会被Spring管理。\[1\]这个问题通常出现在整合Spring和MyBatis的项目中,可能是由于配置错误或者缺少必要的事务管理器所引起的。如果你想要解决这个问题,你可以检查你的项目配置,确保正确配置了事务管理器,并且在需要的地方启用了事务。\[1\]\[3\]
#### 引用[.reference_title]
- *1* [SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@ec18b38] was not registered for syn](https://blog.csdn.net/weixin_45765073/article/details/127797364)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v91^control_2,239^v3^insert_chatgpt"}} ] [.reference_item]
- *2* *3* [SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@xxx] was not registered for synchro](https://blog.csdn.net/csdn_avatar_2019/article/details/126128441)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v91^control_2,239^v3^insert_chatgpt"}} ] [.reference_item]
[ .reference_list ]