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

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

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
>

Hi Thomas,

You are very active on this mailing list, even Synday !

The fact is I had allready installed Oracle 9i that also uses Java.
So to avoid this kind of conflit, I installed a second WXP (without
Oracle), but Oracle directories still are visible.

I am now scanning all disks to find this older pljava.dll.
But, when I find it, what should I do ?

Thks,

Olivier Peaucelle
--------------------------------------
Le 12 f?vr. 06, ? 14:23, Thomas Hallgren a ?crit :

> 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

Olivier,
You should make sure that:
- The 'dynamic_library_path' configuration variable in your
postgresql.conf includes the location of the pljava.dll.
- The 'pljava.classpath' configuration variable in your postgresql.conf
is the full path of the pljava.jar.
- The appointed dll and jar must stem from the same PL/Java installation.
- You should *not* have a CLASSPATH setting that is visible to the
backend (i.e. no CLASSPATH system environment setting).
- Your PATH setting must include the bin and bin/client of the JRE
installation (so your present setting is correct in that respect).

Everything else is irrelevant to PL/Java.

Regards,
Thomas Hallgren

Synth?se Graphique wrote:
> Hi Thomas,
>
> You are very active on this mailing list, even Synday !
>
> The fact is I had allready installed Oracle 9i that also uses Java.
> So to avoid this kind of conflit, I installed a second WXP (without
> Oracle), but Oracle directories still are visible.
>
> I am now scanning all disks to find this older pljava.dll.
> But, when I find it, what should I do ?
>
> Thks,
>
> Olivier Peaucelle
> --------------------------------------
> Le 12 f?vr. 06, ? 14:23, Thomas Hallgren a ?crit :
>
>
>> 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
>>
>
> _______________________________________________
> Pljava-dev mailing list
> Pljava-dev at gborg.postgresql.org
> http://gborg.postgresql.org/mailman/listinfo/pljava-dev
>

I have not any pljava.dll on any directory !
I only have a libpljava.dll in c:\pljava.

Where does this dll comes from ?

Olivier Peaucelle
--------------------------------------

Le 12 f?vr. 06, ? 15:04, Thomas Hallgren a ?crit :

> Olivier,
> You should make sure that:
> - The 'dynamic_library_path' configuration variable in your
> postgresql.conf includes the location of the pljava.dll.
> - The 'pljava.classpath' configuration variable in your
> postgresql.conf is the full path of the pljava.jar.
> - The appointed dll and jar must stem from the same PL/Java
> installation.
> - You should *not* have a CLASSPATH setting that is visible to the
> backend (i.e. no CLASSPATH system environment setting).
> - Your PATH setting must include the bin and bin/client of the JRE
> installation (so your present setting is correct in that respect).
>
> Everything else is irrelevant to PL/Java.
>
> Regards,
> Thomas Hallgren
>
> Synth?se Graphique wrote:
>> Hi Thomas,
>>
>> You are very active on this mailing list, even Synday !
>>
>> The fact is I had allready installed Oracle 9i that also uses Java.
>> So to avoid this kind of conflit, I installed a second WXP (without
>> Oracle), but Oracle directories still are visible.
>>
>> I am now scanning all disks to find this older pljava.dll.
>> But, when I find it, what should I do ?
>>
>> Thks,
>>
>> Olivier Peaucelle
>> --------------------------------------
>> Le 12 f?vr. 06, ? 14:23, Thomas Hallgren a ?crit :
>>
>>
>>> 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
>>>
>>
>> _______________________________________________
>> Pljava-dev mailing list
>> Pljava-dev at gborg.postgresql.org
>> http://gborg.postgresql.org/mailman/listinfo/pljava-dev
>>
>
>

Sorry, libpljava.dll is the one I meant. Not pljava.dll. It's part of
the PL/Java distribution. Somehow, that file is from another PL/Java
distribution then the pljava.jar file that is used.

- thomas

