Hi all,
I have a question regarding some EJB-QL that im trying to write.
Background is that i have a resource bean that has a CMR collection of skills... my finder takes a collection as a parameter and finds all resources that have ALL the skills listed in the collection parameter
The EJB-QL that i am trying is....
SELECT OBJECT(r) FROM resource as R, IN( ?1 ) AS s where s MEMBER OF r.skills
JBoss complains when trying to compile this EJB-QL saying...
org.jboss.deployment.DeploymentException: Error compiling ejbql; - nested throwable: (org.jboss.ejb.plugins.cmp.ejbql.ParseException: Encountered "1" at line 1, column 42.
Was expecting:
<COLLECTION_VALUED_PATH> ...
)]
So it doesnt seem to like the IN ( ?1 ) part of the query...
Could anyone nudge me in the right direction? Thanks.