Join tables hibernate + group by

Question

I need to do this query with Java + Hibernate.

SELECT 
    table2.id,
    COUNT(table2.id) AS count
FROM
  table1 
    JOIN table2
       ON table1.fk_tb2 = table2.id  --many2one
GROUP BY
   table2.id

I would use DetachedCriteria class.....how can i do this ?

Matt · Accepted Answer · 2012-06-22T00:58:24.977

2

Try using projections like this:

Criteria table1Crit = session.createCriteria("table1");
Criteria table2Crit = table1Crit.createCriteria("table2", Criteria.INNER_JOIN);
table2Crit.setProjection( Property.forName("id").count() );

edited Jun 22 '12 at 00:58

answered Jun 21 '12 at 23:30

Matt

11,523
2
23
33

score -3 · Answer 2 · edited Jun 22 '12 at 08:01

-3

use your query with createNativeQuery method

edited Jun 22 '12 at 08:01

Bhavesh G

3,000
4
39
66

answered Jun 21 '12 at 20:37

storm_buster

7,362
18
53
75

2

this would defeat the purpose of using hibernate, if you resorted to native queries for such simple stuff. – Matt Jun 22 '12 at 00:13
well find the answer and let me know. – storm_buster Jun 22 '12 at 02:46

Join tables hibernate + group by

2 Answers2

Linked