Re: PL/Java 1.5.1_BETA2

Re: To Chapman Flack 2018-09-16 <20180916201808(dot)GA30681(at)msg(dot)df7cb(dot)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