Register / Login
EJB and other Java EE Technologies
JPQL query with IN Operator
paddy Mahadeva Iyer
posted 8 years ago
Consider my JPQL query
Select e from MyEbo e Where e.field1 IN ( ?1)
and that "field1" is of type integer.
Now to my problem. Lets say i want to
for two numbers while executing this query first time "eg: 1,2" and the second time with three numbers "eg:1,2,3". How do i do this?
I mean when i try to pass a
a parameter "1,2,3" it is not accepting neither a integer array. So is there anyway to reuse the same query for multiple set of parameters?
Boost this thread!
JPQL Query Dout
How to pass an Integer Array to a Stored Procedure in mysql?
Join Fetch using EclipseLink
How to do optional wildcard select in JPA named queries?