hibernate group

gistfile1.java

List<EventualidadDto> sumaTotalDeHoras = ((Session)JPA.em().getDelegate()).createCriteria(Eventualidad.class)
		.setProjection( Projections.projectionList()
		.add(Projections.sqlGroupProjection("sum({alias}.totalDeHoras) as sumaDeHoras", "{alias}.docente_codigo,{alias}.tipoEventualidad_id", 
					new String[]{"sumaDeHoras"}, new Type[] {DoubleType.INSTANCE}),"sumaDeHoras"))
		.add( Restrictions.sqlRestriction(" ( {alias}.docente_codigo = ? ) ", new String[] {r.codigo}, new Type[] {StringType.INSTANCE}))
		.add( Restrictions.sqlRestriction(" ( {alias}.tipoEventualidad_id = ? ) ", new Long[] {tipoEventualidad.id}, new Type[] {LongType.INSTANCE}))
		.setResultTransformer(new AliasToBeanResultTransformer(EventualidadDto.class)).list();