0 Replies Latest reply on Oct 21, 2002 7:01 AM by Wesley Hall

    Collection based EJB-QL parameter...

    Wesley Hall Newbie

      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.