spring data jpa and hibernate n+1 selects on manytoone column

[Rj Ewing]

I am using spring data jpa, hibernate, and mysql. When I load an entity with a manytoone column, hibernate is issuing multiple select statements. This article seems to explain the issue a bit, and claims that eager fetching should never be used.

We are not having performance issues, so I wasn't planning on optimizing and returning only the data needed in each query, however I would like to fix the n+1 issue.

How can I instruct hibernate/spring jpa to use a join instead of multiple selects?

@Entity
public class Parent {
   @Id
   @GeneratedValue(strategy = GenerationType.IDENTITY)
   private long id;

   @Temporal(TemporalType.TIMESTAMP)
   private Date ts;

   @OneToMany(fetch=FetchType.LAZY, mappedBy="parent") 
   private Child child;
}

@Entity
public class Child {
   @Id
   @GeneratedValue(strategy = GenerationType.IDENTITY)
   private long id;

   @ManyToOne
   @JoinColumn(name="parentId", referencedColumnName="parentId")
   private Parent parent;
}

[Rob Spoor]

Use a fetch join in your select statement. Both JPQL and the criteria query API support fetch joins.

[Rj Ewing]

Is that the only way? Is there a setting or something in spring data jpa to use fetch join statements?

One of the advantages of using spring data jpa was that I the query statements are generated from the method names. It seems like a join fetch would be preferred over multiple selects.