How to properly express JPQL “join fetch” with “where” clause as JPA 2 CriteriaQuery?

by

In JPQL the same is actually true in the spec. The JPA spec does not allow an alias to be given to a fetch join. The issue is that you can easily shoot yourself in the foot with this by restricting the context of the join fetch. It is safer to join twice.

This is normally more an issue with ToMany than ToOnes.
For example, 

Select e from Employee e 
join fetch e.phones p 
where p.areaCode="613"

This will incorrectly return all Employees that contain numbers in the ‘613’ area code but will left out phone numbers of other areas in the returned list. This means that an employee that had a phone in the 613 and 416 area codes will loose the 416 phone number, so the object will be corrupted.

Granted, if you know what you are doing, the extra join is not desirable, some JPA providers may allow aliasing the join fetch, and may allow casting the Criteria Fetch to a Join.

More Related Contents:

  1. JPA CascadeType.ALL does not delete orphans
  2. How can I validate two or more fields in combination?
  3. Storing a Map using JPA
  4. Hibernate – @ElementCollection – Strange delete/insert behavior
  5. JPA: unidirectional many-to-one and cascading delete
  6. JPA Query selecting only specific columns without using Criteria Query?
  7. How do I properly cascade save a one-to-one, bidirectional relationship on primary key in Hibernate 3.6
  8. Silently ignored remove()
  9. JPA Criteria builder IN clause query
  10. How to define unidirectional OneToMany relationship in JPA
  11. Hibernate generates negative id values when using a sequence
  12. java.lang.IllegalStateException: Multiple representations of the same entity with @ManyToMany 3 entities
  13. UNION to JPA Query
  14. Rollback on every checked exception, whenever I say @Transactional
  15. Hibernate triggering constraint violations using orphanRemoval
  16. JPA Criteria Tutorial [closed]
  17. Really dynamic JPA CriteriaBuilder
  18. Change Table Name of an Entity on runtime? [duplicate]
  19. JPA Select latest instance for each item
  20. How to map an entity field whose name is a reserved word in JPA
  21. Wrong ordering in generated table in jpa
  22. ImprovedNamingStrategy no longer working in Hibernate 5
  23. Correct use of flush() in JPA/Hibernate
  24. JPA – Returning an auto generated id after persist()
  25. JPA – Persisting a One to Many relationship
  26. How to call Oracle Function or Procedure using Hibernate (EntityManager) or JPA
  27. Refresh and fetch an entity after save (JPA/Spring Data/Hibernate)
  28. Doing an “IN” query with Hibernate
  29. Difference between save and saveAndFlush in Spring data jpa
  30. What does EntityManager.flush do and why do I need to use it?

Leave a Comment