How do I do a “deep” fetch join in JPQL?

by

The JPA spec does not allow aliasing a fetch join, but some JPA providers do.

EclipseLink does as of 2.4. EclipseLink also allow nested join fetch using the dot notation (i.e. “JOIN FETCH a.bs.c”), and supports a query hint “eclipselink.join-fetch” that allows nested joins (you can specify multiple hints of the same hint name).

In general you need to be careful when using an alias on a fetch join, as you can affect the data that is returned.

See,
http://java-persistence-performance.blogspot.com/2012/04/objects-vs-data-and-filtering-join.html

More Related Contents:

  1. How do I count the number of rows returned by subquery?
  2. JPA EntityManager: Why use persist() over merge()?
  3. JPA 2.0, Criteria API, Subqueries, In Expressions
  4. When use getOne and findOne methods Spring Data JPA
  5. Adding IN clause List to a JPA Query
  6. JPQL IN clause: Java-Arrays (or Lists, Sets…)?
  7. Create JPA EntityManager without persistence.xml configuration file
  8. Spring Data JPA And NamedEntityGraphs
  9. Parameter in like clause JPQL
  10. JPQL Constructor Expression – org.hibernate.hql.ast.QuerySyntaxException:Table is not mapped
  11. How to persist JSR-310 types with Spring Data JPA?
  12. Is it possible to output generated SQL using EclipseLink without having to increase log verbosity?
  13. JPA passing list to IN clause in named native query
  14. How to use multiple JOIN FETCH in one JPQL query
  15. Limit number of results in JPQL
  16. How To Define a JPA Repository Query with a Join
  17. Using the JPA Criteria API, can you do a fetch join that results in only one join?
  18. Setting a parameter as a list for an IN expression
  19. JPA 2.0 native query results as map
  20. How can I avoid the Warning “firstResult/maxResults specified with collection fetch; applying in memory!” when using Hibernate?
  21. IN-clause in HQL or Java Persistence Query Language
  22. Spring Data JPA and Exists query
  23. JPQL Like Case Insensitive
  24. Testing an EJB with JUnit
  25. JPA: JOIN in JPQL
  26. Escaping the colon character ‘:’ in JPA queries
  27. JPA utf-8 characters not persisted
  28. JPA Query to handle NULL parameter value
  29. JPA Criteria API group_concat usage
  30. What’s the difference between the IN and MEMBER OF JPQL operators?

Leave a Comment