criteria.add(Restrictions.in(criteriaName, listOfValues);

int maxValues = 1;
    int nbValues = listOfValues.size();

    // Determine the number of sub lists to be created.
    int nbCriteria = (int) (nbValues / maxValues);
    nbCriteria = (nbCriteria * maxValues == nbValues) ? nbCriteria : nbCriteria + 1;

    // Create the sub lists related to the criteria.
    int startIndex = 0, stopIndex = startIndex + maxValues;
    for (int i = 0; i < nbCriteria; i++) {     
      if (stopIndex > nbValues) {
        stopIndex = nbValues;
      }   
      if (i == 0) {
        criteria.add(Restrictions.in(criteriaName, listOfValues.subList(startIndex, stopIndex)));       
      } else {
        criteria.add(Restrictions.or(Restrictions.in(criteriaName, listOfValues.subList(startIndex, stopIndex))));
      }
      startIndex += maxValues;   
      stopIndex += maxValues;
    }

...where criteriaName in (val1, ..., val100) OR criteriaName in (val101, ..., val200) ...)

...where criteriaName in (val1, ..., val100) AND criteriaName in (val101, ..., val200) ...)

    * Group expressions together in a single disjunction (A or B or C...).
    *
    * This form creates an empty disjunction.  See {@link Disjunction#add(Criterion)}
    *
    * @return Conjunction
    */
   public static Disjunction disjunction() {
      return new Disjunction();
   }