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">
                <framework:restrictions>
                     <value>node.name IN #{names}</value>
                </framework:restrictions>
           </framework:entity-query>



      #{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?



      Thanks,
      Walter