0 Replies Latest reply on Feb 3, 2003 11:06 AM by Panagiotis Korros

    EJB-QL and Collections as Parameters

    Panagiotis Korros Newbie

      Does EJB-QL supports Collections as parameters?

      I have the following ejb-ql query:
      SELECT OBJECT(o) FROM Node o, IN(o.children) l WHERE l.shortcut MEMBER OF ?1 AND o.nodeClass.id = ?2

      where l.shortcut is of type Node and ?1 is a collection of nodes.

      Is this EJB-Q supported?

      In Jboss 3.0.6 i get the following error:
      Error compiling ejbql; - nested throwable: (org.jboss.ejb.plugins.cmp.ejbql.ParseException: Encountered "1" at line 1, column 75.
      Was expecting: