Greetings,

I've been looking for a way to use hibernate to insert DB-generated datetime/timestamp data in more than one column. The scenario is that there are several tables in a legacy system which have both "Created Date" and "Updated Date" columns, which are populated with the DMBS time (SYSDATE in this case, as it's Oracle 8i) on insert or update, respectively.

Having investigated the documentation fairly thoroughly, it doesn't appear that this behaviour can be implemented using Hibernate, as it appears that only one timestamp column is supported. I've seen other posts where the use of triggers is recommended, but this is not an option in this case.

If anyone has had any luck with this kind of scenario, I'd be happy to hear from you.

Many thanks,

Tom Crossland.

P.S. I'm not the only one who wants this weird feature. See also: http://groups.google.com/group/comp.lang.java.programmer/browse_thread/thread/c36ccf06e9800e67/ca9f6e6faf604f91?#ca9f6e6faf604f91