When to use Hibernate projections?

hibernate hibernate-criteria nhibernate-projections
reddy picture reddy · Sep 21, 2011 · Viewed 89.6k times · Source

I am a little confused about Hibernate's projections and criteria. When to use projections and when to use criteria?

Answer

Xavi López picture Xavi López · Sep 21, 2011

They're not mutually exclusive, you can use both at the same time. Projections are generally used in the context of some Criteria.

To put it simple, Hibernate Projections are used in order to query only a subset of the attributes of an entity or group of entities you're querying with Criteria. You can also use Projections to specify distinct clauses and aggregate functions like max, sum and so on. It's like referring to which data you're fetching. Like modifying the select clause in an SQL query.

Hibernate Criteria are used to define conditions the data has to satisfy in order to be selected. It's like referring to how is the data you're fetching. Like modifiying the from and where clauses of an SQL query.

Note that this how and which is not strictly true, it's just an orientation aimed to aid the OP. You can change which data you're fetching with createCriteria(String associationPath) for instance.

I'd suggest to take a look at this article Hibernate: Criteria Queries in Depth

Related questions

JPA and Hibernate - Criteria vs. JPQL or HQL

What are the pros and cons of using Criteria or HQL? The Criteria API is a nice object-oriented way to express queries in Hibernate, but sometimes Criteria Queries are more difficult to understand/build than HQL. When do you use …

Read More
Hibernate Criteria Restrictions AND / OR combination

How would I achieve this using Hibernate Restrictions? (((A='X') and (B in('X',Y))) or ((A='Y') and (B='Z')))

Read More
org.hibernate.QueryException: could not resolve property: filename

I am using Hibernate Criteria to get values from column filename in my table contaque_recording_log. But when I'm getting the result, it throws an exception org.hibernate.QueryException: could not resolve property: filename of: com.contaque.hibernateTableMappings.contaque_…

Read More