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

From: contact at synthesegraphique(dot)com ( Synthèse Graphique )
To:
Subject: [Pljava-dev] Error executing : sqlj.install_jar on windows XP Pro
Date: 2006-02-12 13:14:04
Message-ID: 9bd07b0a0154ed920dae4ba18abaf40f@synthesegraphique.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pljava-dev

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

Responses

Browse pljava-dev by date

  From Date Subject
Next Message Thomas Hallgren 2006-02-12 13:23:24 [Pljava-dev] Error executing : sqlj.install_jar on windows XP Pro
Previous Message Patrick Ng 2006-02-07 07:56:14 [Pljava-dev] Problem with PL/Java installation