What is the difference between JOIN and JOIN FETCH when using JPA and Hibernate

by

In this two queries, you are using JOIN to query all employees that have at least one department associated.

But, the difference is: in the first query you are returning only the Employes for the Hibernate. In the second query, you are returning the Employes and all Departments associated.

So, if you use the second query, you will not need to do a new query to hit the database again to see the Departments of each Employee.

You can use the second query when you are sure that you will need the Department of each Employee. If you not need the Department, use the first query.

I recomend read this link if you need to apply some WHERE condition (what you probably will need): How to properly express JPQL “join fetch” with “where” clause as JPA 2 CriteriaQuery?

Update

If you don’t use fetch and the Departments continue to be returned, is because your mapping between Employee and Department (a @OneToMany) are setted with FetchType.EAGER. In this case, any HQL (with fetch or not) query with FROM Employee will bring all Departments. Remember that all mapping *ToOne (@ManyToOne and @OneToOne) are EAGER by default.

More Related Contents:

  1. How do you do a limit query in JPQL or HQL?
  2. JPA and Hibernate – Criteria vs. JPQL or HQL
  3. Hibernate criteria: Joining table without a mapped association
  4. JPA eager fetch does not join
  5. How can you call custom database functions with Hibernate?
  6. How to use multiple JOIN FETCH in one JPQL query
  7. Hibernate Named Query Order By parameter
  8. Hibernate HQL Query : How to set a Collection as a named parameter of a Query?
  9. How to escape reserved words in Hibernate’s HQL
  10. IN-clause in HQL or Java Persistence Query Language
  11. HQL Hibernate INNER JOIN
  12. HQL left join of un-related entities
  13. HQL – row identifier for pagination
  14. No data type for node: org.hibernate.hql.internal.ast.tree.IdentNode HQL
  15. Is there a more efficient way of making pagination in Hibernate than executing select and count queries?
  16. How to write a like query in HQL
  17. HQL recursion, how do I do this?
  18. Inserting data in one table using HQL in Hibernate
  19. org.hibernate.MappingException: Could not determine type for: java.util.List, at table: College, for columns: [org.hibernate.mapping.Column(students)]
  20. How to remove entity with ManyToMany relationship in JPA (and corresponding join table rows)?
  21. Java: join array of primitives with separator
  22. Hibernate count collection size without initializing
  23. Getting [SQLITE_BUSY] database file is locked with select statements
  24. Silently ignored remove()
  25. Change database schema during runtime based on logged in user
  26. SQL Error: 0, SQLState: 08S01 Communications link failure [duplicate]
  27. Apparent connection leak detected with Hikari CP
  28. What properties does @Column columnDefinition make redundant?
  29. JPA Updating Bidirectional Association
  30. Autowired Repository is Null in Custom Constraint Validator

Leave a Comment