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}));


--
Sent from the OpenJPA Users mailing list archive at Nabble.com.