Hi, Can you post the exception stack trace?
Fay ----- Original Message ---- From: me_satya <[email protected]> To: [email protected] Sent: Tue, October 27, 2009 1:40:13 AM Subject: Re: [JPQL] Problem statement SELECT ... IN () , with parameters String queryString = new String("SELECT ci FROM Cxyz ci WHERE ci.Idxyz IN (:UIDs) AND ci.dxyz IS NULL"); Query query = em.createQuery(queryString); ci.Idxyz is the column of byte type. this :UIDs is the list of object. Can any one let me know how can i set this list in the query I tried the following but got some unsupported operation exception. List<byte[]> IdList = Arrays.asList(new byte[]{}); for (UID<ContextContainerId> containerId : containerUIDs) { UIdList.add(containerId.toBytes()); } query.setParameter("UIDs", UIdList); I will appriciate you people help me out here!!! -- View this message in context: http://n2.nabble.com/JPQL-Problem-statement-SELECT-IN-with-parameters-tp686295p3897633.html Sent from the OpenJPA Users mailing list archive at Nabble.com.
