Re: PL/Java 1.5.1_BETA2 - Mailing list pgsql-pkg-debian

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
tojava.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