From: | Antonio Giuzio <antonio(dot)giuzio(at)hotmail(dot)it> |
---|---|
To: | |
Subject: | [Pljava-dev] install_jar error |
Date: | 2017-05-30 05:27:27 |
Message-ID: | HE1PR0301MB257221C1116275C119BE50A3E6F00@HE1PR0301MB2572.eurprd03.prod.outlook.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | Postg토토 베이SQL : Postg토토 베이SQL 메일 링리스트 : 2017-05-30 이후 Pljava-Dev 05:27 |
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’
how can i solve?
Thanks
From | Date | Subject | |
---|---|---|---|
Next Message | Achilleas Mantzios | 2017-05-30 13:39:45 | Re: [Pljava-dev] install_jar error |
Previous Message | John R Pierce | 2017-05-03 07:59:25 | Re: [Pljava-dev] postgres 9.6 and pljava? |