Errors using TIMESTAMP WITH TIMEZONE with JOOQ/H2/Postgres
I’ve recently changed my columns from “TIMESTAMP” to “TIMESTAMP WITH TIMEZONE”.
Normally I would have a model class that would have a “LocalDateTime” but now I’ve changed to include timezone I use an “OffsetDateTime” to match the type used in the generated code by JOOQ.
How can I map a Java Instants to H2 TIMESTAMP WITH TIME ZONE using jOOQ?
Using Postgres I am able to force TIMESTAMPTZ columns to map to Instant with a forced type in the jOOQ mapping