PostgreSQL date converted to Java Date instead of LocalDate

Question

Using JOOQ 3.10.1, I believe that the javaTimeTypes flag is on by default for the code generator.

I have a table in a PostgreSQL database with a date column and a time with time zone column:

the time with time zone column becomes an OffsetDateTime in the record class, as expected.
the date becomes java.sql.Date in the record class when I would have expected a LocalDate.

Am I missing anything here?

Don't know if it will help, but there is something about converters here, including a LocalDateConverter : jooq.org/doc/3.7/manual/sql-building/queryparts/custom-bindings . — Arnaud
– Arnaud, Commented Oct 16, 2017 at 15:27
That's what I have been using before 3.10 indeed but it should not be necessary any longer. — assylias
– assylias, Commented Oct 16, 2017 at 15:30

Lukas Eder · Accepted Answer · 2017-10-17 07:55:11Z

1

Using JOOQ 3.10.1, I believe that the javaTimeTypes flag is on by default for the code generator.

Here's the specification: https://www.jooq.org/xsd/jooq-codegen-3.10.0.xsd

<element name="javaTimeTypes" type="boolean" default="false" minOccurs="0" maxOccurs="1">..

So, no, it is not turned on by default.

the time with time zone column becomes an OffsetDateTime in the record class, as expected.

That's because there's no other type that can meaningfully represent the time with time zone data type.

answered Oct 17, 2017 at 7:55

Lukas Eder

224k138 gold badges731 silver badges1.6k bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

assylias Over a year ago

Mmm - worst bit is probably that I did check the xsd and concluded that it defaulted to true - probably need to ask an optician instead of stackoverflow! All sorted thanks.

Lukas Eder Over a year ago

@assylias: Well, now it's documented here as well for future visitors who might not know that the XSD exists :)

Collectives™ on Stack Overflow

PostgreSQL date converted to Java Date instead of LocalDate

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related