From: thhal at mailblocks.com (Thomas Hallgren) Date: Tue, 15 Mar 2005 18:58:49 +0100 Subject: [Pljava-dev] Re: Failed to create Java VM In-Reply-To: References: <4235D3C2.4050408@mailblocks.com> <4235E3DD.8020104@mailblocks.com> <4237057E.3080407@mailblocks.com> <42372259.7040107@mailblocks.com> Message-ID: Thomas Hallgren wrote: > 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). > Hmm, I think I can answer my own question here. What happens is that you first get the error: 1 is outside the valid range for parameter "pljava.statement_cache_size" (0 .. 0) Then you do a renewed attempt in the same session. That's when you get: attempt to redefine parameter "pljava.vmoptions" You get this since it was succesfully set on the first attempt but then failed on the statement_cache_size. If I'm correct then just remove the setting of the pljava.statement_cache_size. Regards, Thomas Hallgren