From: contact at synthesegraphique.com (=?ISO-8859-1?Q?Synth=E8se_Graphique?=)
Date: Sun, 12 Feb 2006 14:14:04 +0100
Subject: [Pljava-dev] Error executing : sqlj.install_jar on windows XP Pro
Message-ID: <9bd07b0a0154ed920dae4ba18abaf40f@synthesegraphique.com>

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
--------------------------------------