[Pljava-dev] Problem with PL/Java installation

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://lists.pgfoundry.org/pipermail/pljava-dev/attachments/20060124/66f76d99/attachment.html>