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

mkkumar79 do-not-reply at jboss.com
Thu Dec 11 07:07:20 EST 2008

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

More information about the jboss-user mailing list