agora inbox for pljava-dev@postgresql.org  

help / color / mirror / Atom feed

Subject: [Pljava-dev] Re: Failed to create Java VM
Date: Tue, 15 Mar 2005 16:55:42 +0100
Message-ID: <thhal-0Ap4SA2HXxyc3IIhQ4l9cfcucza7ulU@mailblocks.com> (raw)
In-Reply-To: <opsnonrqc4n5ejfj@cornolio.innovationbusiness.net>
References: <opsnm2g4qmn5ejfj@cornolio.innovationbusiness.net>
	<4235D3C2.4050408@mailblocks.com>
	<opsnm5zz0kn5ejfj@cornolio.innovationbusiness.net>
	<4235E3DD.8020104@mailblocks.com>
	<opsnonrqc4n5ejfj@cornolio.innovationbusiness.net>
	<4237057E.3080407@mailblocks.com>
	<thhal-0AJ4SA1/Xxyc5P7pijk6ZctYijy4pOZ@mailblocks.com>

Bruno Domenici Ferreira wrote:
> Thomas, i've installed pljava by the source and the error now is:
> 
> ERROR:  attempt to redefine parameter "pljava.vmoptions"
> 
> See my postgresql.conf
> 
> <cut>
> # define "pljava" as a custom variable class. This is a comma separated
> # list of names.
> #
> custom_variable_classes = 'pljava'
> 
> # define the class path that the JVM will use when loading the
> # initial library. Only meaningful for non GJC installations
> #
> pljava.classpath = '/downloads/pljava-1.1.0b1/build/pljava.jar'
> pljava.classpath = '/usr/local/pgsql8/lib/postgresql.jar'
> 
> # Set the size of the prepared statement MRU cache
> #
> pljava.statement_cache_size = '1'
> 
> # If true, lingering savepoints will be released on function exit. If  
> false,
> # the will be rolled back
> #
> #pljava.release_lingering_savepoints = true
> 
> # Define startup options for the Java VM.
> #
> pljava.vmoptions = '-Xmx64M -Dbackchannel.port=48'
> 
> # Setting debug to true will cause the postgres process to go
> # into a sleep(1) loop on its first call to java. This is
> # only useful if you want to debug the PL/Java internal C code.
> #
> pljava.debug = true
> </cut>
> 
When do you get this error? Are you trying to do use the SQL SET command 
for pljava.vmoptions in a session where PL/Java is already active?

There's no way you can get it from settings in the postgresql.conf file 
since that file will allow multiple settings of the same custom variable 
(if it didn't you'd get this error for pljava.classpath since you set 
that twice).

Be adviced that numeric custom variables are broken at the moment. Thus, 
you will not be able to set the pljava.statement_cache_size.

Regards,
Thomas Hallgren

view thread (16+ messages)  latest in thread

Message-ID: <thhal-0Ap4SA2HXxyc3IIhQ4l9cfcucza7ulU@mailblocks.com>
Permalink:  ../thhal-0Ap4SA2HXxyc3IIhQ4l9cfcucza7ulU@mailblocks.com/
Also on:    postgresql.org/message-id/thhal-0Ap4SA2HXxyc3IIhQ4l9cfcucza7ulU@mailblocks.com

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: pljava-dev@postgresql.org
  Subject: Re: [Pljava-dev] Re: Failed to create Java VM
  In-Reply-To: <thhal-0Ap4SA2HXxyc3IIhQ4l9cfcucza7ulU@mailblocks.com>

* 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