What are your experiences with date types (DATE, TIME, DATETIME) using CDO with the Hibernate store? Are there any known best practices?
In my case, I would like to the database columns to be created with the respective types (DATE, TIME, DATETIME). From a coding point of view it would probably be the easiest to work with java.util.Date or java.util.Calendar. The model should automatically discard unwanted information (i.e. the TIME information for a DATE field).
There are lots of possibilities, including but not limited to:
- using EDate and setting the column type in the mapping
- wrapping java.util.Date or java.util.Calendar
- wrapping Long as in java.util.Date.getTime
- using XMLGregorianCalendar
Any pointers on how to get started are most welcome