[Pljava-dev] install_jar error

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: pljava-dev

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

Responses

Browse pljava-dev by date

  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?