Hi,

I have an application that synchronizes a set of objects between a server DB and mobile PDA DBs. I use hibernate for persistency. I need to implement some way of tagging an object with a unique 'stamp' on every change(database update) in order to be able to detect which objects must I send to the PDA. What is the best way of doing this?

I'm thinking of using an interceptor and in the onFlushDirty() to use a sequenceGenerator to generate a new unique 'stamp' if the object is changed. Is there a better way of doing this?

Thanks

The best and safiest way is using a trigger at the DB level

I forgot to tell you that I'm using a second level cache.
Wouldn't this be a problem in using triggers? How can I be sure that the value is properly read from DB after an update?

You need that timestamp at the Java level?

You'll need to refresh() the object after the update occurs