title: How to use list of value in where clause
body: <p>I am using hibernate3 in my java application. I have to find the list of value from oracle using hibernate. So my query is like </p>
  
  <p>Ex: </p>
  
  <pre><code>List&lt;TestClass&gt; selectedpins =DAO.findAll(from register where pin in (list))
  </code></pre>
  
  <p>This list contains list of ids(around 3000 values). Due to performance issue i am not able to use iterator. So kindly let me know how to use this list of value in this query.</p>
  
  <p>Is it possible in hibernate3?</p>