代码生成，增加按钮权限后，报错

awliern · 发表于 2016-7-21 10:56:24

AuthInterceptor.java中
158行：for(String operationIds:hasOperList){
报错，类型转换错误，
数据库中t_s_role_function表中 operation字段为nclob，转string报错

awliern · 发表于 2016-7-21 10:57:28

使用oracle数据库，版本3.6.5

awliern · 发表于 2016-7-21 11:03:40

修改方法：改为：String hasOperSql="SELECT to_char(operation) as operation FROM t_s_role_function fun, t_s_role_user role WHERE " +
"fun.functionid='"+functionId+"' AND fun.operation is not null AND fun.roleid=role.roleid AND role.userid='"+client.getUser().getId()+"' ";

admin · 发表于 2016-7-21 13:50:52

还有个方案，把oracle数据库的字段类型改了