Synth?se Graphique wrote:
> I have not any pljava.dll on any directory !
> I only have a libpljava.dll in c:\pljava.
>
> Where does this dll comes from ?
>
> Olivier Peaucelle
> --------------------------------------
>
> Le 12 f?vr. 06, ? 15:04, Thomas Hallgren a ?crit :
>
>
>> Olivier,
>> You should make sure that:
>> - The 'dynamic_library_path' configuration variable in your
>> postgresql.conf includes the location of the pljava.dll.
>> - The 'pljava.classpath' configuration variable in your
>> postgresql.conf is the full path of the pljava.jar.
>> - The appointed dll and jar must stem from the same PL/Java
>> installation.
>> - You should *not* have a CLASSPATH setting that is visible to the
>> backend (i.e. no CLASSPATH system environment setting).
>> - Your PATH setting must include the bin and bin/client of the JRE
>> installation (so your present setting is correct in that respect).
>>
>> Everything else is irrelevant to PL/Java.
>>
>> Regards,
>> Thomas Hallgren
>>
>> Synth?se Graphique wrote:
>>
>>> Hi Thomas,
>>>
>>> You are very active on this mailing list, even Synday !
>>>
>>> The fact is I had allready installed Oracle 9i that also uses Java.
>>> So to avoid this kind of conflit, I installed a second WXP (without
>>> Oracle), but Oracle directories still are visible.
>>>
>>> I am now scanning all disks to find this older pljava.dll.
>>> But, when I find it, what should I do ?
>>>
>>> Thks,
>>>
>>> Olivier Peaucelle
>>> --------------------------------------
>>> Le 12 f?vr. 06, ? 14:23, Thomas Hallgren a ?crit :
>>>
>>>
>>>
>>>> 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
>>>>
>>>>
>>> _______________________________________________
>>> Pljava-dev mailing list
>>> Pljava-dev at gborg.postgresql.org
>>> http://gborg.postgresql.org/mailman/listinfo/pljava-dev
>>>
>>>
>>
>
> _______________________________________________
> Pljava-dev mailing list
> Pljava-dev at gborg.postgresql.org
> http://gborg.postgresql.org/mailman/listinfo/pljava-dev
>

Ok, so :

> - The 'dynamic_library_path' configuration variable in your
> postgresql.conf includes the location of the pljava.dll.
this point is ok : dynamic_library_path = '$libdir;c:\\pljava'
> - The 'pljava.classpath' configuration variable in your
> postgresql.conf is the full path of the pljava.jar.
this point is ok : pljava.classpath = 'c:\\pljava\\pljava.jar'
> - The appointed dll and jar must stem from the same PL/Java
> installation.
they are from the same downloaded file
> - You should *not* have a CLASSPATH setting that is visible to the
> backend (i.e. no CLASSPATH system environment setting).
OK, deleted
> - Your PATH setting must include the bin and bin/client of the JRE
> installation (so your present setting is correct in that respect).
I think its ok like : 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

I dont know how to set de CLASSPATH on windows plateform as required in
PL/Java Readme.

Should I open a dos window and enter :
set classpath=c:\pljava

Olivier Peaucelle

Le 12 f?vr. 06, ? 19:05, Thomas Hallgren a ?crit :

> Sorry, libpljava.dll is the one I meant. Not pljava.dll. It's part of
> the PL/Java distribution. Somehow, that file is from another PL/Java
> distribution then the pljava.jar file that is used.
>
> - thomas

Synth?se Graphique wrote:
> I dont know how to set de CLASSPATH on windows plateform as required in
> PL/Java Readme.
>
> Should I open a dos window and enter :
> set classpath=c:\pljava
>
>

With the settings you've described, your backend process should be all
set. You don't need a CLASSPATH and you should make sure the backend
doesn't see a classpath. Your environment settings can be edited using
the control panel (System -> Advanced -> Environment Variables). The
System variables are of particular interest to you. If you have a
CLASSPATH there, then you should probably remove it.

The client programs (like the deploy program) will use a classpath but
you can add that on the command line. Like so:

java -cp <classpath to jdbc driver and deploy.jar>
org.postgresql.pljava.deploy.Deployer -install

Regards,
Thomas Hallgren