0 Replies Latest reply on Dec 11, 2008 7:07 AM by Kishore Manthangod

    EJB QL - Parameter passing to IN

    Kishore Manthangod Newbie

      Can some one help me in passing parameter to IN clause of Select query?

      I have to find out active users in the database using UserBean where activeFlag is the property.

      "java.util.Collection findByHomeTeacherAndStatus(java.util.Collection values)"

      "SELECT OBJECT(u) FROM UserBean u WHERE u.activeFlag IN (?1)"

      I am getting a deployment exception. Cannot we pass collection as a parameter to EJB QL to IN clause? The possible values for the IN clause are (0), (1) and (0,1)