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)