agora inbox for pljava-dev@postgresql.org
help / color / mirror / Atom feedSubject: [Pljava-dev] could not load library "C:/Program Files/PostgreSQL/8.2/lib/pljava.dll"
Date: Sat, 20 Oct 2007 13:23:43 +0900
Message-ID: <20071020123616.49B5.QUANZONGLIANG@gmail.com> (raw)
In-Reply-To: <65B6F244586C4632AF7578A9A0382608@davidnew>
References: <65B6F244586C4632AF7578A9A0382608@davidnew>
add two entries to PATH:
%JRE_HOME%\bin;%JRE_HOME%\bin\client;
and try again
Good lucky.
-----------------------------------------------
Zongliang Quan
quanzongliang at gmail.com,quanzongliang at hotmail.com
On Fri, 19 Oct 2007 14:41:01 +0100
"David JL Gradwell" <David at Gradwell.com> wrote:
> Hi,
>
> I have installed PostgreSQL 8.2.5.1 on Windows 2003 server and am trying again to get PLJava to work. (Failed with similar problems with PostgreSQL 8.2.1.
>
> I’ve carefully followed:
>
> file:///C:/Program%20Files/PostgreSQL/8.2/doc/PlJava/readme.html
>
> When I run deployer I get:
>
> org.postgresql.util.PSQLException: ERROR: could not load library "C:/Program Files/PostgreSQL/8.2/lib/pljava.dll": The specified module could not be found.
>
> at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1548)
> at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1316)
> at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:191)
> at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
> at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:337)
> at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:329)
> at org.postgresql.pljava.deploy.Deployer.initJavaHandlers(Deployer.java:474)
> at org.postgresql.pljava.deploy.Deployer.main(Deployer.java:269)
>
>
> Line 474 of Deployer.java and the next few:
>
> stmt.execute(
> "CREATE FUNCTION sqlj.java_call_handler()" +
> " RETURNS language_handler" +
> " AS 'pljava'" +
> " LANGUAGE C");
>
> Statements up to this point have worked OK. The PostgreSQL installation is fine and runs other programs OK.
>
> I’ve tried setting the PATH variable to: C:/Program Files/PostgreSQL/8.2/lib/
> I’ve tried setting dynamic_library_path = 'C://pljavalib' in postgresql.conf to a different directory and putting a copy of the pljava.dll file (which is definitely in C:/Program Files/PostgreSQL/8.2/lib/ and comes as part of the PostgreSQL 8.2.5.1 install) in the newly created directory. I then get a different error message – saying it can’t load from the new directory.
>
> Help please !
>
> David Gradwell
>
view thread (5+ messages)
Message-ID: <20071020123616.49B5.QUANZONGLIANG@gmail.com>
Permalink: ../20071020123616.49B5.QUANZONGLIANG@gmail.com/
Also on: postgresql.org/message-id/20071020123616.49B5.QUANZONGLIANG@gmail.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] could not load library "C:/Program Files/PostgreSQL/8.2/lib/pljava.dll"
In-Reply-To: <20071020123616.49B5.QUANZONGLIANG@gmail.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