Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version:

Mapping documents:

Code between sessionFactory.openSession() and session.close():

Full stack trace of any exception that occurs:

Name and version of the database you are using:SQL SERver

The generated SQL (show_sql=true):

Debug level Hibernate log excerpt:

I want to know how to enter system date in a datetime field in sqlserver database.When i insert the object of the table the object is having null value for the required date field as it has to be system date.I am new to hibernate so want to know how i can insert a system date into the table

It worked for inserting date for one time.
To modify date everytime any action is done is used
<timestamp column="LastModDt" name="lastModDate" type="timestamp" source="vm" />
and defined my property as a Date with getter and setters.

Iam getting the following errror
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1455)
Caused by:
org.xml.sax.SAXParseException: Attribute "type" must be declared for element type "timestamp".

Could you please help me

My approach for this sort of field depends on whether or not the field has to be updated on every write.

If the field is set once and only once, on initial row creation, then map the field with insert="false" update="false", and set the DB default value for the column to be the system date (that's getdate() for SQLServer, though that varies by DBMS).

If the field has to be updated every time the row is modified, then use the hibernate <timestemp> element. See refdocs, section 5.1.8.

Thanks for your help I have one more question

I got it to working for one time insert by using the following code
<property name="createDate" column="createDate" type="java.util.Date" update="false" insert="false"/>

to insert every time a record is modified didnt work
<timestamp column="LastModDt" name="lastModDate" type="timestamp" />
and defined lastmoddate property as date property in the object
I am getting the following erro:
org.xml.sax.SAXParseException: Attribute "type" must be declared for element type "timestamp".

Can you please help me

To store a date information everytime a record is modified, I suggest have another column called updateDate created in your schema. Values will be updated in such column with the following in your mapping file.


Remember having update="false" on a property will not update that column everytime.



<timestamp> element doesnt have "type" attribute defined in hibernate-mapping-3.0.dtd file. So remove the "type" attribute from the element. This will remove the SAXParseException.

If I define like this my database column is becoming null when I do an update or insert.
I need to enter the system date when record is modified or inserted.How can i do that???
<property name="updateDate" column="updateDate" type="java.util.Date" />

This kind of declaration is working fine with me. Declaring type="java.util.Date" should not make such difference, as working in my case and not working in your case. Dont know why? Its beyond my knowledge. Posting your code how you are modifying and persisting to DB will help in coming to an explanation.

Using a <property type="timestamp"> means that the time that goes into the database is the java VM time: you have to put the current time into the object before saving/updating. This is usually not appropriate, though if it's good enough for you, then great.

If you use <timestamp use=db="true"> (or equivalently, <version type="dbtimestamp">), then the time is generated by the DB server, and that's usually better.