With JPA 2.0, you can do that. See section 4.6.9 of spec for more details.
On 3/4/2010 2:37 PM, Farrukh Najmi wrote:
> Hi Guys,
>
> I am writing a subscription selector query that needs to match any
> number of objects as specified by a collection of object ids.
> Conceptually the query looks like:
>
> SELECT DISTINCT Object(p) FROM com.acme.Foo foo WHERE foo.id IN ( id1,
> id2, id3, .... )
>
> The problem is that the EJBQL grammar:
>
> http://java.sun.com/j2ee/tutorial/1_3-fcs/doc/EJBQL5.html
>
> does not seem to allow for a collection of strings as a positional
> parameter within an IN statement.
>
> What would have worked but is not supported by the grammar is:
>
> SELECT DISTINCT Object(p) FROM com.acme.Foo foo WHERE foo.id IN (
> :idList )
>
> Where idList could be of type List<String> supplied as a named
> parameter when invoking the query.
>
> Is there another way to solve my problem that is scalable and performs
> well too? Note that my idList could get quite large.
>
> Thanks for your help.
>