Hibernate Criteria n + 1问题与maxresults(Hibernate Criteria n+1 issue with maxresults)

 使用休眠ctiteria我想选择一个对象，并且它与一对多对象的列表相关联。 我想通过这个列表来分页，避免可怕的休眠n + 1选择问题 
 
 这是一个工作解决方案，需要11次访问10个父对象的数据库。 
 
Criteria criteria = this.getSession().createCriteria(Mother.class);
criteria.addOrder(Order.asc("title"))
.setMaxResults(details.getMaxRows())
.setFirstResult(details.getStartResult())
.setFetchMode("kittens", FetchMode.SELECT);
List test = criteria.list();
 
 这是一个解决方案，它只执行一个sql语句（hurray），但无法处理分页，即setMaxResults和setFirstResult在父对象上不正确（母语） 
 
Criteria criteria = this.getSession().createCriteria(Mother.class);
criteria.addOrder(Order.asc("title"))
.setResultTransformer(Criteria.DISTINCT_ROOT_ENTITY)
.setMaxResults(details.getMaxRows())
.setFirstResult(details.getStartResult())
.setFetchMode("kittens", FetchMode.JOIN);
List test = criteria.list();
 
 这似乎是这样一个常见的要求，但我已经找到了一个没有运气的解决方案。 
 
 任何接受者？ 

Using hibernate ctiteria I want to select an object and it's associated oneToMany list of objects. I want to paginate through this list avoiding the dreaded hibernate n+1 select issue 
 
Here's a working solution which requires 11 trips to the database for 10 parent objects.
 
Criteria criteria = this.getSession().createCriteria(Mother.class);
criteria.addOrder(Order.asc("title"))
.setMaxResults(details.getMaxRows())
.setFirstResult(details.getStartResult())
.setFetchMode("kittens", FetchMode.SELECT);
List test = criteria.list();
 
And here's a solution which executes only one sql statement (hurray) but cannot handle pagination ie the setMaxResults and setFirstResult are incorrect on the parent object Mother (boo)
 
Criteria criteria = this.getSession().createCriteria(Mother.class);
criteria.addOrder(Order.asc("title"))
.setResultTransformer(Criteria.DISTINCT_ROOT_ENTITY)
.setMaxResults(details.getMaxRows())
.setFirstResult(details.getStartResult())
.setFetchMode("kittens", FetchMode.JOIN);
List test = criteria.list();
 
This seems like such a common requirement but I've dug around for a solution with no luck.
 
Any takers?

原文：https://stackoverflow.com/questions/5567754