Criteria API generating wrong query

shay1680 · **Joined:** Wed Dec 16, 2009 9:55 am **Posts:** 6

hi
a question about criteria api

the following code :

Code:

Path<Long> id = root.get(Battery_.Id);
return builder.in(id).in((Object[]) ids).not();

generates the following query

Code:

select generatedAlias0 from Battery as generatedAlias0 where generatedAlias0.Id in () not in (5183, 6036, 2270)

which is not formatted properly
am i building the predicate incorrectly ?

Thanks,
Shay

shay1680 · **Joined:** Wed Dec 16, 2009 9:55 am **Posts:** 6

sanne.grinovero · **Posted:** Fri Aug 12, 2011 2:05 pm

seems a bug. which version? please check the latest version, and if it's still not working please create an issue on JIRA attaching a test case.

shay1680 · **Joined:** Wed Dec 16, 2009 9:55 am **Posts:** 6

Thanks Sanne,

an issue has been created at https://hibernate.onjira.com/browse/HHH-6571

Thanks,
Shay