join and limits

blackwolf-88 · **Joined:** Sun Jun 29, 2008 4:42 pm **Posts:** 3

hi guys, i'm italian and i'm new in hibernate
i have a query and i would like that when i join two tables, the rows selected, of the set (or list) of the property of the class table which plays the role one-to-many, don't are selected all but i would like that are selected only a certain number of rows
for example:
Criteria crit = session.createCriteria(tbl1.class).setFetchMode("prop_rowsTbl2", FetchMode.JOIN)
in the property prop_rowsTbl2 for each row of tbl1 can i select only a certain number of rows of tbl2 when i join the tables on the query?
I hope that you have understood the question
thanks

Cameron McKenzie · **Posted:** Fri Jul 04, 2008 10:38 am

If you just want to limit the number of results, it's as simple as using the setFirstResult and setMaxresults methods of the Criteria object:

Code:

package com.examscam.criteria;
import java.util.List;
import org.hibernate.Criteria;
import org.hibernate.Session;
import org.hibernate.criterion.Example;
import com.examscam.HibernateUtil; 
import com.examscam.model.User;

public class FindFirstFive {
 public static void main(String args[]) {
  User user = new User();
  Session session = HibernateUtil.beginTransaction();
  Criteria criteria = session.createCriteria(User.class);
  criteria.setFirstResult(0);
  criteria.setMaxResults(5);
  List results = criteria.list();
  HibernateUtil.commitTransaction();
  for (int i = 0; i<results.size(); i++) {
    System.out.println(results.get(i).toString());
  }
 }
}