queryText.append(
"( " +
" select count(skill.id) " +
" from emp.skills skill " +
" where skill.id in (:skillList) " +
") = :skillListSize and " );
...

query = session.createQuery(queryText.toString());

...

query.setInteger("skillListSize", skillIds.length);
query.setParameterList("skillList", skillIds);

And this fails: Named parameter does not appear in Query: skillListSize

"... and ( select count(skill.id) from emp.skills skill where skill.id in (:skillList0_) ) = :skillList0_Size and ..."

Where these 0_ come from? If I rename skillListSize to just listSize, everything works fine

hehe uggghhh :(

let me at that parser!

just try using :size instead of :skillListSize

Yes, as I already wrote, if I use ":listSize" instead of ":skillListSize" everything works. But why this happens?