hibernate - How to use list of value in where clause -


I am using Hibernate 3 in my Java application. I have to search the list of value from the oracle using hibernate. So my query is like

Ex:

  list & gt; Test class & gt; Selectpins = DAO.findAll (in the register where in the pin (list))   

This list contains the list of ID (approximately 3000 values). Due to the performance, I can not use the Iterator. Please tell me how to use this list of values ​​in this query.

What is possible in Hibernate 3?

  session .createQuery ("select pin in the list (pin: (in the list)") .setParameterList ("list", pinIds) .getResultList ();    

Comments