query setParameter with List

#1 09-05-2008, 03:33 AM

hey everybody,

I am trying to write a query like this:

SELECT * from person WHERE personId IN ( ?1 )

the query should take just one parameter, List of personIds :
util.List<Integer>

so it becomes: query.setParameter(idList);

how i can do this?
or is it possible with openJpa?

--
View this message in context: http://n2.nabble.com/query-setParame...76p840676.html
Sent from the OpenJPA Users mailing list archive at Nabble.com.

#2 09-05-2008, 09:20 AM

Hi there.

OpenJPA does indeed support queries that use a list parameter as query
criteria. Here's a snippet of code that uses a JPQL query to return
those Person entities which have a matching id in a list of personId.

Query qry = em.createQuery("SELECT p FROM Person p WHERE p.personId
IN (

ids )");
List<Integer> ids = new ArrayList<Integer>();
ids.add(1);
ids.add(2);
qry.setParameter("pids", pids);
List<Person> people = qry.getResultList();

-Jeremy

#3 09-08-2008, 07:47 AM

thanks a lot,
now it works.

I was using native query not hql query. that's why it didn't work.
--
View this message in context: http://n2.nabble.com/query-setParame...6p1057825.html
Sent from the OpenJPA Users mailing list archive at Nabble.com.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode