Received: from malur.postgresql.org ([2a02:16a8:dc51::56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1g1ddr-0000gL-GP for pgsql-pkg-debian@arkaria.postgresql.org; Sun, 16 Sep 2018 20:27:39 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1g1ddp-0002PR-MI for pgsql-pkg-debian@arkaria.postgresql.org; Sun, 16 Sep 2018 20:27:37 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1g1ddp-0002PK-E6 for pgsql-pkg-debian@lists.postgresql.org; Sun, 16 Sep 2018 20:27:37 +0000 Received: from feynman.df7cb.de ([195.49.152.168]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1g1ddm-0006kJ-Rc for pgsql-pkg-debian@postgresql.org; Sun, 16 Sep 2018 20:27:36 +0000 Received: from msg.df7cb.de (unknown [IPv6:2a02:908:1470:e5c0:76e5:bff:fef3:7e00]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (Client did not present a certificate) by feynman.df7cb.de (Postfix) with ESMTPSA id 42D15d30hsz3Dx0; Sun, 16 Sep 2018 22:27:33 +0200 (CEST) Date: Sun, 16 Sep 2018 22:27:33 +0200 From: Christoph Berg To: Chapman Flack , pgsql-pkg-debian@postgresql.org Subject: Re: PL/Java 1.5.1_BETA2 Message-ID: <20180916202733.GB30681@msg.df7cb.de> Mail-Followup-To: Christoph Berg , Chapman Flack , pgsql-pkg-debian@postgresql.org References: <5B96B226.2080803@anastigmatix.net> <20180915203221.GA19015@msg.df7cb.de> <5B9D73A2.2090402@anastigmatix.net> <20180916201808.GA30681@msg.df7cb.de> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20180916201808.GA30681@msg.df7cb.de> User-Agent: Mutt/1.10.1 (2018-07-13) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Re: To Chapman Flack 2018-09-16 <20180916201808.GA30681@msg.df7cb.de> > On stretch/amd64, install_jar fails on 9.6 (9.3/4/5 worked): > > 20:07:05 + psql -c 'CREATE EXTENSION pljava' > 20:07:05 CREATE EXTENSION > 20:07:05 + psql -c 'SELECT sqlj.install_jar('\''file:/usr/share/postgresql/9.6/pljava/pljava-examples-1.5.1-BETA2.jar'\'', '\''examples'\'', true)' > [...] > 20:07:07 INFO: 16 Sep 18 18:07:07 org.postgresql.pljava.management.Commands Type id = OID(16686) > 20:07:07 ERROR: java.lang.ClassNotFoundException: org.postgresql.pljava.example.annotation.ComplexTuple > 20:07:07 CONTEXT: SQL statement "SELECT javatest.assertHasValues( CAST('(1,2)' AS javatest.complextuple), 1, 2)" > > https://pgdgbuild.dus.dg-i.net/job/postgresql-pljava-binaries/3/architecture=amd64,distribution=stretch/ The problem on bionic/amd64 is similar, here 9.4 fails after 9.3 passed the tests: 20:06:37 + psql -c 'SELECT sqlj.install_jar('\''file:/usr/share/postgresql/9.4/pljava/pljava-examples-1.5.1-BETA2.jar'\'', '\''examples'\'', true)' [...] 20:06:38 ERROR: java.lang.ClassNotFoundException: org.postgresql.pljava.example.annotation.Point 20:06:38 CONTEXT: SQL statement "SELECT javatest.assertHasValues(CAST('(1,2)' AS point), 1, 2)" https://pgdgbuild.dus.dg-i.net/job/postgresql-pljava-binaries/3/architecture=amd64,distribution=bionic/console Also, does it have to be that verbose all the time, even if things worked? This was all on openjdk-8. On jessie/amd64, openjdk-7 is used: 20:22:24 + java -Dpgsql.pgconfig=/usr/lib/postgresql/9.3/bin/pg_config -Dpgconfig.pkglibdir=debian/postgresql-9.3-pljava/usr/lib/postgresql/9.3/lib -Dpgconfig.sharedir=debian/postgresql-9.3-pljava/usr/share/postgresql/9.3 -jar build-9.3/pljava-pg9.3-amd64-Linux-gpp.jar 20:22:25 Exception in thread "main" java.lang.ClassCastException: sun.org.mozilla.javascript.ConsString cannot be cast to java.lang.String 20:22:25 at org.gjt.cuspy.JarX.extract(JarX.java:670) 20:22:25 at org.gjt.cuspy.JarX.extract(JarX.java:445) 20:22:25 at org.gjt.cuspy.JarX.main(JarX.java:419) https://pgdgbuild.dus.dg-i.net/job/postgresql-pljava-binaries/3/architecture=amd64,distribution=jessie/console The full set of dist/architecture combinations can be see at https://pgdgbuild.dus.dg-i.net/job/postgresql-pljava-binaries/3/ Please tell me which issues you want a problem report on GitHub for :) Cheers, Christoph