Looking at the examples at
Sun's JPA, I wrote the HQL with a sub query like this
Code:
select fp from FundPerformance fp where fp.fund.id IN (select f from Fund f, IN (f.fofs) AS ff where ff.id = ?1)
It seems to have a problem with the query.
Code:
select f from Fund f, IN (f.fofs) AS ff where ff.id = ?1
whether executed independently or within a sub-query. The error is
java.lang.IllegalArgumentException: org.hibernate.hql.ast.QuerySyntaxException: unexpected token: ffs near line 1, column 143 [select fp from xxx.FundPerformance fp where fp.fund.id IN(select f from xxx.Fund f, IN (f.fofs) AS ff where ff.id = ?1)]
Any suggestions, as it is the same example given in Sun's Tutorial