JPA使用createNativeQuery的时候用setParameter设置一个参数为list集合报错

Question

List<Object[]> zObjects = entityManager.createNativeQuery("SELECT di.id, di.zcode, di.`name`, di.pid, di.pcode, di.`level` FROM np_base.dic_info di WHERE di.pid in(:?)").setParameter(1, pObjects.stream().filter(item -> !item[3].equals(1)).map(item -> item[0]).collect(Collectors.toList())).getResultList();

结果是报了这个错误:

java.lang.IllegalArgumentException: Could not locate ordinal parameter [1], expecting one of []

想请教一下怎么才能正确的设置这个参数呢?

Answer 1

估计是pObjects.stream().filter(item -> !item[3].equals(1)).map(item -> item[0]).collect(Collectors.toList())没有返回list,或为空？