Hi all,

I have a class like

class Bar{

Integer a;
String b;
java.util.Date timestamp;

}

When I want to create a new record in database, I have a sql like this

insert into tableBar (colA,colB, colTimestamp) values(?,?,sysdate).


Now with hibernate, how can I config the mapping file to let the generated sql use 'sysdate' instead of the value of the timestamp of the Bar object?


thanks,

I don't think you can. The point of hibernate is to avoid using database lingo in your java code (IMHO). If you want to manage date on the java side, just create a new date, and set the field. Or, use the <timestamp> property, and let hibernate do it for you.

If you want to set w/ db time, a trigger is prob the best bet (oracle)...

If you want it to use sysdate only on insert, probably the best approach would be to give the column a defined default of sysdate and to map that particular property with its "insert" attribute set to false.

Hi Steve,

How to
? use formula? can you give me an example?

thanks.

thanks jlawmi and steve.

yes we can create a trigger for it, but it is just too heavy to use for such a simple problem.

i more like steve's idea, but don't know how.

step #1, add a default value to the table column:
CREATE TABLE my_table (
my_column DATE DEFAULT SYSDATE
);

(or use the ALTER command if your unable to recreate the table)


step #2, in your mapping for this property in Hibernate define the property as not insertable in which case Hibernate will not include it in the insert column list (which is needed for default values to be applied).

<property name="myDateProperty" insert="false" .../>


But like I said, this only works if sysdate should only be used for default insert value (i.e., not updated on update).