字典问题

Blade 未结 1 739

点击系统的一个字典查询这个字典的详情列表,点击调用接口/ems-system/dict/child-list接口的时候为啥会查询blade_scope_data这个表?这个我看此接口代码里面也没找到查询这个表的方法入口呢,因为我改造新系统,所以我就把这个表给删了。

报错如下:

Caused by: org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [select resource_code, scope_column, scope_field, scope_type, scope_value from blade_scope_data where scope_class = ? and id in (select scope_id from blade_role_scope where scope_category = 1 and role_id in (?))]; nested exception is java.sql.SQLSyntaxErrorException: Table 'blade_scope_data' doesn't exist

at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:239)

at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)

at org.springframework.jdbc.core.JdbcTemplate.translateException(JdbcTemplate.java:1443)

at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:633)

at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:669)

at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:700)

at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:712)

at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:763)

at com.dmf.core.datascope.handler.EmsScopeModelHandler.getDataScopeByMapper(EmsScopeModelHandler.java:51)

at com.dmf.core.datascope.handler.EmsDataScopeHandler.sqlCondition(EmsDataScopeHandler.java:34)

at com.dmf.core.datascope.interceptor.DataScopeInterceptor.intercept(DataScopeInterceptor.java:90)

at com.dmf.core.mp.plugins.QueryInterceptorExecutor.exec(QueryInterceptorExecutor.java:31)

at com.dmf.core.mp.plugins.EmsPaginationInterceptor.willDoQuery(EmsPaginationInterceptor.java:29)

at com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor.intercept(MybatisPlusInterceptor.java:75)

at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:61)

at com.sun.proxy.$Proxy244.query(Unknown Source)

at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:147)

... 108 common frames omitted


1条回答
  • 2021-05-11 21:34

    mybatis-plus拦截器对数据调用的时候进行了判断操作

    也可以用 blade.data-scope.enabled=false 来关闭

    image.png

    0 讨论(0)
提交回复