Re: [eclipselink-users] jpql named parameter list as input does not work

[James Sutherland <jamesssss@xxxxxxxxx>]

This was not supported in JPA 1.0/EclipseLink 1.1, but is supported in JPA
2.0/EclipseLink 2.0/1.2.

What version are you using?



Thomas Rost wrote:
> 
> We try to pass named parameter as a list in a jpql query. But we get the
> following error:
> 
> {SELECT returnValue FROM Need returnValue WHERE  returnValue.type  = '001'
> and  (  returnValue.type  = :type or  returnValue.BUID  IN (:BUID)  ) }
> 
> {SELECT returnValue FROM Need returnValue WHERE returnValue.type  = '001'
> and  (  returnValue.type  = :type or  returnValue.BUID  IN (:BUID)  ) }
> 
>  INFO Caused by: java.lang.IllegalArgumentException: You have attempted to
> set a value of type class java.util.ArrayList for parameter BUID with
> expected type of class java.lang.String from query string 
> 
> SELECT returnValue FROM Need returnValue WHERE  returnValue.type  = '001'
> and  (  returnValue.type  = :type or  returnValue.BUID  IN (:BUID)  ) .
> 
>  INFO   at
> org.eclipse.persistence.internal.jpa.EJBQueryImpl.setParameterInternal(EJBQueryImpl.java:975)
>  INFO   at
> org.eclipse.persistence.internal.jpa.EJBQueryImpl.setParameter(EJBQueryImpl.java:862)
>  ...
> 
> Info: it works with hibernate and we have a workaround by transforming
> list content into a comma separated string.
> 
> Question: Bug or wrong usage of named parameter?
> 
> Kind regards,
> Tom
> 


-----
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/jpql-named-parameter-list-as-input-does-not-work-tp25678654p25696925.html
Sent from the EclipseLink - Users mailing list archive at Nabble.com.