From: thomas at tada.se (Thomas Hallgren)
Date: Tue, 24 Jan 2006 10:49:39 +0100
Subject: [Pljava-dev] Problem with PL/Java installation
In-Reply-To: <631AA2476DFFD047873427369B8C0698023FE1DA@teasgex1.teasin.com>
References: <631AA2476DFFD047873427369B8C0698023FE1DA@teasgex1.teasin.com>
Message-ID: <43D5F833.30900@tada.se>

Patrick,
There are normally two accounts involved, your client account that 
executes the command at the DOS prompt and the account that runs the 
PostgreSQL postmaster service (or standalone process depending on your 
configuration).

The two accounts need different settings. I guess the settings that you 
echo are only related to the first account (client).

The client account should not have a CLASSPATH that includes pljava.jar 
since the classes contained therein are solely for execution in the 
server. The PATH of the client account should not include the <jre 
home>\bin\client and <jre home>\bin paths. Those are only used by the 
server.

The server account should normally not have a CLASSPATH at all besides 
the one noted in your postgresql.conf file.
The PATH setting of the server account is the one that must include <jre 
home>\bin\client and <jre home>\bin paths.

I would strongly advice you to remove any references to the Oracle jre 
from both PATH's.

Finally, verify that your server account have permission to execute the 
libpljava.dll.

Regards,
Thomas Hallgren


Patrick Ng wrote:
>
> Hi,
>
>  
>
> The settings in my postgresql.conf is as follows :
>
>  
>
> pljava.classpath='C:\\PostgreSQL\\share\\pljava\\pljava.jar'
>
>  
>
> dynamic_library_path = '$libdir;C:\\PostgreSQL\\lib'
>
>  
>
> Here is the error that I got at DOS command prompt :
>
>  
>
> C:\>java org.postgresql.pljava.deploy.Deployer -install -database 
> metaphysics -u
>
> ser postgres -password pncs6601
>
> org.postgresql.util.PSQLException: ERROR: could not load library 
> "C:/PostgreSQL/
>
> lib/libpljava.dll": Access is denied.
>
>  
>
>         at 
> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryEx
>
> ecutorImpl.java:1512)
>
>         at 
> org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutor
>
> Impl.java:1297)
>
>         at 
> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.ja
>
> va:188)
>
>         at 
> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Stat
>
> ement.java:430)
>
>         at 
> org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(Abstract
>
> Jdbc2Statement.java:332)
>
>         at 
> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Stat
>
> ement.java:324)
>
>         at 
> org.postgresql.pljava.deploy.Deployer.initJavaHandlers(Deployer.java:
>
> 432)
>
>         at org.postgresql.pljava.deploy.Deployer.main(Deployer.java:275)
>
>  
>
> C:\>echo %CLASSPATH%
>
> C:\PostgreSQL\share\pljava\deploy.jar;C:\PostgreSQL\jdbc\postgresql-8.1-404.jdbc
>
> 2.jar;C:\PostgreSQL\share\pljava\pljava.jar
>
>  
>
> C:\>echo %PATH%
>
> D:\Oracle\product\10.1.0\Client_1\bin;D:\Oracle\product\10.1.0\Client_1\jre\1.4.
>
> 2\bin\client;D:\Oracle\product\10.1.0\Client_1\jre\1.4.2\bin;C:\WINDOWS\system32
>
> ;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program 
> Files\Java\jre1.5.0_06\bin\clien
>
> t;C:\Program Files\Java\jre1.5.0_06\bin;C:\PostgreSQL\bin
>
>  
>
>  
>
> Could you advise what went wrong ?
>
>  
>
> Best regards
>
>  
>
> Patrick
>
>  
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> Pljava-dev mailing list
> Pljava-dev at gborg.postgresql.org
> http://gborg.postgresql.org/mailman/listinfo/pljava-dev
>