I know that there have already been a lot of questions regarding this topic. I would like to replace a named parameter with a list of composite ids, resulting in something like



So I used a single parameter and setParameterList on the query



This results in the following replacement (when called with an array of three elements):



But nevertheless the query fails ("invalid relational operator").

After dozens of trys I do not know how to proceed. Is there any way to get composite identifiers working? And as far as I can see, there is no other way to yield the same result, or do I miss something?

Help is really appreciated.
Thanks in advance, Tilman

From MyObject obj Where obj.myCompPK in ( ? )

Will this work for you?

This results in the same error message.

Besides, I partially use native SQL named queries, so referencing the composite key as a whole is not possible.

Tilman