play 1.4.x Java 8 Time Persistence, Binding

[hans]

Hi,

I've been doing some workarouns for using java 8 time API in play 1.4.2. May be useful for others. The next field declaration works for binding an persistence:

@Type(type = "localDateTime")
@As(binder = LocalDateTimeBinder.class)
public LocalDateTime from;

For persistence, in any Entity it's possible to declare the EnhancedUserTypes:

@Entity
@TypeDefs({ @TypeDef(name = "localDate", typeClass = utiles.jpa.LocalDateUserType.class),
        @TypeDef(name = "localTime", typeClass = utiles.jpa.LocalTimeUserType.class),
        @TypeDef(name = "localDateTime", typeClass = utiles.jpa.LocalDateTimeUserType.class), })
public class MyClass extends Model {

And then the declaration of the classes implementing EnhancedUserType:

public class LocalDateTimeUserType implements EnhancedUserType, Serializable {

    private static final int[] SQL_TYPES = new int[] { Types.TIMESTAMP };

    @Override
    public int[] sqlTypes() {
        return SQL_TYPES;
    }

    @Override
    public Class returnedClass() {
        return LocalDateTime.class;
    }

    @Override
    public boolean equals(Object x, Object y) throws HibernateException {
        if (x == y) {
            return true;
        }
        if (x == null || y == null) {
            return false;
        }
        LocalDateTime dtx = (LocalDateTime) x;
        LocalDateTime dty = (LocalDateTime) y;
        return dtx.equals(dty);
    }

    @Override
    public int hashCode(Object object) throws HibernateException {
        return object.hashCode();
    }

    @Override
    public Object nullSafeGet(ResultSet resultSet, String[] names, SessionImplementor session, Object owner)
            throws HibernateException, SQLException {
        Object timestamp = StandardBasicTypes.TIMESTAMP.nullSafeGet(resultSet, names, session, owner);
        if (timestamp == null) {
            return null;
        }
        Date ts = (Date) timestamp;
        Instant instant = Instant.ofEpochMilli(ts.getTime());
        return LocalDateTime.ofInstant(instant, ZoneId.systemDefault());
    }

    @Override
    public void nullSafeSet(PreparedStatement preparedStatement, Object value, int index, SessionImplementor session)
            throws HibernateException, SQLException {
        if (value == null) {
            StandardBasicTypes.TIMESTAMP.nullSafeSet(preparedStatement, null, index, session);
        } else {
            LocalDateTime ldt = ((LocalDateTime) value);
            Instant instant = ldt.atZone(ZoneId.systemDefault()).toInstant();
            Date timestamp = Date.from(instant);
            StandardBasicTypes.TIMESTAMP.nullSafeSet(preparedStatement, timestamp, index, session);
        }
    }

    @Override
    public Object deepCopy(Object value) throws HibernateException {
        return value;
    }

    @Override
    public boolean isMutable() {
        return false;
    }

    @Override
    public Serializable disassemble(Object value) throws HibernateException {
        return (Serializable) value;
    }

    @Override
    public Object assemble(Serializable cached, Object value) throws HibernateException {
        return cached;
    }

    @Override
    public Object replace(Object original, Object target, Object owner) throws HibernateException {
        return original;
    }

    @Override
    public String objectToSQLString(Object object) {
        throw new UnsupportedOperationException();
    }

    @Override
    public String toXMLString(Object object) {
        return object.toString();
    }

    @Override
    public Object fromXMLString(String string) {
        return LocalDateTime.parse(string);
    }

}


For binding in controllers:

@Global
public class LocalDateTimeBinder implements TypeBinder<LocalDateTime> {

    public Object bind(String name, Annotation[] annotations, String value, Class actualClass, Type genericType) {

        LocalDateTime ldt = localDateTimeFromString(value);
        return ldt;
    }
}

The function to parse the date:

    public static LocalDateTime localDateTimeFromString(String s) {

        if (s.length() == 10)
            s += " 00:00";

        return LocalDateTime.parse(s, formatterLong);
    }


Bye
Hans