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 16:50:44 +0800
Message-ID: <631AA2476DFFD047873427369B8C0698023FE1DA@teasgex1.teasin.com> (raw)

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;

view thread (9+ messages)  latest in thread

Message-ID: <631AA2476DFFD047873427369B8C0698023FE1DA@teasgex1.teasin.com>
Permalink:  ../631AA2476DFFD047873427369B8C0698023FE1DA@teasgex1.teasin.com/
Also on:    postgresql.org/message-id/631AA2476DFFD047873427369B8C0698023FE1DA@teasgex1.teasin.com

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: <631AA2476DFFD047873427369B8C0698023FE1DA@teasgex1.teasin.com>

* 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