[Pljava-dev] PostgreSQL 8.1 Pljava install problem

Hi Thomas,

I did successful install pljava on my computer (Windows XP) thank to
you.
But when I installed it on server (windows 2000 Sp4) I got same error.
Only deference I found is I am running Java 1.5 on my PC and java
1.4.2_09 on server.
Can be this a problem??

Michael

-----Original Message-----
From: Thomas Hallgren [mailto:thomas at tada.se]
Sent: Wednesday, March 15, 2006 2:49 PM
To: Shulman, Michael
Cc: pljava-dev at gborg.postgresql.org
Subject: Re: [Pljava-dev] PostgreSQL 8.1 Pljava install problem

Michael,
Michael,

There are two requirements that must be met:
1. The libpljava.dll must be at the expected location. In your case
"C:/PostgreSQL_8.1/lib/libpljava.dll"
2. The bin and bin\client directories of your JRE installation must be
in the PATH that is in effect for the postmaster backend.

That's all there is to it. If those settings are correct, you will not
get the error.

My guess is that you run PostgreSQL as a service and your PATH setting
is local (i.e. not visible to the postmaster service). The PATH must be
in effect for the service. I.e. you have to set it either as a System
environment setting or as an environment setting for the account that
runs that service.

Regards,
Thomas Hallgren

Shulman, Michael wrote:
> Thank you for answer.
> I did this and got same result
>
> Best wishes,
> Michael
>
> -----Original Message-----
> From: Thomas Hallgren [mailto:thomas at tada.se]
> Sent: Wednesday, March 15, 2006 1:53 PM
> To: Shulman, Michael
> Cc: pljava-dev at gborg.postgresql.org
> Subject: Re: [Pljava-dev] PostgreSQL 8.1 Pljava install problem
>
>
> Hi Michael,
> Take a look at http://wiki.tada.se/display/pljava/Installation+Guide
>
> Pay special attention to 'Shared Object issues' and the Windows PATH
> setting (it must include two important directories from your Java
> installation).
>
> Kind regards,
> Thomas Hallgren
>
> Shulman, Michael wrote:
>
>> Hi
>> I have installed PostrgeSQL 8.1 with pljava.
>> When I try to run install.sql script I got this error
>> "ERROR: could not load library
>> "C:/PostgreSQL_8.1/lib/libpljava.dll":
>> The specified module could not be found."
>> Please advice
>>
>> Mike
>> _______________________________________________
>> Pljava-dev mailing list
>> Pljava-dev at gborg.postgresql.org
>> http://gborg.postgresql.org/mailman/listinfo/pljava-dev
>>
>>
>
>

Shulman, Michael wrote:
> Hi Thomas,
>
> I did successful install pljava on my computer (Windows XP) thank to
> you.
> But when I installed it on server (windows 2000 Sp4) I got same error.
> Only deference I found is I am running Java 1.5 on my PC and java
> 1.4.2_09 on server.
> Can be this a problem??
>
>

No, that's not very likely. The same PL/Java binary can use either version.

Regards,
Thomas Hallgren

> Michael
>
> -----Original Message-----
> From: Thomas Hallgren [mailto:thomas at tada.se]
> Sent: Wednesday, March 15, 2006 2:49 PM
> To: Shulman, Michael
> Cc: pljava-dev at gborg.postgresql.org
> Subject: Re: [Pljava-dev] PostgreSQL 8.1 Pljava install problem
>
>
> Michael,
> Michael,
>
> There are two requirements that must be met:
> 1. The libpljava.dll must be at the expected location. In your case
> "C:/PostgreSQL_8.1/lib/libpljava.dll"
> 2. The bin and bin\client directories of your JRE installation must be
> in the PATH that is in effect for the postmaster backend.
>
> That's all there is to it. If those settings are correct, you will not
> get the error.
>
> My guess is that you run PostgreSQL as a service and your PATH setting
> is local (i.e. not visible to the postmaster service). The PATH must be
> in effect for the service. I.e. you have to set it either as a System
> environment setting or as an environment setting for the account that
> runs that service.
>
> Regards,
> Thomas Hallgren
>
>
>
> Shulman, Michael wrote:
>
>> Thank you for answer.
>> I did this and got same result
>>
>> Best wishes,
>> Michael
>>
>> -----Original Message-----
>> From: Thomas Hallgren [mailto:thomas at tada.se]
>> Sent: Wednesday, March 15, 2006 1:53 PM
>> To: Shulman, Michael
>> Cc: pljava-dev at gborg.postgresql.org
>> Subject: Re: [Pljava-dev] PostgreSQL 8.1 Pljava install problem
>>
>>
>> Hi Michael,
>> Take a look at http://wiki.tada.se/display/pljava/Installation+Guide
>>
>> Pay special attention to 'Shared Object issues' and the Windows PATH
>> setting (it must include two important directories from your Java
>> installation).
>>
>> Kind regards,
>> Thomas Hallgren
>>
>> Shulman, Michael wrote:
>>
>>
>>> Hi
>>> I have installed PostrgeSQL 8.1 with pljava.
>>> When I try to run install.sql script I got this error
>>> "ERROR: could not load library
>>> "C:/PostgreSQL_8.1/lib/libpljava.dll":
>>> The specified module could not be found."
>>> Please advice
>>>
>>> Mike
>>> _______________________________________________
>>> Pljava-dev mailing list
>>> Pljava-dev at gborg.postgresql.org
>>> http://gborg.postgresql.org/mailman/listinfo/pljava-dev
>>>
>>>
>>>
>>
>>
>
>

