点击系统的一个字典查询这个字典的详情列表,点击调用接口/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
扫一扫访问 Blade技术社区 移动端