From: patrick.ng at zuji.com (Patrick Ng)
Date: Wed, 25 Jan 2006 10:25:01 +0800
Subject: [Pljava-dev] Problem with PL/Java installation
Message-ID: <631AA2476DFFD047873427369B8C0698023FE50B@teasgex1.teasin.com>

Hey,

Thanks a lot for the explanation. It sure out things in very clear
perspective.

Anyway, I was running the client and server within the same PC so the
settings for CLASSPATH and PATH didn't really matter (but still, the
explanation above makes me see things in a different light)

I took all the ORACLE stuff out from the PATH setting. It worked.

Thanks a lot.

Btw : I am new to PL/Java. Can you point me to some site /book where
there are examples that show PL/Java in PostgreSQL in action.

Thanks alot

-----Original Message-----
From: Thomas Hallgren [mailto:thomas at tada.se] 
Sent: Tuesday, January 24, 2006 5:50 PM
To: Patrick Ng
Cc: pljava-dev at gborg.postgresql.org
Subject: Re: [Pljava-dev] Problem with PL/Java installation

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
>   


________________________________________________________________________
This email has been scanned for all viruses by the MessageLabs Email
Security System.