[Pljava-dev] Error executing : sqlj.install_jar on windows XP Pro

Synthèse Graphique contact at synthesegraphique.com
Sun Feb 12 13:14:04 UTC 2006


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




More information about the Pljava-dev mailing list