From: thomas at tada.se (Thomas Hallgren)
Date: Wed, 15 Mar 2006 20:49:26 +0100
Subject: [Pljava-dev] PostgreSQL 8.1 Pljava install problem
In-Reply-To: <94A24C93CB808844ACB7444B3A188AB41AADCAA7@XMS.ad2.bu.edu>
References: <94A24C93CB808844ACB7444B3A188AB41AADCAA7@XMS.ad2.bu.edu>
Message-ID: <44186FC6.5020007@tada.se>

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