Hibernate version:
3.2.3ga

Hi,

When I execute this query, it returns a list containing Video entities:



When I try to reproduce the results using Criteria I only get the column "name":


Is there a way to have the entities returned when using Criteria?

Hi ,

The point is that when you group a result with respect to a column name fetching other individual columns does not make sense rather you can get the max,min or sum or the columns grouped by the criteria specified.

For eg.

List list = criteria.setProjection(Projections.projectionList()
.add(Projections.sum("version"))
.add(Projections.groupProperty("name"))
).list();

Here I fetch the sum of version column of the rows grouped by name .
You cannot fetch the individual version values.

Even if you try to get it in oracle the error flashed would be
ORA-00979: not a GROUP BY expression

I know I should use distinct, but the problem still remains...

Hi,

You can only use distinct with the column you have in the group by clause.

eg
select distinct(name) from table group by name

select distinct(any other column) from table group by name
is still invalid

Hi,
>>> Is there a way to have the entities returned when using Criteria?
Yes.

In your case, criteria.setProjection() is used.
As per documentation, it is used to specify that the query results will be a projection (scalar in * nature).
That is why, a sclar ( and not an entity ) is returned.

-----------------------------------------------------------
Rate the reply if you find it helpful