Skip to Content
0
Jan 09, 2008 at 03:05 PM

passing an multiple values to EJB QL using WHERE IN

53 Views

Hello,

I have an EJB QL finder similar to below:

select object(o) from Customer as o where o.customerId in (?2) and shipDate = ?1

What I am strugling with is how to pass multiple values to the o.customerId in (?2)...

I have tried passing in a an array of strings and I tried parsing all the values in a string formatted like this... '1234,'5678','9090' and those do not seem to work.

Anyone have any ideas?