mapping column of Date type

[ben oliver]

In oracle database tbale "EVENT" I have some columns of "DATE" type. In the hibernate mapping file I specify as

<propery name="event_date" column="EVENT_COLUMN"/>

In the POJO "Event" class I have

private java.util.Date event_date;

Howevere I found it didn't work properly. Do I have to a

type="date"

in the hibernate mapping file ? like

<propery name="event_date" type="date" column="EVENT_COLUMN"/>

??

[Vassili Vladimir]

Hi,

Here's an example:

    
        <property name="testTime" type="java.util.Date">
            <column name="test_time" length="19" not-null="true" />
        </property>

Regards,

[Cameron Wallace McKenzie]

You know, annotations make things so much easier.

@Temporal(TemporalType.TIMESTAMP)
public java.util.Date getLastAccessTime() {
return lastAccessTime;
}

@Temporal(TemporalType.DATE)
public java.util.Calendar getRegistrationDate() {
return registrationDate;
}

Performing Date and Time Column Mappings with Hibernate and JPA Annotations

DATE vs. TIME vs. TIMESTAMP

It's noteworthy to point out how the registrationDate column, which is annotated to be TemporalType.DATE, simply gets a year-month-day value, whereas the lastAccessTime column is populated with a full timestamp, including both the day and the time (TemporalType.TIME is the third option which would have simply saved the time, and not the calendar day). By the way, TemporalType.TIMESTAMP is the default if it isn't otherwise specified in your code.

-Cameron McKenzie