Hi,
> q.setParameter("roleIds", sb.toString());

 Set the IN parameter not as a String but a List<T> where T is the type of
Role.id.

  For example, if Role.id is int, then
   q.setParameter("roleIds", Arrays.asList(new int[]{1,2}));


-- 
View this message in context: 
http://n2.nabble.com/-JPQL--Problem-statement-SELECT-...-IN-%28%29-%2C-with-parameters-tp686295p686459.html
Sent from the OpenJPA Users mailing list archive at Nabble.com.

Reply via email to