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) View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4195902#... Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...