数据权限的多数据源问题

该问题是怎么引起的？

业务表和系统表分为两个数据源，在对数据权限进行控制时，导致需要对系统表进行查询的数据源没切换过去，请问这个怎么解决

重现步骤

报错信息

Error querying database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'kuaidian-tv-cms-data.js_sys_user_data_scope' doesn't exist

The error may exist in com/jeesite/modules/program/dao/ProgramDao.java (best guess)

The error may involve com.jeesite.modules.program.dao.ProgramDao.findList-Inline

The error occurred while setting parameters

Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'kuaidian-tv-cms-data.js_sys_user_data_scope' doesn't exist

; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'kuaidian-tv-cms-data.js_sys_user_data_scope' doesn't exist] with root cause

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'kuaidian-tv-cms-data.js_sys_user_data_scope' doesn't exist

public void addDataScopeFilter(Program program){
	program.getSqlMap().getDataScope().addFilter("dsf", "Company",
			"a.company_code", DataScope.CTRL_PERMI_HAVE);
}

卓源软件 / JeeSite 4.x and 5.x

内容风险标识

该问题是怎么引起的？

重现步骤

报错信息

Error querying database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'kuaidian-tv-cms-data.js_sys_user_data_scope' doesn't exist

The error may exist in com/jeesite/modules/program/dao/ProgramDao.java (best guess)

The error may involve com.jeesite.modules.program.dao.ProgramDao.findList-Inline

The error occurred while setting parameters

Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'kuaidian-tv-cms-data.js_sys_user_data_scope' doesn't exist

评论 (1)

卓源软件 / JeeSite 4.x and 5.x .gitee-modal { width: 500px !important; }

内容风险标识

数据权限的多数据源问题

该问题是怎么引起的？

重现步骤

报错信息

Error querying database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'kuaidian-tv-cms-data.js_sys_user_data_scope' doesn't exist

The error may exist in com/jeesite/modules/program/dao/ProgramDao.java (best guess)

The error may involve com.jeesite.modules.program.dao.ProgramDao.findList-Inline

The error occurred while setting parameters

Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'kuaidian-tv-cms-data.js_sys_user_data_scope' doesn't exist

评论 (1)

搜索帮助

卓源软件 / JeeSite 4.x and 5.x