Hibernate Community • View topic - Hibernate Criteria ( Difference between two column)

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

Hibernate Criteria ( Difference between two column)

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

DKPK

Post subject: Hibernate Criteria ( Difference between two column)

Posted: Tue Dec 15, 2009 5:25 pm

Newbie

Joined: Tue Dec 15, 2009 5:18 pm
Posts: 1

Hi,
Iam trying to use Hibernate Criteria API to create Dynamic Queries.
I wanted to find the difference between two dataresultset from a table.

Sum(col1-col2) from table_name
where col3=1;

How to do the difference part using Hibernate Criteria.
Please Help me with this.
Thanks in advance.

Top

blog.bambo.it

Post subject: Re: Hibernate Criteria ( Difference between two column)

Posted: Wed Dec 16, 2009 12:55 pm

Newbie

Joined: Wed Dec 16, 2009 12:24 pm
Posts: 6
Location: Munich

It's possible to do arithmetic operations with Projections.sqlProjection().

Example:

Code:

Criteria criteria = session.createCriteria(User.class);
criteria.setProjection(Projections.sqlProjection("this_.id * 1000 as multiId", new String[] {"multiId"}, new Type[]{Hibernate.INTEGER}));
criteria.list();

The problem is that you have to use SQL aliases to access columns. I've described a solution at http://blog.bambo.it/2009/12/generic-subcriterias-for-hibernate.html and http://blog.bambo.it/2009/12/arithmetic-operations-using-generic.html

Top

Page 1 of 1

[ 2 posts ]

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum