[b]Hibernate version: 2.1.6[/b]

[b]Name and version of the database you are using: Sybase 12.5[/b]

Hi,

I have a need to have my dataserver (Sybase 12.5) generate datetime values on insert / update of data. So, for example if I have an entity similar to:

MyEntity {
int a;
Date b;
}

I would expect b to be null, and populated with the result of a Sybase getdate() on insert and (optionally) on an update too. I've looked at the documentation for "timestamp" and "version" in the documentation but these don't appear to do exactly what I need.

I have also seen that "property" allows an attribute called "formula" that I can set to getdate(). However the result of this arbitrary SQL is *not* written to the database on insert or an update.

Any help would be greatly appreciated,

Scot

You would need to map the column as essentially read-only (insert="false" update="false") and then use a trigger/default in the db to set the value.

What happens when that column is part of the primary key? I'm working with a legacy system in DB2, and I have that problem. The table has a composite ID with a Timestamp column being part of it. The problem is, you can set "insert=false" in a "property" but you can't do that in a "key-property", even when the INSERT can be done without setting the value for the Timestamp beacause it has a default value set. Thanks in advance for your help.