Hello

Possibly a quick question.

I am mapping a MySql datetime field to a java.util.Date field but only the date part is being set, I lose all time information from the DB.

My field is:

Name: due
Datatype: DATETIME

My mapping line is:

<property name="dateDue" type="date" column="due"/>


I have two rows. The due field is set to:

2005-08-02 10:22:00
2005-08-02 10:23:00

So I end up with java.util.Date objects, both with the date as 2005-08-02 but the time part is blank. If I print dueDate.getTime() I end up with:

1122850800000
1122850800000

So the milliseconds is the same for both objects.

Can anyone help me please?

MySql: 4.1.9
Hibernate: 3.0.5
MySql Driver: MySql connector 3.0.14

Many thanks in advance.

Map your DateTime column to java.sql.Timestamp as follows:

<property name="dateDue" type="java.sql.Timestamp" column="due"/>

You will also need to change the data type in your class files accordingly.

Super, that worked, thankyou.

Seems strange that DATETIME doesnt include a time :)

You can also use java.util.Calendar as mapping type. Each Sun document insist upon the fact that java.util.Date is... out of date ;)