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
Post a Comment