How to use Hibernate SQL projection query?

Question

I have a SQL projection query that returns a list, but I want a single result. Here is my projection query:

Criteria criteria = getCurrentSession().createCriteria(TbLoyaltytrans.class) .add(Restrictions.eq("custid", custId)) .setProjection(Projections.projectionList() .add(Projections.sum("pointin").as("pointin")) .add(Projections.sum("pointout").as("pointout")) .add(Projections.sqlProjection( "(pointin - pointout) as points", new String[]{"points"}, new org.hibernate.type.DoubleType[]{ new org.hibernate.type.DoubleType() }), "points") );

I want a single object, i.e.: the count from the above query.

What I did wrong with the above query?

mejoz · Accepted Answer · 2016-09-29 12:50:51Z

1

I assume your are using criteria.list() in order to get the list. You can use criteria.uniqueResult() and it will return a single Object or null.

answered Sep 29, 2016 at 12:50

mejoz

1351 silver badge8 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

ANucool Mittal Over a year ago

i got the ans i just return (Object[]) criteria.uniqueResult() and iterate this as i understand by using projection you will get three results as output in above query 1st if for Projections.sum("pointin").as("pointin") sencond is for Projections.sum("pointout").as("pointout")) and the last one is your SQLprojection output that i want i iterate this array and fetch third position like Double reedeemPoints =new Double(obj[2].toString()) and it works for me thank you for your ans

roizpi Over a year ago

If it really worked to you, your could accept his answer. Thanks!

Collectives™ on Stack Overflow

How to use Hibernate SQL projection query?

1 Answer 1

2 Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Related