From: thomas at tada.se (Thomas Hallgren)
Date: Sun, 12 Feb 2006 14:23:24 +0100
Subject: [Pljava-dev] Error executing : sqlj.install_jar on windows XP
 Pro
In-Reply-To: <9bd07b0a0154ed920dae4ba18abaf40f@synthesegraphique.com>
References: <9bd07b0a0154ed920dae4ba18abaf40f@synthesegraphique.com>
Message-ID: <43EF36CC.7010909@tada.se>

Hi Olivier,
To my knowledge, the only way this can happen is if there's a version 
discrepancy between pljava.jar and pljava.dll. Somehow they stem from 
different versions of PL/Java so it's likely that your PL/Java 
installation is corrupt. Perhaps you have an older version of pljava.dll 
lingering somewhere on your system?

Kind regards,
Thomas Hallgren


Synth?se Graphique wrote:
> Hello,
>
> According to my configuration, system environnement variables are :
>
> 	CLASSPATH = c:\pljava
> 	PATH =  
> %SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem;C: 
> \Program Files\ATI Technologies\ATI Control Panel;C:\Program  
> Files\ZipGenius 6\;c:\pljava;C:\Program  
> Files\Java\jre1.5.0_06\bin\client;C:\Program  
> Files\Java\jre1.5.0_06\bin;C:\Program Files\Java\jre1.5.0_06\lib\i386
>
> In postgresql.conf file, I set :
>
> 	dynamic_library_path = '$libdir;c:\\pljava'
> 	log_min_messages = info
> 	custom_variable_classes = 'pljava'
> 	pljava.classpath = 'c:\\pljava\\pljava.jar'
>
> I have installed PL/JAVA thanks to C:\pljava\install.sql script
>
> BUT, when I run
>
> 	SELECT sqlj.install_jar('file:///c/pljava/examples.jar', 'samples',   
> true);
>
> within pgAdmin III query window, I get the following error :
>
> 	ERROR:  Unable to register native methods
>
> In postgresql-[date].log I can see following message :
>
> 	in thread "main" java.lang.NoSuchMethodError:_addEOXactListener
>
> I think that CLASSPATH may not be sean by postgres user. I don't know  
> how to do it.
>
> Please help me. In advance, thanks.
>
> Olivier Peaucelle
> --------------------------------------
>
> _______________________________________________
> Pljava-dev mailing list
> Pljava-dev at gborg.postgresql.org
> http://gborg.postgresql.org/mailman/listinfo/pljava-dev
>