mysql - ROLLUP alternative in Hibernate HQL -


i have query in using group rollup , works in mysql.

select r.region_name  , ad.district_name  , count(me.employee_id) `master_employee` me  inner join app_district ad       on me.`district_id` = ad.`district_uid` inner join region r       on ad.region_uid = r.region_uid  group ad.region_uid, ad.district_name rollup 

hql

select new com.eld.chart.chartvalues (r.regionname, dm.districtname, str(count(me.districtmodel)))  masteremployeemodel me join me.districtmodel dm join dm.regionmodel r  group rollup(me.districtmodel, r.regionname) 

shows following exception

17:13:51,311 error [org.hibernate.util.jdbcexceptionreporter] (http-localhost-127.0.0.1-8080-2)  have error in sql syntax; check manual corresponds mysql server version right syntax use near '(masterempl0_.district_id, divisionmo2_.region_name)' @ line 1 

is there valid alternative rollup hibernate?


Comments