Re: [eclipselink-users] JPQL : Not able to use IN clause on only the val

[Tom Ware <tom.ware@xxxxxxxxxx>]

Hi Bhakti,

  It looks like there is an issue with this particular usecase.   Please file a 
bug.  The only workaround I can think of is to use EclipseLink native API to 
build your query or native SQL.

-Tom

On 10/12/2012 1:09 AM, bhakti b wrote:
> Hi Tom
>
> Yes, I have tried the value keyword, but it still selects both key and value
> combination and SQL Exception is thrown for "Too many values"
>
> This is JPQL that I have tried :
> 		<named-query name="fetchAllowedPurposeCodes">
>                  <query>
>                  select distinct
>                  a.allowedPurposeCodes from com.test.CreditPolicyTemplate
>                  c JOIN FETCH c.allowedPurposeCodes a where
> c.creditPolicyTemplateKey.creditPolicyTemplateId IN
>                  (	select
>                          value(lnk)
>                          from
>                          com.test.ProductGroup p JOIN
>                          p.groupCreditPolicyLinkage lnk
>                          where
>                          p.productGroupKey.productGroupCode in
>                          (:productGroup)
>                          )
>
>                  </query>
>          </named-query>
> 		
> Regards
> Bhakti
>
>
>
> --
> View this message in context: http://eclipse.1072660.n5.nabble.com/JPQL-Not-able-to-use-IN-clause-on-only-the-values-of-an-element-collection-map-tp156050p156340.html
> Sent from the EclipseLink - Users mailing list archive at Nabble.com.
> _______________________________________________
> eclipselink-users mailing list
> eclipselink-users@xxxxxxxxxxx
> https://dev.eclipse.org/mailman/listinfo/eclipselink-users