zztljxxjss 6个月前 评论了 zztljxxjss 创建的话题 › oracle数据库部门用户登录用户管理出错。管理员登录没有问题 |
JDBC Connection [com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl@21fdf474] will not be managed by Spring
==> Preparing: SELECT COUNT(1) FROM (SELECT user_id AS "userId", avatar AS "avatar", account AS "account", salt AS "salt", name AS "name", birthday AS "birthday", sex AS "sex", email AS "email", phone AS "phone", role_id AS "roleId", dept_id AS "deptId", status AS "status", create_time AS "createTime", create_user AS "createUser", update_time AS "updateTime", update_user AS "updateUser", version AS "version" FROM sys_user WHERE status != 'DELETED') temp_data_scope WHERE temp_data_scope.deptId IN (1273876826749042689) java.sql.SQLRecoverableException: 关闭的语句 2020-06-19 17:23:40.007 WARN 17472 --- [p-nio-80-exec-5] c.atomikos.jdbc.AbstractConnectionProxy : Error closing pending statement: java.sql.SQLRecoverableException: 关闭的语句 2020-06-19 17:23:40.012 ERROR 17472 --- [p-nio-80-exec-5] c.s.g.s.c.e.aop.GlobalExceptionHandler : 运行时异常: org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException: Error querying database. Cause: com.baomidou.mybatisplus.core.exceptions.MybatisPlusException: Error: Method queryTotal execution error of sql :SELECT COUNT(1) FROM (SELECT user_id AS "userId", avatar AS "avatar", account AS "account", salt AS "salt", name AS "name", birthday AS "birthday", sex AS "sex", email AS "email", phone AS "phone", role_id AS "roleId", dept_id AS "deptId", status AS "status", create_time AS "createTime", create_user AS "createUser", update_time AS "updateTime", update_user AS "updateUser", version AS "version" FROM sys_user WHERE status != 'DELETED') temp_data_scope WHERE temp_data_scope.deptId IN (1273876826749042689) The error may exist in file [D:\projects\conference\guns-base-support\guns-sys\target\classes\cn\stylefeng\guns\sys\modular\system\mapper\mapping\UserMapper.xml]The error may involve defaultParameterMapThe error occurred while setting parametersCause: com.baomidou.mybatisplus.core.exceptions.MybatisPlusException: Error: Method queryTotal execution error of sql :SELECT COUNT(1) FROM (SELECT user_id AS "userId", avatar AS "avatar", account AS "account", salt AS "salt", name AS "name", birthday AS "birthday", sex AS "sex", email AS "email", phone AS "phone", role_id AS "roleId", dept_id AS "deptId", status AS "status", create_time AS "createTime", create_user AS "createUser", update_time AS "updateTime", update_user AS "updateUser", version AS "version" FROM sys_user WHERE status != 'DELETED') temp_data_scope WHERE temp_data_scope.deptId IN (1273876826749042689)
Caused by: org.apache.ibatis.exceptions.PersistenceException: Error querying database. Cause: com.baomidou.mybatisplus.core.exceptions.MybatisPlusException: Error: Method queryTotal execution error of sql :SELECT COUNT(1) FROM (SELECT user_id AS "userId", avatar AS "avatar", account AS "account", salt AS "salt", name AS "name", birthday AS "birthday", sex AS "sex", email AS "email", phone AS "phone", role_id AS "roleId", dept_id AS "deptId", status AS "status", create_time AS "createTime", create_user AS "createUser", update_time AS "updateTime", update_user AS "updateUser", version AS "version" FROM sys_user WHERE status != 'DELETED') temp_data_scope WHERE temp_data_scope.deptId IN (1273876826749042689) The error may exist in file [D:\projects\conference\guns-base-support\guns-sys\target\classes\cn\stylefeng\guns\sys\modular\system\mapper\mapping\UserMapper.xml]The error may involve defaultParameterMapThe error occurred while setting parametersCause: com.baomidou.mybatisplus.core.exceptions.MybatisPlusException: Error: Method queryTotal execution error of sql :SELECT COUNT(1) FROM (SELECT user_id AS "userId", avatar AS "avatar", account AS "account", salt AS "salt", name AS "name", birthday AS "birthday", sex AS "sex", email AS "email", phone AS "phone", role_id AS "roleId", dept_id AS "deptId", status AS "status", create_time AS "createTime", create_user AS "createUser", update_time AS "updateTime", update_user AS "updateUser", version AS "version" FROM sys_user WHERE status != 'DELETED') temp_data_scope WHERE temp_data_scope.deptId IN (1273876826749042689)
Caused by: com.baomidou.mybatisplus.core.exceptions.MybatisPlusException: Error: Method queryTotal execution error of sql :
Caused by: java.sql.SQLSyntaxErrorException: ORA-00904: "TEMP_DATA_SCOPE"."DEPTID": 标识符无效
2020-06-19 17:23:40.021 WARN 17472 --- [p-nio-80-exec-5] .m.m.a.ExceptionHandlerExceptionResolver : Resolved [org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException: Error querying database. Cause: com.baomidou.mybatisplus.core.exceptions.MybatisPlusException: Error: Method queryTotal execution error of sql :SELECT COUNT(1) FROM (SELECT user_id AS "userId", avatar AS "avatar", account AS "account", salt AS "salt", name AS "name", birthday AS "birthday", sex AS "sex", email AS "email", phone AS "phone", role_id AS "roleId", dept_id AS "deptId", status AS "status", create_time AS "createTime", create_user AS "createUser", update_time AS "updateTime", update_user AS "updateUser", version AS "version" FROM sys_user WHERE status != 'DELETED') temp_data_scope WHERE temp_data_scope.deptId IN (1273876826749042689) The error may exist in file [D:\projects\conference\guns-base-support\guns-sys\target\classes\cn\stylefeng\guns\sys\modular\system\mapper\mapping\UserMapper.xml]The error may involve defaultParameterMapThe error occurred while setting parametersCause: com.baomidou.mybatisplus.core.exceptions.MybatisPlusException: Error: Method queryTotal execution error of sql :SELECT COUNT(1) FROM (SELECT user_id AS "userId", avatar AS "avatar", account AS "account", salt AS "salt", name AS "name", birthday AS "birthday", sex AS "sex", email AS "email", phone AS "phone", role_id AS "roleId", dept_id AS "deptId", status AS "status", create_time AS "createTime", create_user AS "createUser", update_time AS "updateTime", update_user AS "updateUser", version AS "version" FROM sys_user WHERE status != 'DELETED') temp_data_scope WHERE temp_data_scope.deptId IN (1273876826749042689) |
zztljxxjss 6个月前 评论了 zztljxxjss 创建的话题 › oracle数据库部门用户登录用户管理出错。管理员登录没有问题 |
rose中的拦截器没有加“”号,oracle数据库不识别大小写。 |