Hibernate group by of a parent class/domain

Asked Feb 15 '14 at 08:49

Active Feb 15 '14 at 08:49

Viewed 147 times

My models are as follows

class A{
   int id;
   String name;
}

class B{
   int id;
   String name;
   @ManyToOne(optional = false)
   A a;
}

class C{
   int id;
   int name;
   @ManyToOne(optional = false)
   B b;
}

Now I want to get the result from table/class C group by class A

I have written so far

Criteria criteria = session.getCurrentSession().createCriteria(
                C.class);
criteria. (Group by A); // i dont know how to do it

return criteria.list();

I don't know how to put the group by Class A

So how to do this??

asked Feb 15 '14 at 08:49

LynAs

6,407
14
48
83

you could also use a hibernate query and then group by ? from className where condition group by classNameA – Rat-a-tat-a-tat Ratatouille Feb 15 '14 at 09:38
could you please write me the code? – LynAs Feb 15 '14 at 11:24
hey please visit this[http://stackoverflow.com/questions/13997675/select-all-columns-with-group-by-in-hibernate-criteria-queries], check how the criteria query is used, and then try urs – Rat-a-tat-a-tat Ratatouille Feb 15 '14 at 11:33
and just like some threads say without projections you cannot get a whole entity in a criteria query, use sql in hibernate, in that case, you could use the group by like in every sql query – Rat-a-tat-a-tat Ratatouille Feb 15 '14 at 11:34

Hibernate group by of a parent class/domain

0 Answers0