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]

Related Tags for Hibernate Projection Example (Sum):
c,  hibernate,  function,  fun,  io,  sum,  aggregate,  using,  this,  like,  unc,  projection,  nat,  to,  learn,  ear,  e,  il,  section,  li,  in,  m,  j,  func,  pro,  s,  su,  at,  k,  is,  ll,  gre,  ea,  ar,  s,  s,  th,  ga,  gat,  je,  proj,  pr,  on,  o

More Tutorials from this section

• Hibernate Projections
• Hibernate Projection Count
• Hibernate Projections Tutorials and Examples
• Hibernate Projection Example (Sum)
• Hibernate Projections (rowCount or countDistinct)
• Hibernate Projection Example (Sum)
• Using sum() in hibernate criteria.
• Hibernate Criteria Projection
• HibernateCriteriaAggregate-Projection
• hibernate projection
• projection criteria hibernate Example
• Hibernate Projection Count
• Hibernate Projections Tutorials and Examples
• Hibernate Projections (rowCount or countDistinct)
• sum and avg function using HQL.
• Hibernate Criteria Grouping Example
• Hibernate criteria sum.
• Hibernate Criteria Ordering Example
• Hibernate Criteria GroupBy Example
• Hibernate Criteria RowCount Example