title: one to many pagination with subselect
body: <p>Class looking like this</p>
  
  <pre><code>@Entity
  @Table(name = "orders")
  //@FetchProfiles({
  public class Orders implements Serializable {
  
  @Column
  private String ...
  
  @OneToMany
  @JoinColumn(..
  //@OrderBy("sequence desc")
  //@Fetch(FetchMode.SUBSELECT)
  private List&lt;OrderedProducts&gt; orderedProducts;
  }
  </code></pre>
  
  <p><strong>case 1:</strong> If i used one to many with eager/(lazy) then <strong>subselect</strong> working fine.</p>
  
  <p><em>Is it possible to do with fetch profiles? (only supporting join)</em></p>
  
  <p><strong>case 2:</strong> For list data to get parent with child's with respect to limit(<strong>pagination</strong>). i am using subList feature in List (1000->25).</p>
  
  <p>Example: one parent <strong>more than one  child</strong>
  If i used max results 5 it is giving only <strong>one record</strong> if parent has 5 child's</p>
  
  <p><em>Can any one give me some idea to handle this scenario with hibernate criteria?</em></p>
  
  <p><strong>case 3:</strong> If child property <strong>annotated with order by</strong> while execution time order by added before parent order specification</p>
  
  <p>Example: order by child.prop,this_.prop</p>
  
  <p><em>Is there any other way to configure to parent property order then child properties order?</em></p>
  
  <p>Example: order by this_.prop,child.prop</p>
  
  <p><strong>Note</strong>
  Iam sending data <strong>outside</strong> of the application scope. So, Lazy initialization wont work.</p>