[
Date Prev][
Date Next][
Thread Prev][
Thread Next][
Date Index][
Thread Index]
[
List Home]
Re: [eclipselink-users] jpql named parameter list as input does not work
|
It definitely should not have brackets, brackets would mean you are binding a
value inside the list, not the entire list. This is the JPA 2.0 grammar.
Thomas Rost wrote:
>
> We use JPA 1.0/EclipseLink 1.2 RC3 and it does not work.
> We found out it works without the brackets in the query: X IN :BUID
> instaed of X IN (:BUID).
>
> Question: It's a feature or a bug? In Hibernate brackets are mandatory.
>
>
> James Sutherland wrote:
>>
>> 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-tp25678654p25803240.html
Sent from the EclipseLink - Users mailing list archive at Nabble.com.