public inbox for [email protected]  

help / color / mirror / Atom feed

From: Achilleas Mantzios <[email protected]>
Subject: Re: [Pljava-dev] install_jar error
Date: Tue, 30 May 2017 16:39:45 +0300
Message-ID: <[email protected]> (raw)
In-Reply-To: <HE1PR0301MB257221C1116275C119BE50A3E6F00@HE1PR0301MB2572.eurprd03.prod.outlook.com>
References: <HE1PR0301MB257221C1116275C119BE50A3E6F00@HE1PR0301MB2572.eurprd03.prod.outlook.com>

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
> [email protected]
> http://lists.pgfoundry.org/mailman/listinfo/pljava-dev


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


_______________________________________________
Pljava-dev mailing list
[email protected]
http://lists.pgfoundry.org/mailman/listinfo/pljava-dev

view thread (3+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected]
  Subject: Re: [Pljava-dev] install_jar error
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox