Criteria criteria = session.createCriteria(A.class, "test")
.setProjection( Projections.projectionList()
.add( Projections.property("name").as("name_A") )
);
This is ok.


When I add in the group by as show below
Criteria criteria = session.createCriteria(A.class, "test")
.setProjection( Projections.projectionList()
.add( Projections.property("name").as("name_A") )
.add( Projections.groupProperty("test.name") )
);

I will have errors:
org.hibernate.exception.SQLGrammarException: could not execute query

How do I do the GROUP BY for createCriteria??
What is the correct name for the Property to call???

Thanks in advance!!

I believe you want something like this

.add( Projections.property("name").as("name_A") )
.add( Projections.groupProperty("name_a") )

I believe you want something like this

.add( Projections.property("name").as("name_A") )
.add( Projections.groupProperty("name_A") )

Its still giving me the same error.
org.hibernate.exception.SQLGrammarException: could not execute query

My Database is SQL Server 2005 and here is how I have achieved.



SQL output

Hibernate: select this_.DISPLAY_NAME as y0_ from tbl_TASK_TYPE_FUNCTION this_

List<String> objects were returned.

Now Group by Name:-



Hibernate: select this_.DISPLAY_NAME as y0_ from tbl_TASK_TYPE_FUNCTION this_ group by this_.DISPLAY_NAME

again List<String> objects are returned.

In your case you need not add the "name" in your projection. I guess If you have a group by in the HQL then Hibernate Adds it for you in the Projection also.

Hope this helps,
Latha.