JPA and Hibernate – Criteria vs. JPQL or HQL

by

I mostly prefer Criteria Queries for dynamic queries. For example it is much easier to add some ordering dynamically or leave some parts (e.g. restrictions) out depending on some parameter.

On the other hand I’m using HQL for static and complex queries, because it’s much easier to understand/read HQL. Also, HQL is a bit more powerful, I think, e.g. for different join types.

More Related Contents:

  1. Hibernate criteria: Joining table without a mapped association
  2. How do you do a limit query in JPQL or HQL?
  3. What is the difference between JOIN and JOIN FETCH when using JPA and Hibernate
  4. How to get SQL from Hibernate Criteria API (*not* for logging)
  5. How can you call custom database functions with Hibernate?
  6. How to get distinct results in hibernate with joins and row-based limiting (paging)?
  7. How to transform a flat result set using Hibernate
  8. Hibernate Group by Criteria Object
  9. Hibernate Named Query Order By parameter
  10. Hibernate Criteria Query to get specific columns
  11. Hibernate HQL Query : How to set a Collection as a named parameter of a Query?
  12. How to escape reserved words in Hibernate’s HQL
  13. IN-clause in HQL or Java Persistence Query Language
  14. HQL Hibernate INNER JOIN
  15. Hibernate Criteria for Dates
  16. HQL left join of un-related entities
  17. HQL – row identifier for pagination
  18. No data type for node: org.hibernate.hql.internal.ast.tree.IdentNode HQL
  19. Is there a more efficient way of making pagination in Hibernate than executing select and count queries?
  20. How to write a like query in HQL
  21. Using hibernate criteria, is there a way to escape special characters?
  22. HQL recursion, how do I do this?
  23. Inserting data in one table using HQL in Hibernate
  24. org.hibernate.HibernateException: Access to DialectResolutionInfo cannot be null when ‘hibernate.dialect’ not set
  25. hibernate column name issues
  26. Hibernate recursive many-to-many association with the same entity
  27. Deploying application using Hibernate JPA 2.1 to IBM WebSphere gives NullPointerException
  28. Primitive or wrapper for hibernate primary keys
  29. JPA Multiple Embedded fields
  30. Delete Not Working with JpaRepository

Leave a Comment