3.7K Star 12.3K Fork 4.7K

卓源软件 / JeeSite 4.3

 / 详情

第二数据源配置oracle报ORA-00942: 表或视图不存在

Backlog
Opened this issue  
2021-06-30 17:58

该问题是怎么引起的?

第一数据源为mysql,配置了第二数据源为oracle数据源

修改第二数据源的数据时报错

报错信息

2021-06-30 17:27:36.795 INFO 16900 [analAsyncPlan-2] [c.j.m.c.deploy.ProcessingUtils ] - 异常信息:org.springframework.jdbc.BadSqlGrammarException:

Error updating database. Cause: java.sql.SQLSyntaxErrorException: ORA-00942: 表或视图不存在

The error may involve com.jeesite.modules.canalServer.dao.JcqnodeExportDao.update-Inline

The error occurred while setting parameters

SQL: UPDATE cfs_data_jcqnode SET company_code = ?, build_code = ?, monitor_code = ?, floor = ?, node_code = ?, category_code = ?, install_add = ?, current_state = ?, current_value = ?, alarm_upper = ?, alarm_lower = ?, range_upper = ?, range_lower = ?, node_info = ?, system = ?, refresh_time = ?, pic_id = ?, equipment = ?, status = ?, create_by = ?, create_date = ?, update_by = ?, update_date = ?, third_id = ?, data_id = ?, component_id = ?, company_name = ?, prov_code = ?, city_code = ?, county_code = ?, town_code = ?, village_code = ?, grid_code = ? WHERE id = ?

Cause: java.sql.SQLSyntaxErrorException: ORA-00942: 表或视图不存在

; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: ORA-00942: 表或视图不存在

Comments (1)

liuwl418 created任务
liuwl418 set related repository to 卓源软件/JeeSite 4.2
liuwl418 changed description
展开全部操作日志

配置的数据源需要再dao里指定数据源名,具体用法看在线文档

Sign in to comment

Status
Assignees
Milestones
Pull Requests
Successfully merging a pull request will close this issue.
Branches
Planed to start   -   Planed to end
-
Top level
Priority
参与者(2)
6732 thinkgem 1578914432
Java
1
https://gitee.com/thinkgem/jeesite4.git
git@gitee.com:thinkgem/jeesite4.git
thinkgem
jeesite4
JeeSite 4.3

Search