| Re: [eclipselink-users] jpql named parameter list as input does not work |
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.