Yes, this is a known limitation in the current spec that you can't have a dynamic list of options in the IN clause unless you build it yourself for every query execution. Also, you can't have entities in the IN clause (unless you use a particular provider's extension that goes beyond spec requirements).
Regards,
-marina
[Message sent by forum member 'mvatkina' (mvatkina)]
http://forums.java.net/jive/thread.jspa?messageID=240992