update timestamp

ms · **Joined:** Wed Jan 25, 2006 10:18 am **Posts:** 28

I've got a timestamp property that simply needs to be automatically updated on every insert or update. I guess what I need is this:
http://opensource.atlassian.com/project ... se/ANN-441

If I don't use any detached instances anywhere, is it safe to use @Version instead? I don't want any actual version checking from Hibernate, I want the "last-commit-wins strategy".

emmanuel · **Posted:** Sun Jan 21, 2007 9:01 pm

a user type can do the trick, @Version is not what you want

ms · **Joined:** Wed Jan 25, 2006 10:18 am **Posts:** 28

Do you mean something like this?

Code:

   public void nullSafeSet(PreparedStatement st, Object value, int index)
      throws HibernateException, SQLException
   {
      Date now = new Date();
      Hibernate.TIMESTAMP.nullSafeSet(st, now, index);
   }

But how can I make the db generate the timestamp instead?

Thanks!

emmanuel · **Posted:** Wed Jan 24, 2007 3:03 pm

ah, then you need ANN-411, if you're interested in providing a patch (it should not be too complex), let me know.

ms · **Joined:** Wed Jan 25, 2006 10:18 am **Posts:** 28

Ok, thanks.
I don't yet feel comfortable enough with Hibernate to dig into the source and provide a patch. For now, I'll just wait until someone else needs it more than I do and fixes it. ;)