注册

SQL Error: -5403, SQLState: 22000,参数不兼容

i 2023/12/24 838 1

为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:8.1.3.62
【操作系统】:window
【CPU】: x86
【问题描述】*:
spring data jpa使用json_contains报错,一直无法解决
报错:
Hibernate: select model0_.model_id as model_id1_175_, model0_.create_date as create_d2_175_, model0_.create_user_id as create_u3_175_, model0_.leaf as leaf4_175_, model0_.model_name as model_na5_175_, model0_.navigation as navigati6_175_, model0_.path as path7_175_, model0_.pid as pid8_175_, model0_.status as status9_175_ from zh_model model0_ where model0_.leaf=? and model0_.status<>-1
2023-12-24 17:45:27.908 WARN 19488 --- [nio-8019-exec-6] o.h.engine.jdbc.spi.SqlExceptionHelper : SQL Error: -5403, SQLState: 22000
2023-12-24 17:45:27.908 ERROR 19488 --- [nio-8019-exec-6] o.h.engine.jdbc.spi.SqlExceptionHelper : 第1 行附近出现错误:
参数不兼容

代码:
// 所属模块数组匹配
if (CollectionUtils.isNotEmpty(params.getModelIds())) {
List<Predicate> modelPredicates = new ArrayList<>();
params.getModelIds().forEach(modelId -> {
String value = "11";
Expression<String> literal = cb.literal(value);

                modelPredicates.add(cb.isTrue(cb.function("json_contains", Boolean.class,
                        root.get("modelIds"),
                        literal)));
            });
            predicates.add(cb.or(modelPredicates.toArray(new Predicate[modelPredicates.size()])));
        }
回答 0
暂无回答
扫一扫
联系客服