Hi,
I was looking back on this thread because I am trying to re-install with
8.1 and pljava 1.2 on suse 9.3 desktop linux. I followed all the
instructions on the wiki. Got postgres 8.1.3 installed fine. Built
pljava 1.2.0, installed fine. Put the pljava.jar and everything in
build/objs/* into /usr/share/pljava (documentation needs clarity here).
My postmaster has jvm in path and I updated my LD_LIBRARY_PATH to
include /usr/share/pljava and did a /sbin/ldconfig.

Added the following lines to my .conf file
---
dynamic_library_path ='$libdir;/usr/share/pljava'

custom_variable_classes = 'pljava'
pljava.classpath='/usr/share/pljava.jar'
---

I get this error when running deployer:

postgres at ninja:/home/darren/postgres> java -cp
./postgresql-8.1dev-401.jdbc3.jar:pljava-1.2.0/build/deploy.jar
org.postgresql.pljava.deploy.Deployer -install
org.postgresql.util.PSQLException: ERROR: invalid macro name in dynamic
library path: $libdir;/usr/share/pljava
at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1499)
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1284)
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:175)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:429)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:334)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:326)
at org.postgresql.pljava.deploy.Deployer.initJavaHandlers(Deployer.java:432)
at org.postgresql.pljava.deploy.Deployer.main(Deployer.java:275)

So I removed the $libdir part and tried again. I get:

postgres at ninja:/home/darren/postgres> java -cp
./postgresql-8.1dev-401.jdbc3.jar:pljava-1.2.0/build/deploy.jar
org.postgresql.pljava.deploy.Deployer -install
org.postgresql.util.PSQLException: ERROR: could not load library
"/usr/share/pljava/libpljava.so": /usr/share/pljava/libpljava.so:
undefined symbol: GetCurrentAbsoluteTimeUsec
at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1499)
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1284)
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:175)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:429)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:334)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:326)
at org.postgresql.pljava.deploy.Deployer.initJavaHandlers(Deployer.java:432)

Any tips greatly appreciated!

Cheers,
Darren

I got it to work. One has to be extra careful the shared libraries get
overwritten if they're installing over a prior version.

Sorry for the extra emails....

Darren

Darren Govoni wrote:
> Hi,
> I was looking back on this thread because I am trying to re-install with
> 8.1 and pljava 1.2 on suse 9.3 desktop linux. I followed all the
> instructions on the wiki. Got postgres 8.1.3 installed fine. Built
> pljava 1.2.0, installed fine. Put the pljava.jar and everything in
> build/objs/* into /usr/share/pljava (documentation needs clarity here).
> My postmaster has jvm in path and I updated my LD_LIBRARY_PATH to
> include /usr/share/pljava and did a /sbin/ldconfig.
>
> Added the following lines to my .conf file
> ---
> dynamic_library_path ='$libdir;/usr/share/pljava'
>
> custom_variable_classes = 'pljava'
> pljava.classpath='/usr/share/pljava.jar'
> ---
>
> I get this error when running deployer:
>
> postgres at ninja:/home/darren/postgres> java -cp
> ./postgresql-8.1dev-401.jdbc3.jar:pljava-1.2.0/build/deploy.jar
> org.postgresql.pljava.deploy.Deployer -install
> org.postgresql.util.PSQLException: ERROR: invalid macro name in dynamic
> library path: $libdir;/usr/share/pljava
> at
> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1499)
> at
> org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1284)
> at
> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:175)
> at
> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:429)
> at
> org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:334)
> at
> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:326)
> at org.postgresql.pljava.deploy.Deployer.initJavaHandlers(Deployer.java:432)
> at org.postgresql.pljava.deploy.Deployer.main(Deployer.java:275)
>
> So I removed the $libdir part and tried again. I get:
>
> postgres at ninja:/home/darren/postgres> java -cp
> ./postgresql-8.1dev-401.jdbc3.jar:pljava-1.2.0/build/deploy.jar
> org.postgresql.pljava.deploy.Deployer -install
> org.postgresql.util.PSQLException: ERROR: could not load library
> "/usr/share/pljava/libpljava.so": /usr/share/pljava/libpljava.so:
> undefined symbol: GetCurrentAbsoluteTimeUsec
> at
> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1499)
> at
> org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1284)
> at
> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:175)
> at
> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:429)
> at
> org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:334)
> at
> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:326)
> at org.postgresql.pljava.deploy.Deployer.initJavaHandlers(Deployer.java:432)
>
>
> Any tips greatly appreciated!
>
> Cheers,
> Darren
>
>
> _______________________________________________
> Pljava-dev mailing list
> Pljava-dev at gborg.postgresql.org
> http://gborg.postgresql.org/mailman/listinfo/pljava-dev
>
>