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

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

 

Creating a new SqlSession
SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@382c756] was not registered for synchronization because synchronization is not active
JDBC 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: 2
Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@382c756]

 

 

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

 

 

Creating a new SqlSession
Registering 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: 2
Releasing 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]