游离之蝶 发表于 2022-9-1 16:23:10

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

项目中用到了mysql和Oracle数据库,在online开发中,数据库配的是oracle,能够从Oracle导入数据库,但是修改之后,要同步数据库,居然给同步到mysql去了。
同时,也在线测试不了,报了这个错误
操作失败, ### Error querying database. Cause: java.sql.SQLSyntaxErrorException: Table 'lhbank.onl_auth_page' doesn't exist ### The error may exist in URL ### 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
页: [1]
查看完整版本: 同步数据库到错误的数据库,并且不能在线测试