0 Replies Latest reply on Sep 13, 2009 12:37 AM by Walter White

    EntityQuery IN Clause

    Walter White Novice

      Hi all,

      I am passing a Collection into my in clause:

      <framework:entity-query name="Node_findByNameIn" ejbql="SELECT node FROM Node node">
                     <value>node.name IN #{names}</value>

      #{names} is the collection of Strings.  I want to pull back all results with the name matching one in the list.

      When I do that, I am getting a hibernate error:
      org.hibernate.hql.ast.QuerySyntaxException: unexpected token

      Any ideas how to use the IN Clause properly?