脚本宝典收集整理的这篇文章主要介绍了“SqlSession[xxx] was not registered for synchronization because synchronization is not active”问题成功解决，脚本宝典觉得挺不错的，现在分享给大家，也给大家做个参考。

相关链接：https://blog.csdn.net/QQ_46174906/article/details/123428719

 

Creating a new SQLSessionSqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@382c756] was not registered for synchronization because synchronization is not activeJDBC Connection [HikariProxyConnection@222640470 wrapping ConnectionID:65 ClientConnectionId: f9809a96-8a28-481f-a2b2-c4ba0260279e] will not be managed by SPRing==> Preparing: select i.INCOMING_CODE, i.RESTOCK_DATE, i.PICKER_PERSON, i.CARD_NO, i.REGISTER_PERSON, i.REGIST_DATE From ICOM_INCOMING_INFO i WHERE i.IS_DELETED = '0' AND i.RESTOCK_DATE >= ? AND i.RESTOCK_DATE <=?==> Parameters: 2022-05-06 00:00:00.0(Timestamp), 2022-06-06 23:59:59.0(Timestamp)<== Columns: INCOMING_CODE, RESTOCK_DATE, PICKER_PERSON, CARD_NO, REGISTER_PERSON, REGIST_DATE<== Row: IP20220519001, 2022-06-02 00:00:00.0, H00033|张三, 粤A565666, L2556|李四, 2022-06-02 14:50:16.843<== Row: IP20220519002, 2022-06-02 00:00:00.0, H00035|王五, 粤B565677, L2557|赵六, 2022-06-02 14:50:16.843<== total: 2Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@382c756]

上述错误讲述的是：Sqlsession未注册同步，同步注册未激活，JDBC connection不能被Spring所托管，，，service方法加事务注解@Transactional就可以了。。不过查询本来久不需要。。如下就不报错了，，

Creating a new SqlSessionRegistering transaction synchronization for SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@262c5c53]JDBC Connection [HikariProxyConnection@1641804570 wrapping ConnectionID:1 ClientConnectionId: 4b8519a7-9cd1-4dc1-8c7b-230e7af4a54e] will be managed by Spring==> Preparing: select i.INCOMING_CODE, i.RESTOCK_DATE, i.PICKER_PERSON, i.CARD_NO, i.REGISTER_PERSON, i.REGIST_DATE from ICOM_INCOMING_INFO i WHERE i.IS_DELETED = '0' AND i.RESTOCK_DATE >= ? AND i.RESTOCK_DATE <=?==> Parameters: 2022-05-19 00:00:00.0(Timestamp), 2022-06-22 23:59:59.0(Timestamp)<== Columns: INCOMING_CODE, RESTOCK_DATE, PICKER_PERSON, CARD_NO, REGISTER_PERSON, REGIST_DATE<== Row: IP20220519001, 2022-06-02 00:00:00.0, H00033|张三, 粤A565666, L2556|李四, 2022-06-02 14:50:16.843<== Row: IP20220519002, 2022-06-02 00:00:00.0, H00035|王五, 粤B565677, L2557|赵六, 2022-06-02 14:50:16.843<== Total: 2Releasing transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@262c5c53]Transaction synchronization commITting SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@262c5c53]Transaction synchronization deregistering SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@262c5c53]Transaction synchronization closing SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@262c5c53]

脚本宝典总结

以上是脚本宝典为你收集整理的“SqlSession[xxx] was not registered for synchronization because synchronization is not active”问题成功解决全部内容，希望文章能够帮你解决“SqlSession[xxx] was not registered for synchronization because synchronization is not active”问题成功解决所遇到的问题。

如果觉得脚本宝典网站内容还不错，欢迎将脚本宝典推荐好友。

本图文内容来源于网友网络收集整理提供，作为学习参考使用，版权属于原作者。
如您有任何意见或建议可联系处理。小编QQ：384754419，请注明来意。