Error with timestamp in postgres using Spring Data: column $COLUMN_NAME is of type timestamp without time zone but expression is of type bytea

Question

Using the following:

Oracle JDK 1.8.0._171

Spring boot 1.5.9-RELEASE

Postgresql 9.6

Postgres driver: 42.2.4

Getting the error from following definition:

Table column: sql meal_time TIMESTAMP DEFAULT now() NOT NULL

Entity attribute definition: java @Column(name = "meal_time", nullable=false) private Instant mealTime = Instant.now();

Whenever I try to flush or query the entity throws the error:

Caused by: org.postgresql.util.PSQLException: ERROR: column "meal_time" is of type timestamp without time zone but expression is of type bytea
  Hint: You will need to rewrite or cast the expression.

I could write a converter for this field but there should be a standard way and it feels like I am missing something as looking around for examples I found very close implementations that actually work.

Answer 1

After some research I've found this page, Using Java 8 Date and Time classes from official postgres documentation and changed the property type to be LocalDateTime instead of Instant:

java @Column(name = "meal_time", nullable = false) private LocalDateTime mealTime = LocalDateTime.now();

This fixed the issue and was an acceptable solution in this specific project.