开发者社区 > 大数据与机器学习 > 实时数仓 Hologres > 正文

数仓里面出现Creating a new SqlSession SqlSession [org.ap

数仓里面出现Creating a new SqlSession SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@581034b7] was not registered for synchronization because synchronization is not active JDBC Connection [ProxyConnection[PooledConnection[org.postgresql.jdbc.PgConnection@3eecce5d]]] will not be managed by Spring ==> Preparing: select updateTime, seat, price, tax, currency, cabin from price_fligth_detail_flow_w6 where flightNum = ? and dep_city = ? and arr_city = ? and dep_date = ? and updateTime > ? and updateTime < ? order by updateTime ==> Parameters: W94002(String), LON(String), BEG(String), 2022-12-18(String), 2022-10-23 00:00:00.0(Timestamp), 2022-10-25 23:59:59.999(Timestamp) <== Columns: updatetime, seat, price, tax, currency, cabin <== Row: 2022-10-25 01:37:06.27+08, 3, 175.49, 7.50, GBP, GF <== Row: 2022-10-25 01:37:11.754+08, 9, 192.49, 7.50, GBP, F <== Row: 2022-10-25 06:11:10.536+08, 3, 175.49, 7.50, GBP, GF <== Row: 2022-10-25 07:32:05.744+08, 3, 175.49, 7.50, GBP, GF <== Row: 2022-10-25 07:32:07.873+08, 3, 175.49, 7.50, GBP, GF <== Row: 2022-10-25 07:32:09.348+08, 3, 175.49, 7.50, GBP, GF <== Row: 2022-10-25 07:32:11.855+08, 3, 175.49, 7.50, GBP, GF <== Row: 2022-10-25 07:32:53.937+08, 9, 192.49, 7.50, GBP, F <== Row: 2022-10-25 10:34:32.514+08, 3, 175.49, 7.50, GBP, GF <== Row: 2022-10-25 13:06:18.073+08, 3, 175.49, 7.50, GBP, GF <== Row: 2022-10-25 13:06:22.847+08, 9, 192.49, 7.50, GBP, F <== Total: 11 Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@581034b7]这个是mybatis的执行结果和数仓里面执行sql的结果不一样

展开
收起
雪哥哥 2022-10-29 23:03:39 1068 0
1 条回答
写回答
取消 提交回答
  • 看着是什么jdbc连接有点问题。这个应该是应用端的问题。Creating a new SqlSession SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@581034b7] was not registered for synchronization because synchronization is not active JDBC Connection MySQL到Hologres可以看下这个文档 https://help.aliyun.com/document_detail/290024.html(此答案整理自实时数仓Hologres交流群)

    2022-10-30 11:40:04
    赞同 展开评论 打赏

本技术圈将为大家分析有关阿里云产品Hologres的最新产品动态、技术解读等,也欢迎大家加入钉钉群--实时数仓Hologres交流群32314975

相关电子书

更多
低代码开发师(初级)实战教程 立即下载
冬季实战营第三期:MySQL数据库进阶实战 立即下载
阿里巴巴DevOps 最佳实践手册 立即下载