My hbm.xml file:

<property name="startDate" type="timestamp" formula="(select sysdate from dual)">
<column length="7" name="START_DATE"/>



My Query:

Query query=session.createQuery("Select U.startDate from UsercertificationDetails U");
List dateList=query.list();
Date startDate=(Date)dateList.get(0);
System.out.println("Date is: "+startDate);

This is printing the correct syatem date with correct time.

ob.setDate(startDate); //I assigned the startDate into an object.
System.out.println(ob.getDate); //The valus has been uploaded into object.

then i gave
session.save(ob);


ob have someother values also.
In database all the other values in ob has been successfully uploaded except startDate.

Can somebody help me to solve this?

Change the hbm file property.

Set default="sysdate" and insert="false".
Then the sysdate will be inserted into table.

hi admirer,
I have done the same thing which you have written below. Me too faced the same problem. But what I have done after it is, I created one extra property and given the formula. and save that date to the column.

please find the code which I have pasted in below URL

http://stackoverflow.com/questions/7499 ... -hibernate


Thanks & Regards
Naveen