File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes Object Relational Mapping and the fly likes mapping column of Date type Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "mapping column of Date type" Watch "mapping column of Date type" New topic
Author

mapping column of Date type

ben oliver
Ranch Hand

Joined: Mar 28, 2006
Posts: 374
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
Ranch Hand

Joined: Mar 08, 2007
Posts: 1585
Hi,

Here's an example:



Regards,


Vassili ...
SCJP 5.0, SCWCD 1.4, SCJA 1.0
Cameron Wallace McKenzie
author and cow tipper
Saloon Keeper

Joined: Aug 26, 2006
Posts: 4968
    
    1

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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: mapping column of Date type
 
Similar Threads
Repeated updates on EVENT table, in Hibernate one to many mapping
Composite foreign key causing "object is not an instance of declaring class"?
HIBERNATE hql.ast.QuerySyntaxException: (table name) is not mapped
Hibernate App Issue
why not ?