Re: [eclipselink-users] Collection as an argument to IN() statement

[James Sutherland <jamesssss@xxxxxxxxx>]

This should work, at least in the latest EclipseLink 2.0 build.  You may wish
to confirm the EclipseLink version you are using, or try the latest.

What is the JPQL you are using (include code for query, and exception stack
trace).



orid wrote:
> 
> Hi,
> 
>  
> 
> I'm trying to pass a collection as an argument to a named query IN
> statement, and getting an exception:
> 
> "You have attempted to set a value of type class java.util.ArrayList for
> parameter ids with expected type of long from query."
> 
>  
> 
> According to JPA 2.0 spec this should be allowed.
> 
> According to this: https://bugs.eclipse.org/bugs/show_bug.cgi?id=249224 ,
> it
> should be checked in.
> 
>  
> 
> I'm using glassfish v3 latest promoted build which uses eclipselink M7 if
> I
> understand correctly.
> 
>  
> 
> What am I missing?
> 
>  
> 
> Thanks,
> 
> Ori
> 
> 


-----
http://wiki.eclipse.org/User:James.sutherland.oracle.com James Sutherland 
http://www.eclipse.org/eclipselink/
 EclipseLink ,  http://www.oracle.com/technology/products/ias/toplink/
TopLink 
Wiki:  http://wiki.eclipse.org/EclipseLink EclipseLink , 
http://wiki.oracle.com/page/TopLink TopLink 
Forums:  http://forums.oracle.com/forums/forum.jspa?forumID=48 TopLink , 
http://www.nabble.com/EclipseLink-f26430.html EclipseLink 
Book:  http://en.wikibooks.org/wiki/Java_Persistence Java Persistence 
-- 
View this message in context: http://www.nabble.com/Collection-as-an-argument-to-IN%28%29-statement-tp25421286p25474380.html
Sent from the EclipseLink - Users mailing list archive at Nabble.com.