2 Replies Latest reply: Mar 12, 2009 3:32 PM by Joshua Davis RSS

    Preferred workaround for inability to bind a List as a parameter.

    Joshua Davis
      I've discovered that the JPA spec doesn't allow one to bind a List to an query like "select foo from Foo foo where status in (:statusList)". What is the preferred workaround?

      Do I need to change my query to something like "select foo from Foo foo where status in (:status1, :status2, :status3, ..., :statusN), and bind each element individually?

      Thanks.

      Josh Davis