Hibernate 4 with java.time.LocalDate and DATE() construct

Question

I'm trying to use LocalDate and LocalDateTime with Java 8 in my app. I'm using Hibernate 4.3.5 and Spring. I followed this interesting tutorial here and all works but I've a problem when I use DATE() construct. When I try to do: ``` SELECT * FROM TABLE WHERE DATE(data)=DATE(:data) ``` I've always an empty list also if the query I made manually (copy and past query Hibernate print) works fine. I think that the problem is the conversion that Hibernate do internally; it try to convert LocalDate to java.util.Date. I tell this because if I change the query in this way: ``` SELECT * FROM TABLE WHERE DATE(data)=:data ``` I've this exception: ``` java.lang.IllegalArgumentException: Parameter value [2014-05-27T00:00] did not match expected type [java.util.Date (n/a)] at org.hibernate.jpa.spi.BaseQueryImpl.validateBinding(BaseQueryImpl.java:885) at org.hibernate.jpa.internal.QueryImpl.access$000(QueryImpl.java:80) at org.hibernate.jpa.internal.QueryImpl$ParameterRegistrationImpl.bindValue(Query…

Accepted Answer

If you use JPA 2.1 this is simple to do. Converters allow your JPA entities to use the new `java.time.LocalDate` and `java.time.LocalDateTime` classes. Simply define the needed converter classes: LocalDatePersistenceConverter.java ``` import java.time.LocalDate; import javax.persistence.AttributeConverter; import javax.persistence.Converter; @Converter public class LocalDatePersistenceConverter implements AttributeConverter { @Override public java.sql.Date convertToDatabaseColumn(LocalDate entityValue) { if (entityValue != null) { return java.sql.Date.valueOf(entityValue); } return null; } @Override public LocalDate convertToEntityAttribute(java.sql.Date databaseValue) { if (databaseValue != null) { return databaseValue.toLocalDate(); } return null; } } ``` LocalDateTimePersistenceConverter.java ``` import java.time.LocalDateTime; import javax.persistence.AttributeConverter; import javax.persistence.Converter; @Converter public class LocalDateTimePersistenceConverter implements AttributeConverter { @Override public java.sql.Timestamp convertToDatabaseColumn(LocalDateTime entityValue) { if (entityValue != null) { return java.sql.Timestamp.valueOf(entityValue); } return null; } @Override public LocalDateTime convertToEntityAttribute(java.sql.Timestamp databaseValue) { if (databaseValue != null) { return databaseValue.toLocalDateTime(); } return null; } } ``` And then annotate the appropriate entity property with the @Converter annotation: ``` @Convert(converter = LocalDatePersistenceConverter.class) private LocalDate completedDate; ``` Update September 2015 Hibernate 5 natively supports the java 8 Date/Time APIs. Just ensure that the hibernate-java8 jar is on your class path.

Hibernate 4 with java.time.LocalDate and DATE() construct

Solution

Problem