[jboss-user] [EJB/JBoss] - EJB QL - Parameter passing to IN

[mkkumar79]

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#4195902

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4195902