Re: PL/Java 1.5.2 - fixes one regression in date conversion in 1.5.1

From: Christoph Berg <myon(at)debian(dot)org>
To: Chapman Flack <chap(at)anastigmatix(dot)net>
Cc: "pljava-dev(at)lists(dot)pgfoundry(dot)org" <pljava-dev(at)lists(dot)pgfoundry(dot)org>, pgsql-pkg-debian(at)postgresql(dot)org, pgsql-pkg-yum(at)postgresql(dot)org
Subject: Re: PL/Java 1.5.2 - fixes one regression in date conversion in 1.5.1
Date: 2018-11-06 07:49:31
Message-ID: 20181106074931.GB3898@msg.df7cb.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-pkg-debian pgsql-pkg-yum pljava-dev

Re: Chapman Flack 2018-11-05 <5BE08D74(dot)2060207(at)anastigmatix(dot)net>
> Before 1.5.1, PostgreSQL date, time, and timestamp values could be accessed
> in PL/Java as java.sql.Date, java.sql.Time, and java.sql.Timestamp objects.
> PL/Java 1.5.1 added the option of accessing those values as objects of new
> classes in the Java 8+ java.time package. The new classes are recommended as
> a superior API for accessing dates, times, and timestamps.
>
> However, one regression resulted in the older conversion between PostgreSQL
> date and java.sql.Date, leading to an error of one day for some dates of the
> year in some time zones. Release 1.5.2 restores the former behavior.

Hi,

1.5.2 doesn't build on Jessie and Trusty anymore (JDK 7):

https://pgdgbuild.dus.dg-i.net/job/postgresql-pljava-binaries/24/
https://pgdgbuild.dus.dg-i.net/job/postgresql-pljava-binaries/24/architecture=amd64,distribution=jessie/console

23:35:43 [ERROR] /<<PKGBUILDDIR>>/pljava-examples/src/main/java/org/postgresql/pljava/example/saxon/S9.java:[35,16] error: package java.time does not exist
23:35:43 [ERROR] /<<PKGBUILDDIR>>/pljava-examples/src/main/java/org/postgresql/pljava/example/saxon/S9.java:[879,12] error: cannot find symbol
23:35:43 [ERROR] symbol: variable TIME_WITH_TIMEZONE
23:35:43 [ERROR] location: class Types

(There is another issue that apparently maven doesn't like running
several times in parallel, it chokes while reading/writing to ~/.m2.)

I've also enabled -Psaxon-examples - is it correct that no new files
appear in the .deb, but the examples are inside the existing
/usr/share/postgresql/11/pljava/pljava-examples-1.5.2.jar file?

Christoph

In response to

Responses

Browse pgsql-pkg-debian by date

  From Date Subject
Next Message apt.postgresql.org repository 2018-11-06 11:25:58 patroni updated to version 1.5.1-1.pgdg+1
Previous Message Chapman Flack 2018-11-05 18:35:32 PL/Java 1.5.2 - fixes one regression in date conversion in 1.5.1

Browse pgsql-pkg-yum by date

  From Date Subject
Next Message Chapman Flack 2018-11-06 12:38:07 Re: PL/Java 1.5.2 - fixes one regression in date conversion in 1.5.1
Previous Message Chapman Flack 2018-11-05 18:35:32 PL/Java 1.5.2 - fixes one regression in date conversion in 1.5.1

Browse pljava-dev by date

  From Date Subject
Next Message Chapman Flack 2018-11-06 12:38:07 Re: PL/Java 1.5.2 - fixes one regression in date conversion in 1.5.1
Previous Message Chapman Flack 2018-11-05 18:35:32 PL/Java 1.5.2 - fixes one regression in date conversion in 1.5.1