项目中用到了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
|