title: Pagination with Hibernate criteria and FetchMode.JOIN
body: <p>I've got two tables, 'Players' and 'Items'.  Players have a list of items.  I want to retrieve the players, and all of their items, using pagination.  I want to paginate based on the players and without regard to how many items there are.</p>
  
  <p>So I do something like this:</p>
  
  <pre><code>Criteria c = session.createCriteria(Players.class).setFetchMode("items", FetchMode.JOIN);
  c.addOrder(Order.asc("playerID"));
  c.setFirstResult(0);
  c.setMaxResults(25);
  List&lt;Player&gt; players = c.list();
  </code></pre>
  
  <p>Is this going to give me the first 25 players, or will it give me the first 25 items (grouped by players)?  I'm wondering if this behavior is undefined like it would be for JPA queries, or if perhaps there's a guaranteed answer.</p>
  
  <p>Regardless, what are Criteria queries that would give me the first 25 players or the first 25 player-item combinations (ordered by player ID, then item ID)?</p>