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.