数据源切换异常导致数据源切换失败

最新推荐文章于 2025-03-01 23:01:23 发布

陈勇士

最新推荐文章于 2025-03-01 23:01:23 发布

阅读量4k

点赞数

分类专栏： jdbc

本文链接：https://blog.youkuaiyun.com/chenyongtu110/article/details/54312085

版权

jdbc 专栏收录该内容

1 篇文章

订阅专栏

本文记录了一次使用MyBatis进行数据库查询时遇到的ORA-00942错误（表或视图不存在），展示了查询过程及参数。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

2017-01-10 10:18:07 [ pool-1-thread-1:36867 ] - [ DEBUG ] Creating a new SqlSession
2017-01-10 10:18:07 [ pool-1-thread-1:36867 ] - [ DEBUG ] SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@42e4ed75] was not registered for synchronization because synchronization is not active
2017-01-10 10:18:07 [ pool-1-thread-1:36868 ] - [ DEBUG ] Fetching JDBC Connection from DataSource
2017-01-10 10:18:07 [ pool-1-thread-1:36868 ] - [ DEBUG ] JDBC Connection [com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl@3e70fc74] will not be managed by Spring
2017-01-10 10:18:07 [ pool-1-thread-1:36868 ] - [ DEBUG ] ==>  Preparing: select job_id, job_name, start_time, end_time, job_status from SYNC_JOB where start_time = (select max (start_time) from sync_job where rownum = 1 and job_name = ? ) and job_name = ? 
2017-01-10 10:18:07 [ pool-1-thread-1:36868 ] - [ DEBUG ] ==> Parameters: slaveEventPersonForInsert(String), slaveEventPersonForInsert(String)
2017-01-10 10:18:07 [ pool-1-thread-1:36875 ] - [ DEBUG ] Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@42e4ed75]
2017-01-10 10:18:07 [ pool-1-thread-1:36875 ] - [ DEBUG ] Returning JDBC Connection to DataSource
2017-01-10 10:18:07 [ pool-1-thread-1:36875 ] - [ DEBUG ] Looking up default SQLErrorCodes for DataSource [com.jt.report.util.db.DynamicDataSource@1fab2949]
2017-01-10 10:18:07 [ pool-1-thread-1:36875 ] - [ DEBUG ] SQLErrorCodes found in cache for DataSource [com.jt.report.util.db.DynamicDataSource@1fab2949]
2017-01-10 10:18:07 [ pool-1-thread-1:36875 ] - [ DEBUG ] Translating SQLException with SQL state '42000', error code '942', message [ORA-00942: 表或视图不存在