SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@1570cad0] was not registered for synchronization because synchronization is not active
2023-11-27T19:44:09.347+08:00 INFO 15724 --- [ main] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Starting...
2023-11-27T19:44:09.793+08:00 INFO 15724 --- [ main] com.zaxxer.hikari.pool.HikariPool : HikariPool-1 - Added connection com.mysql.cj.jdbc.ConnectionImpl@54941dfd
2023-11-27T19:44:09.796+08:00 INFO 15724 --- [ main] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Start completed.
JDBC Connection [HikariProxyConnection@1389771646 wrapping com.mysql.cj.jdbc.ConnectionImpl@54941dfd] will not be managed by Spring
==> Preparing: # select * from emp # where name like concat('%', ?,'%') # and gender = ? # and entrydate between ? and ? select * from emp WHERE gender = ? order by update_time desc
Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@1570cad0]
报错分析:
图 empMapper.xml
其中,开启语法检测后,快捷键 ctrl+/,直接注释会采用sql的注释语法,而这是一个xml文件,因此使用sql注释的会报错。
解决办法:取消sql语法检测,使用xml的注释语法
图 取消sql语法检测的注释
运行结果:
图 运行结果
可以看到成功运行查出了数据。