关注JEECG发展历程 关注最新动态和版本, 记录JEECG成长点滴 更新日志 - 技术支持 - 招聘英才

JEECG最新版本下载 JEECG智能开发平台 - 显著提高开发效率 常见问题 - 入门视频 - 参与开源团队

商务QQ: 69893005、3102411850 商务热线(5*8小时): 010-64808099 官方邮箱: jeecgos@163.com

查看: 3388|回复: 0

同步数据库到错误的数据库,并且不能在线测试

[复制链接]
发表于 2022-9-1 16:23:10 | 显示全部楼层 |阅读模式
项目中用到了mysql和Oracle数据库,在online开发中,数据库配的是oracle,能够从Oracle导入数据库,但是修改之后,要同步数据库,居然给同步到mysql去了。
同时,也在线测试不了,报了这个错误
[color=rgba(0, 0, 0, 0.65)]操作失败, ### Error querying database. Cause: java.sql.SQLSyntaxErrorException: Table 'lhbank.onl_auth_page' doesn't exist ### The error may exist in URL [jar:file:/C:/Users/Mr.o0x0o/.m2/repository/org/jeecgframework/boot/hibernate-re/2.4.6-beta1/hibernate-re-2.4.6-beta1.jar!/org/jeecg/modules/online/auth/mapper/xml/OnlAuthPageMapper.xml] ### The error may involve org.jeecg.modules.online.auth.mapper.OnlAuthPageMapper.queryRoleNoAuthCode-Inline ### The error occurred while setting parameters ### SQL: SELECT t.code FROM onl_auth_page t WHERE t.status = 1 AND t.page = ? AND t.control = ? AND t.cgform_id = ? AND NOT EXISTS (SELECT * FROM onl_auth_relation a JOIN sys_role b ON b.id = a.role_id JOIN sys_user_role c ON c.role_id = b.id WHERE c.user_id = ? AND a.auth_id = t.id AND a.auth_mode = 'role' AND a.type IN (1, 2)) AND NOT EXISTS (SELECT * FROM onl_auth_relation e JOIN sys_depart f ON f.id = e.role_id JOIN sys_user_depart g ON g.dep_id = f.id WHERE g.user_id = ? AND e.auth_id = t.id AND e.auth_mode = 'depart' AND e.type IN (1, 2)) AND NOT EXISTS (SELECT * FROM onl_auth_relation e JOIN sys_user u ON u.id = e.role_id WHERE u.id = ? AND e.auth_id = t.id AND e.auth_mode = 'user' AND e.type IN (1, 2)) ### Cause: java.sql.SQLSyntaxErrorException: Table 'lhbank.onl_auth_page' doesn't exist ; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: Table 'lhbank.onl_auth_page' doesn't exist

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

快速回复 返回顶部 返回列表