From: | David at Gradwell(dot)com (David JL Gradwell) |
---|---|
To: | |
Subject: | [Pljava-dev] could not load library "C:/Program Files/PostgreSQL/8.2/lib/pljava.dll" |
Date: | 2007-10-19 13:41:01 |
Message-ID: | 65B6F244586C4632AF7578A9A0382608@davidnew |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pljava-dev |
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
<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(QueryExecutorI
mpl.java:1548)
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.ja
va:1316)
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:191)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.j
ava:452)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2St
atement.java:337)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.j
ava: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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.pgfoundry.org/pipermail/pljava-dev/attachments/20071019/b04cb440/attachment.html>
From | Date | Subject | |
---|---|---|---|
Next Message | Quan Zongliang | 2007-10-20 04:23:43 | [Pljava-dev] could not load library "C:/Program Files/PostgreSQL/8.2/lib/pljava.dll" |
Previous Message | Thomas Hallgren | 2007-10-12 10:57:04 | [Pljava-dev] Release? |