HQL joined query to eager fetch a large number of relationships

by

Our team uses the special strategy to work with associations. Collections are lazy, single relations are lazy too, except references with simply structure (for an example a countries reference). And we use fluent-hibernate to load what we need in a concrete situation. It is simply because of fluent-hibernate supports nested projections. You can refer this unit test to see how complex object net can be partially loaded. A code snippet from the unit test

 List<Root> roots = H.<Root> request(Root.class).proj(Root.ROOT_NAME)
            .innerJoin("stationarFrom.stationar", "stationar")
            .proj("stationar.name", "stationarFrom.stationar.name")
            .eq(Root.ROOT_NAME, rootName).transform(Root.class).list();

See also

How to transform a flat result set using Hibernate

More Related Contents:

  1. What is the easiest way to ignore a JPA field during persistence?
  2. Hibernate and no PK
  3. @GeneratedValue polymorphic abstract superclass over MySQL
  4. Hibernate, spring, JPS & isolation – custom isolation not supported
  5. PersistentObjectException: detached entity passed to persist thrown by JPA and Hibernate
  6. Difference between FetchType LAZY and EAGER in Java Persistence API?
  7. How to map an entity field whose name is a reserved word in JPA
  8. Why is Hibernate Open Session in View considered a bad practice?
  9. What’s the difference between JPA and Hibernate? [closed]
  10. How to convert a Hibernate proxy to a real entity object
  11. What is the solution for the N+1 issue in JPA and Hibernate?
  12. JPA CascadeType.ALL does not delete orphans
  13. Wrong ordering in generated table in jpa
  14. Solve Hibernate Lazy-Init issue with hibernate.enable_lazy_load_no_trans
  15. Configure hibernate (using JPA) to store Y/N for type Boolean instead of 0/1
  16. what is @JoinColumn and how it is used in Hibernate
  17. JPA eager fetch does not join
  18. In which case do you use the JPA @JoinTable annotation?
  19. No Dialect mapping for JDBC type: 1111
  20. Hibernate one-to-one: getId() without fetching entire object
  21. JPA: Implementing Model Hierarchy – @MappedSuperclass vs. @Inheritance
  22. Hibernate: Where do insertable = false, updatable = false belong in composite primary key constellations involving foreign keys?
  23. Hibernate generates negative id values when using a sequence
  24. How to prevent SQL Injection with JPA and Hibernate?
  25. Specifying an Index (Non-Unique Key) Using JPA
  26. Hibernate: Create Mysql InnoDB tables instead of MyISAM
  27. IN-clause in HQL or Java Persistence Query Language
  28. What is the MariaDB dialect class name for Hibernate?
  29. Hibernate throws strange error: Class is not mapped
  30. How to force Hibernate to return dates as java.util.Date instead of Timestamp?

Leave a Comment