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

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
>