| package entity; ... public class GMTDateEntity implements Serializable { ... private Integer pk; private Calendar calendar; @Id @Column(name = "pk", nullable = false) @GeneratedValue(strategy = GenerationType.IDENTITY) public Integer getPk() { return pk; } @Temporal(TemporalType.TIMESTAMP) @Column(name = "calendartime") public Calendar getCalendar() { return calendar; } public void setCalendar(Calendar calendar) { //create new calendar in GMT time zone this.calendar = new GregorianCalendar(TimeZone.getTimeZone("GMT")); //set calendar fields this.calendar.set(Calendar.YEAR, calendar.get(Calendar.YEAR)); this.calendar.set(Calendar.MONTH, calendar.get(Calendar.MONTH)); this.calendar.set(Calendar.DATE, calendar.get(Calendar.DATE)); this.calendar.set(Calendar.HOUR_OF_DAY, calendar.get(Calendar.HOUR_OF_DAY)); this.calendar.set(Calendar.MINUTE, calendar.get(Calendar.MINUTE)); this.calendar.set(Calendar.SECOND, calendar.get(Calendar.SECOND)); this.calendar.set(Calendar.MILLISECOND, calendar.get(Calendar.MILLISECOND)); //recalculate calendar time millis this.calendar.getTime(); } ... } |
| package usertypes; import java.io.Serializable; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Types; import java.text.ParseException; import java.text.SimpleDateFormat; import java.util.Calendar; import java.util.Date; import java.util.GregorianCalendar; import java.util.TimeZone; import org.hibernate.Hibernate; import org.hibernate.HibernateException; import org.hibernate.usertype.UserType; public class GmtCalendarUserType implements UserType, Serializable { private static final long serialVersionUID = 1L; //The interesting methods: @Override public void nullSafeSet(PreparedStatement statement, Object value, int index) throws HibernateException, SQLException { // we have to be null-safe if (value == null) { Hibernate.CALENDAR.nullSafeSet(statement, null, index); return;
}
// we have a Calendar here Calendar cal = (Calendar) value; // cut millis, as SQL Server uses only 1/300 precision long millis = cal.getTimeInMillis(); millis = millis - (millis % 1000); cal.setTimeInMillis(millis); // simply delegate to hibernate's built in method Hibernate.CALENDAR.nullSafeSet(statement, cal, index); } @Override public Object nullSafeGet(ResultSet resultSet, String[] columnNames, Object owner) throws HibernateException, SQLException { // we cannot do it like this, because it would initialize the calendar // in the jvm's default timezone: // Calendar cal = (Calendar) Hibernate.CALENDAR.nullSafeGet(resultSet, // columnNames); // return cal; // We have to create the Calendar object from the DB date string String timeString = (String) Hibernate.STRING.nullSafeGet(resultSet, columnNames); if (timeString == null) return null; try { Date date = this.parseDbDateString(timeString); // Init calendar in GMT Calendar retValue = new GregorianCalendar( TimeZone.getTimeZone("GMT")); retValue.setTime(date); // calculate calendar fields retValue.getTime(); return retValue; } catch (ParseException e) { throw new HibernateException("Could not parse datestring from DB.", e); } } private Date parseDbDateString(String dateString) throws ParseException { // create gmt time zone TimeZone gmtZone = TimeZone.getTimeZone("GMT"); // create db date format (cut millis) String pattern = "yyyy-MM-dd HH:mm:ss"; SimpleDateFormat dateFormat = new SimpleDateFormat(pattern); dateFormat.setTimeZone(gmtZone); return dateFormat.parse(dateString); } //The other UserType methods: @Override public Object assemble(Serializable cached, Object owner) throws HibernateException { return this.deepCopy(cached); } @Override public Object deepCopy(Object object) throws HibernateException { if (object == null) return null; // we have a calendar here Calendar cal = (Calendar) object; return cal.clone(); } @Override public Serializable disassemble(Object value) throws HibernateException { return (Serializable) this.deepCopy(value); } @Override public boolean equals(Object object1, Object object2) throws HibernateException { if (object1 == object2) { return true; } if ((object1 == null) || (object2 == null)) return false; return object1.equals(object2); } @Override public int hashCode(Object value) throws HibernateException { return value.hashCode(); } @Override public boolean isMutable() { // Calendar is mutable return true; } @Override public Object replace(Object original, Object target, Object owner) throws HibernateException { return this.deepCopy(original); } @Override public Class return Calendar.class; } @Override public int[] sqlTypes() { return new int[] { Types.TIMESTAMP }; } } |
| package entity; ... @Entity @Table(name = "datetestgmt") //Declare the UserType on the class @TypeDef(name = "gmtCalendar", typeClass = GmtCalendarUserType.class) public class GMTDateEntity implements Serializable { ... //Use the UserType on the attribute @Type(type = "gmtCalendar") @Column(name = "calendartime") private Calendar calendar; ... } |
