From: Christoph Berg <myon@debian.org>
To: Chapman Flack <chap@anastigmatix.net>
Cc: pljava-dev@lists.pgfoundry.org <pljava-dev@lists.pgfoundry.org>
Cc: pgsql-pkg-debian@postgresql.org
Cc: pgsql-pkg-yum@postgresql.org
Subject: Re: PL/Java 1.5.2 - fixes one regression in date conversion in 1.5.1
Date: Tue, 6 Nov 2018 08:49:31 +0100
Message-ID: <20181106074931.GB3898@msg.df7cb.de> (raw)
In-Reply-To: <5BE08D74.2060207@anastigmatix.net>
References: <5BE08D74.2060207@anastigmatix.net>
Re: Chapman Flack 2018-11-05 <5BE08D74.2060207@anastigmatix.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=jes...
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-pkg-debian@postgresql.org
Cc: myon@debian.org, chap@anastigmatix.net, pljava-dev@lists.pgfoundry.org, pgsql-pkg-yum@postgresql.org
Subject: Re: PL/Java 1.5.2 - fixes one regression in date conversion in 1.5.1
In-Reply-To: <20181106074931.GB3898@msg.df7cb.de>
References: <5BE08D74.2060207@anastigmatix.net> <20181106074931.GB3898@msg.df7cb.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox