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

[Thomas Rost <thomas.rost@xxxxxxxxxxxxxxxxx>]

We use JPA 1.0/EclipseLink 1.2 RC1 and it does not work.


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
>> 
> 
> 

-- 
View this message in context: http://www.nabble.com/jpql-named-parameter-list-as-input-does-not-work-tp25678654p25782039.html
Sent from the EclipseLink - Users mailing list archive at Nabble.com.