[Pljava-dev] Problem with PL/Java installation

[Patrick Ng]

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

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://pgfoundry.org/pipermail/pljava-dev/attachments/20060124/66f76d99/attachment.html