Hibernate Community • View topic - HQL LIMIT not working

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

HQL LIMIT not working

Page 1 of 1

[ 3 posts ]

Previous topic | Next topic

Author

Message

dawuad

Post subject: HQL LIMIT not working

Posted: Wed May 25, 2005 12:54 pm

Regular

Joined: Wed Sep 29, 2004 11:34 am
Posts: 62
Location: Houston, TX

HQL query not executing as expected. The limiter does not work. The query works fine but the LIMIT does not. It ouputs more than the limit it was set for. The following is the query:

Code:

select pa, max(pa.AccessTime) from PersonAccess pa 
 where pa.EmployeeID.Id =  31
 group by pa.PersonID.Id 
 order by 2 DESC LIMIT 1

The resultset should only be one, but it returns many more than that.

Top

gavin

Post subject:

Posted: Wed May 25, 2005 1:36 pm

Hibernate Team

Joined: Tue Aug 26, 2003 12:50 pm
Posts: 5130
Location: Melbourne, Australia

So, um, please point to where in the Hibernate documentation (or even the ANSI SQL standard) the famous "HQL LIMIT clause" is described.

Use setMaxResults(), and read documentation.

Top

caoilte

Post subject:

Posted: Thu May 26, 2005 11:25 am

Newbie

Joined: Thu Dec 02, 2004 6:27 am
Posts: 10

It did used to work in Hibernate 2.1.

I also just had to make a minor change because of it (not that I'm complaining, it's just that it's a bit non-intuitive when migrating).

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