In this section, you will learn to hibernate aggregate function like: sum() using hibernate projection.

Hibernate Projection Example (Sum)

     

In this section, you will learn to hibernate aggregate function like: sum() using hibernate projection. 

The following example to calculate the sum of invested_amount to the Insurance table 

Table Name: Insurance

Here is the code of program:

package roseindia.tutorial.hibernate; import java.util.List; import org.hibernate.Criteria; import org.hibernate.Session; import org.hibernate.SessionFactory; import org.hibernate.cfg.Configuration; import org.hibernate.criterion.ProjectionList; import org.hibernate.criterion.Projections; public class ProjectionExample1 {   /**  * @param args  */   public static void main(String[] args) {   // TODO Auto-generated method stub      Session sess = null;   try {   SessionFactory fact = new    Configuration().configure().buildSessionFactory();   sess = fact.openSession();   Criteria crit = sess.createCriteria(Insurance.class);   ProjectionList proList = Projections.projectionList();   proList.add(Projections.sum("investementAmount"));   crit.setProjection(proList);   List sumResult = crit.list();   System.out.println("Total Invested Amount: " + sumResult);   }   catch(Exception e){   System.out.println(e.getMessage());   }   } }

Download this Code.

Output:

log4j:WARN No appenders could be found for logger (org.hibernate.cfg.Environment). log4j:WARN Please initialize the log4j system properly. Hibernate: select sum(this_.invested_amount) as y0_ from insurance this_ Total Invested Amount: [51400]

Recommend the tutorial