Hibernate Community • View topic - fastest way to return the last record in a table in mysql

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

fastest way to return the last record in a table in mysql

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

Angelochen

Post subject: fastest way to return the last record in a table in mysql

Posted: Sun Dec 09, 2007 3:34 am

Newbie

Joined: Wed Sep 05, 2007 9:26 am
Posts: 16

Hi,
I need to get the latest record added to a table, is the following the best practice? thanks.

Angelo

List<App> lst = session.createQuery("from App order by txdate desc").list();
if (lst.size() > 0)
return lst.get(0);
else
return null;

Top

akiraly

Post subject:

Posted: Sun Dec 09, 2007 12:47 pm

Newbie

Joined: Fri Dec 07, 2007 5:52 am
Posts: 4
Location: Budapest, Hungary, EU

I would add setMaxResults:

Code:

List<App> lst = session.createQuery("from App order by txdate desc").setMaxResults(1).list();
if (lst.size() > 0)
  return lst.get(0);

return null;

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