Most Exalted Ones,

My app has a number of large tables that are constantly updated by a backend C++ process. I need to get only the most recently added record.

How can I do this through hibernate without getting the entire recordset? Hibernate doesn't do the inserts, so I can't use the last_insert or whatever it's called.

thanks in advance!

I should add that I need the most recently added record for EACH table. Otherwise I could just use the mySQL last_insert_id function.

thanks again

Add timestamp type field, and select record from mytable where mytime = (select max(mytime) from mytable).

or "select record from mytable order by mytime desc limit 1"

Thanks from a fellow Lithuanian for both of your helpful suggestions! Any prediction which query might be faster?

I am not sure about mysql, but "select record from mytable order by mytime desc limit 1" works faster on postgresql (some versions do not use index for "max", but sort by index without problems)