Hibernate Criteria Join with 3 Tables

by

The fetch mode only says that the association must be fetched. If you want to add restrictions on an associated entity, you must create an alias, or a subcriteria. I generally prefer using aliases, but YMMV:

Criteria c = session.createCriteria(Dokument.class, "dokument");
c.createAlias("dokument.role", "role"); // inner join by default
c.createAlias("role.contact", "contact");
c.add(Restrictions.eq("contact.lastName", "Test"));
return c.list();

This is of course well explained in the Hibernate reference manual, and the javadoc for Criteria even has examples. Read the documentation: it has plenty of useful information.

More Related Contents:

  1. Hibernate Criteria Restrictions AND / OR combination
  2. Hibernate: Difference between session.get and session.load
  3. Hibernate: one-to-one lazy loading, optional = false
  4. How to use Spring managed Hibernate interceptors in Spring Boot?
  5. What is the difference between DAO and Repository patterns?
  6. Mixing implicit and explicit JOINs
  7. @OrderColumn annotation in Hibernate 3.5
  8. How to query data for Primefaces dataTable using lazy loading and pagination
  9. SQL syntax term for ‘WHERE (col1, col2) < (val1, val2)'
  10. Performing Date/Time Math In HQL?
  11. How to connect to multiple databases in Hibernate
  12. Spring Boot & Spring Data: how are Hibernate Sessions managed?
  13. How to get distinct results in hibernate with joins and row-based limiting (paging)?
  14. Hibernate – why use many-to-one to represent a one-to-one?
  15. how to return Map with HQL
  16. Spring Data JPA – Pass column name and value as parameters
  17. hibernate could not get next sequence value
  18. Invalidating JPA EntityManager session
  19. How to generate a ddl creation script with a modern Spring Boot + Data JPA and Hibernate setup?
  20. Grails 2.4 and hibernate4 errors with run-app
  21. Hibernate/JPA ManyToOne vs OneToMany
  22. Hibernate Criteria for Dates
  23. How is Hibernate deciding order of update/insert/delete
  24. Hibernate inserts duplicates into a @OneToMany collection
  25. hibernate – get id after save object
  26. How to use JPA2’s @Cacheable instead of Hibernate’s @Cache
  27. Hibernate 3.6 – session.get() vs session.load()
  28. createEntityManager throws java.lang.NullPointerException at org.hibernate.engine.transaction.internal.jta.JtaStatusHelper.getStatus
  29. CDI injection in EntityListeners
  30. UnsupportedOperationException: The application must supply JDBC connections

Leave a Comment