Using sum() in hibernate criteria

Question

How can I write the sql query select sum(amount * direction) from transactions into hibernate criteria ?

Answer 1

Think I found the answer. You must use the Projection.sqlProjection() and not Projections.sum(). Example:

.setProjection(Projections.sqlProjection("sum(cast(amount as signed)* direction) as amntDir", new String[] {"amntDir"} , new Type[] {Hibernate.DOUBLE}));