[Pljava-dev] Problem with PL/Java installation -

agora inbox for pljava-dev@postgresql.org  
help / color / mirror / Atom feed
Subject: [Pljava-dev] Problem with PL/Java installation
Date: Tue, 24 Jan 2006 10:49:39 +0100
Message-ID: <43D5F833.30900@tada.se> (raw)
In-Reply-To: <631AA2476DFFD047873427369B8C0698023FE1DA@teasgex1.teasin.com>
References: <631AA2476DFFD047873427369B8C0698023FE1DA@teasgex1.teasin.com>

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
>   

view thread (9+ messages)  latest in thread

Message-ID: <43D5F833.30900@tada.se>
Permalink:  ../43D5F833.30900@tada.se/
Also on:    postgresql.org/message-id/43D5F833.30900@tada.se

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pljava-dev@postgresql.org
  Subject: Re: [Pljava-dev] Problem with PL/Java installation
  In-Reply-To: <43D5F833.30900@tada.se>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox