Re: [Pljava-dev] install_jar error

On 30/05/2017 08:27, Antonio Giuzio wrote:
> Hi,
> i’m trying to install a jar but i get the follow errors:
>
> select sqlj.install_jar('file:///Users/antonio/GitHub/distanceJavaSQL/dist/distanceJavaSQL.jar', 'distance', true);
> WARNING: java.lang.NoClassDefFoundError: org/postgresql/pljava/internal/Backend
> WARNING: Unable to load class org/postgresql/pljava/internal/Backend using CLASSPATH '-Djava.class.path=/Users/antonio/Library/Application Support/Postgres/var-9.5/pljava-pg9.5-x86_64-MacOSX-gpp.jar'
> WARNING: failed to load initial PL/Java classes
> HINT: The most common reason is that "pljava.classpath" needs to be set, naming the proper "pljava.jar" file.
> WARNING: failed to create Java virtual machine
> DETAIL: JNI_CreateJavaVM returned an error code: -1
> HINT: Because an earlier attempt during this session did start a VM before failing, this probably means your Java runtime environment does not support more than one VM creation per session. You
> may need to exit this session and start a new one.
> ERROR: cannot use PL/Java before successfully completing its setup
>
>
> In postgresql.conf, I added this rows
>
> PLJAVA.CLASSPATH='/Users/antonio/Library/Application Support/Postgres/var-9.5/pljava-pg9.5-x86_64-MacOSX-gpp.jar'
> PLJAVA.VMOPTIONS='-Xms512m -Xmx1064m -Xshare:off -XX:ParallelGCThreads=2'
> PLJAVA.LIBJVM_LOCATION='/Library/Java/JavaVirtualMachines/jdk1.8.0_65.jdk/Contents/Home/jre/lib/jli/libjli.dylib’
>
In 1.6 the old pljava postgresql.conf settings were removed. pljava.libjvm_location is what you need and this should point to your libjvm shared object.
What version of pljava do you use? Did you use the extension ?
>
> how can i solve?
> Thanks
>
>
> _______________________________________________
> Pljava-dev mailing list
> Pljava-dev(at)lists(dot)pgfoundry(dot)org
> http://lists.pgfoundry.org/mailman/listinfo/pljava-dev

--
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt