Hibernate Community • View topic - HQL SubSeclect to criteria

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

HQL SubSeclect to criteria

Page 1 of 1

[ 3 posts ]

Previous topic | Next topic

Author

Message

etienne

Post subject: HQL SubSeclect to criteria

Posted: Tue Aug 09, 2005 9:59 am

Senior

Joined: Tue Jan 11, 2005 5:03 pm
Posts: 137
Location: Montreal, Quebec

Hi,

Does anyone know how to translate this HQL in criteria?

from AstExchangeRate rate where rate.id.astRateDate = (select max(rate.id.astRateDate) from rate

Thanks

Etienne

Top

sergeya

Post subject: Re: HQL SubSeclect to criteria

Posted: Tue Aug 09, 2005 11:11 am

Regular

Joined: Thu Dec 02, 2004 7:11 am
Posts: 85

etienne wrote:

Hi,

Does anyone know how to translate this HQL in criteria?

from AstExchangeRate rate where rate.id.astRateDate = (select max(rate.id.astRateDate) from rate

Something like this:

Code:

DetachedCriteria maxRateDateQuery = DetachedCriteria.forClass(AstExchangeRate.class);
maxRateDateQuery.setProjection(Projections.max("id.astRateDate"));

Criteria rateQuery = session.createCriteria(AstExchangeRate.class); 
rateQuery.add( Subqueries.eq("id.astRateDate",maxRateDateQuery) ); 

rateQuery.list();

Top

sergeya

Post subject:

Posted: Tue Aug 09, 2005 11:14 am

Regular

Joined: Thu Dec 02, 2004 7:11 am
Posts: 85

Correction:

Code:

rateQuery.add( Subqueries.propertyEq("id.astRateDate",maxRateDateQuery) );

Top

Page 1 of 1

[ 3 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