Hi, All!

May be it is not exactly what Hibernate was created for, but I want to make some calculs on my DB.

For example, imagine a table A with two number fields X and Y. With SQL I can run
SELECT SUM(X * Y) FROM A;

How can I do the same thing with Hibernate (without fetching all records and running a for-loop to multiply and sum) ?

I prefer to use criterion API if it is possible, but I'm open to any suggestion.

Hibernate version: 3.1

Use Projections.sqlProjection("sum(x * y) as tot", {"tot"}, {Type.INTEGER}).

Obviously that's not real java code, you can create the arrays correctly in your own code.