Hello,

I am currently evaluating Hiberanate for my current project and have a question. My current application has a create and last update date for each of its tables and I would like to use a static formula for the insert and update.

1) DB Triggers - Would like to avoid.
2) Hibernate Interceptors - Would not work because it is vital that the time used is the db time. ie systimestamp.
3) Here is the real question, can this be done on a property or column level? Such that the resulting PreparedStatement looks something like....INSERT INTO FOO (ID, NAME, CR_DATE, LAST_UPD) VALUES (?, ?, systimestamp, systimestamp). I realize that I could use native <sql-insert> but I would like to avoid the overhead of maintaining that.

Regards,
Ryan Lynch

what about using timestamp (versionning) for last modification date?

about creation date.... easy to do in java

>what about using timestamp (versionning) for last modification date?
I will look into that, thanks.

>about creation date.... easy to do in java
Yes, I agree that it is easy but it is important that the value be set to the database time for two reasons
1) Same clock for all values.
2) The actual time of the creation is when it gets inserted by the database not when the object is created or the insert call is made by the client.

Also I would image there are other use cases that may require a value be set using a known db function.

Anthony, thanks for your response.