Retriving last record in a table

mmcallis · **Joined:** Thu Oct 20, 2005 7:21 am **Posts:** 4

Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version: 3

Name and version of the database you are using: Postgresql 8.0.3

Just a quick question, I've read through any related material I could find though none really covered the area I'm looking for. When I save an item to my database, I want to retrieve the id of this record, as it is generated in the save command, I never have it in my code. Basically what I would like to do is just retrieve the last record in the table, without querying the table to return all the records. Is there a specific command to return the last item saved to a table?

Thanks for any help.
Michael.

mmcallis · **Joined:** Thu Oct 20, 2005 7:21 am **Posts:** 4

mmcallis wrote:

Is there a specific command to return the last item saved to a table?

Sorry should have said specific command to return the last record in the database.

Thanks
Michael.

Varienaja · **Posted:** Thu Oct 20, 2005 8:28 am

You'll probably have a method getId() and setId() in your objects.

Code:

Cat c = new Cat() //c.getId() will give the default value, usually -1.
c.name='Peter';
Session.save(c); //Here, the method c.setId() is invoked.

System.out.println(c.getId()); //Here, you'll see which primary key Hibernate has given the object.

mmcallis · **Joined:** Thu Oct 20, 2005 7:21 am **Posts:** 4

Yeah should have gave more info sorry. My cat object has a getId but id in the table is of type sequence, so getId() would return null, as the cat object only has the name variable lets say initialised. Like I said the id is generated in hibernate when saving to the table. The id is never in my code. I need a quick way to get the last record from the table. Thanks for the help, should have made this clearer at the time.

pksiv · **Posted:** Thu Oct 20, 2005 9:10 am

mmcallis wrote:

Yeah should have gave more info sorry. My cat object has a getId but id in the table is of type sequence, so getId() would return null, as the cat object only has the name variable lets say initialised. Like I said the id is generated in hibernate when saving to the table. The id is never in my code. I need a quick way to get the last record from the table. Thanks for the help, should have made this clearer at the time.

If Hibernate is generating the ID, it will set the value on your object.

If you just want the highest ID #, you can SELECT MAX(ID) FROM YOUR_TABLE.

mmcallis · **Joined:** Thu Oct 20, 2005 7:21 am **Posts:** 4

Ah thanks didn't realise Hibernate would have updated the values of the object, thought it would have left the object unchanged. Brilliant thanks.
Michael.