attribute of type java.time.LocalDateTime doesn't work as a JPA query parameter in Hibernate

Question

I have an JPA entity with an attribute of type java.time.LocalDateTime. I use a javax.persistence.Converter annotation for this to work. I can load the entity and save it without problems, but when I try to execute a jpql query like this:

TypedQuery<Event> q = em.createQuery(
    "SELECT e " +
    "FROM Event e " +
    "WHERE :currentDateTime >= e.startDateTime", Event.class);
q.setParameter("currentDateTime", LocalDateTime.now().withSecond(0).withNano(0));

I get an error like this:

Caused by: org.postgresql.util.PSQLException: ERROR: operator does not exist: bytea >= timestamp without time zone

I've tried many things but couldn't get the parameter to work. I even tried to use java.util.Date and java.util.Calendar as the parameter but it also doesn't work.

Answer 1

I've seen in the comment that you want to query Timestamp

q.setParameter("currentDateTime", new Date(), TemporalType.TIMESTAMP)

So your converter must be LocalDateTime⇔Timestamp

I've done this with Hibernate as a JPA provider, and my code looks like this in my AttributeConverter<LocalDateTime, Timestamp>

@Override
public Timestamp convertToDatabaseColumn(LocalDateTime date) {
    if (date == null) {
        return null;
    } else {
        return Timestamp.valueOf(date);
    }
}

@Override
public LocalDateTime convertToEntityAttribute(Timestamp value) {
    if (value == null) {
        return null;
    } else {
        return value.toLocalDateTime();
    }
}