agora inbox for pljava-dev@postgresql.org
help / color / mirror / Atom feed[Pljava-dev] could not load library "C:/Program Files/PostgreSQL/8.2/lib/pljava.dll" when running deployer on Windows
5+ messages / 0 participants
[nested] [flat]
* [Pljava-dev] could not load library "C:/Program Files/PostgreSQL/8.2/lib/pljava.dll" when running deployer on Windows
@ 2007-09-06 10:57
2007-09-06 20:37 ` [Pljava-dev] could not load library "C:/Program Files/PostgreSQL/8.2/lib/pljava.dll" when running deployer on Windows
2007-09-07 08:16 ` [Pljava-dev] could not load library "C:/Program Files/PostgreSQL/8.2/lib/pljava.dll" when running deployer on Windows
0 siblings, 2 replies; 5+ messages in thread
From: @ 2007-09-06 10:57 UTC (permalink / raw)
Hi,
I'm trying to install PLJava on PostgreSQL 8.2 running on Windows 2003
Server, using deploy.jar
I get the following exception on running deploy.jar:
ERROR: could not load library "C:/Program
Files/PostgreSQL/8.2/lib/pljava.dll": The specified module could not be
found.
I've tried most things I could think of including:
a) checking that the referenced file is in C:/Program
Files/PostgreSQL/8.2/lib/ (which it is)
b) taking the SQL commands from install.sql and feeding
them one by one to Postgres through my well proven "give it an SQL command
GUI" that uses JDBC. (It fails on CREATE FUNCTION sqlj.java_call_handler()
RETURNS language_handler AS 'pljava' LANGUAGE C with the above error)
c) setting the environment variable PATH to include the
above lib
d) following the instructions in the readme
(file:///C:/General%20Filing/P/Postgres/plJava/install%20stuff/docs/readme.h
tml
<file:///C:\General%20Filing\P\Postgres\plJava\install%20stuff\docs\readme.h
tml> )
especially adding the following entry to the postgresql.conf file:
pljava.classpath = <pljava installation>/pljava.jar
and the bit on PostMaster configuration
(dynamic_library_path = '$libdir:<pljava installation>'Note that on the
win32 platform you need to use a semicolon as a path separator and double
backslashes (since backslash is the escape character in the postgresql.conf
file) as directory separators.
Although whether I got this right I'm not sure - a Windows
example would be good ! I have succeeded in setting this to a different
folder and then get a correspondingly different error message pointing to
being unable to load from that folder.
My .bat to run deployer looked like this in the last attempt:
set javaPath=C:\Program Files\Java\jre1.6.0_02
set path=%javaPath%\bin;%path%
echo path is "%path%"
set CLASSPATH=C:\General Filing\P\Postgres\plJava\install
stuff\deploy.jar;C:\General Filing\P\Postgres\plJava\install
stuff\postgresql-8.2-505.jdbc3.jar
echo classpath is "%CLASSPATH%"
"%javaPath%\bin\java.exe" -cp "%CLASSPATH%"
org.postgresql.pljava.deploy.Deployer -install -database pkb -user postgres
-password pwd
Pause
I also looked at:
* http://gborg.postgresql.org/pipermail/pljava-dev/2007/001063.html
* http://gborg.postgresql.org/project/pljava/bugs/bugupdate.php?1653
*
file://///Hillhouseserver/general%20filing/P-Q/Postgres/plJava/install%20stu
ff/docs/userguide.html#Utilities
<file:///\\Hillhouseserver\general%20filing\P-Q\Postgres\plJava\install%20st
uff\docs\userguide.html#Utilities>
It looks like others have had the same problem but there's no solution
posted.
I've also tried compiling the Deployer client side Java code with NetBeans
5.5 and stepping through that. It fails on the CREATE FUNCTION described
above in the same way.
By the way I've been using Java for ten years and Postgres off and on for
at least 5 !
So this must be a really stupid problem.
Help very welcome !!
Regards
David Gradwell
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.pgfoundry.org/pipermail/pljava-dev/attachments/20070906/34247d37/attachment.html;
^ permalink raw reply [nested|flat] 5+ messages in thread
* [Pljava-dev] could not load library "C:/Program Files/PostgreSQL/8.2/lib/pljava.dll" when running deployer on Windows
2007-09-06 10:57 [Pljava-dev] could not load library "C:/Program Files/PostgreSQL/8.2/lib/pljava.dll" when running deployer on Windows
@ 2007-09-06 20:37 `
1 sibling, 0 replies; 5+ messages in thread
From: @ 2007-09-06 20:37 UTC (permalink / raw)
An HTML attachment was scrubbed...
URL: <http://lists.pgfoundry.org/pipermail/pljava-dev/attachments/20070907/cf7b925c/attachment.html;
^ permalink raw reply [nested|flat] 5+ messages in thread
* [Pljava-dev] could not load library "C:/Program Files/PostgreSQL/8.2/lib/pljava.dll" when running deployer on Windows
2007-09-06 10:57 [Pljava-dev] could not load library "C:/Program Files/PostgreSQL/8.2/lib/pljava.dll" when running deployer on Windows
@ 2007-09-07 08:16 `
1 sibling, 0 replies; 5+ messages in thread
From: @ 2007-09-07 08:16 UTC (permalink / raw)
Hi David,
The binaries from the PL/Java download site is for PostgreSQL 8.1. They
will not function for 8.2. Can that be the cause of your problem?
Another cause might be that although your PATH shows up correctly, the
PATH seen by the backend is still incorrect. Did you use a system path
setting?
Regards,
Thomas Hallgren
David JL Gradwell wrote:
> Hi,
>
>
>
> I?m trying to install PLJava on PostgreSQL 8.2 running on Windows 2003
> Server, using deploy.jar
>
>
>
> I get the following exception on running deploy.jar:
>
>
>
> ERROR: could not load library "C:/Program
> Files/PostgreSQL/8.2/lib/pljava.dll": The specified module could not be
> found.
>
>
>
>
>
> I?ve tried most things I could think of including:
>
>
>
>
>
> a) checking that the referenced file is in C:/Program
> Files/PostgreSQL/8.2/lib/ (which it is)
>
> b) taking the SQL commands from install.sql and
> feeding them one by one to Postgres through my well proven ?give it an
> SQL command GUI? that uses JDBC. (It fails on CREATE FUNCTION
> sqlj.java_call_handler() RETURNS language_handler AS 'pljava' LANGUAGE C
> with the above error)
>
> c) setting the environment variable PATH to include
> the above lib
>
> d) following the instructions in the readme
> (file:///C:/General%20Filing/P/Postgres/plJava/install%20stuff/docs/readme.html
> <file:///C:\General%20Filing\P\Postgres\plJava\install%20stuff\docs\readme.html>)
>
> especially adding the following entry to the |postgresql.conf| file:
>
> pljava.classpath = <pljava installation>/pljava.jar
>
>
>
> and the bit on PostMaster configuration (dynamic_library_path = '$libdir:<pljava installation>'Note that on the win32 platform you need to use a semicolon as a path separator and double backslashes (since backslash is the escape character in the postgresql.conf file) as directory separators.
>
>
>
> Although whether I got this right I?m not sure ? a Windows
> example would be good ! I have succeeded in setting this to a different
> folder and then get a correspondingly different error message pointing
> to being unable to load from that folder.
>
>
>
> My .bat to run deployer looked like this in the last attempt:
>
>
>
> set javaPath=C:\Program Files\Java\jre1.6.0_02
>
> set path=%javaPath%\bin;%path%
>
> echo path is "%path%"
>
> set CLASSPATH=C:\General Filing\P\Postgres\plJava\install
> stuff\deploy.jar;C:\General Filing\P\Postgres\plJava\install
> stuff\postgresql-8.2-505.jdbc3.jar
>
> echo classpath is "%CLASSPATH%"
>
> "%javaPath%\bin\java.exe" -cp "%CLASSPATH%"
> org.postgresql.pljava.deploy.Deployer -install -database pkb -user
> postgres -password pwd
>
> Pause
>
>
>
> I also looked at:
>
>
>
> * http://gborg.postgresql.org/pipermail/pljava-dev/2007/001063.html
> * http://gborg.postgresql.org/project/pljava/bugs/bugupdate.php?1653
> * file://///Hillhouseserver/general%20filing/P-Q/Postgres/plJava/install%20stuff/docs/userguide.html#Utilities
> <file:///\\Hillhouseserver\general%20filing\P-Q\Postgres\plJava\install%20stuff\docs\userguide.html#Utilities>
>
>
>
> It looks like others have had the same problem but there?s no solution
> posted.
>
>
>
> I?ve also tried compiling the Deployer client side Java code with
> NetBeans 5.5 and stepping through that. It fails on the CREATE FUNCTION
> described above in the same way.
>
>
>
> By the way I?ve been using Java for ten years and Postgres off and on
> for at least 5 !
>
>
>
> So this must be a really stupid problem.
>
>
>
> Help very welcome !!
>
>
>
> Regards
>
>
>
> David Gradwell
>
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> Pljava-dev mailing list
> Pljava-dev at gborg.postgresql.org
> http://gborg.postgresql.org/mailman/listinfo/pljava-dev
^ permalink raw reply [nested|flat] 5+ messages in thread
* [Pljava-dev] could not load library "C:/Program Files/PostgreSQL/8.2/lib/pljava.dll"
@ 2007-10-19 13:41
2007-10-20 04:23 ` [Pljava-dev] could not load library "C:/Program Files/PostgreSQL/8.2/lib/pljava.dll"
0 siblings, 1 reply; 5+ messages in thread
From: @ 2007-10-19 13:41 UTC (permalink / raw)
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;
^ permalink raw reply [nested|flat] 5+ messages in thread
* [Pljava-dev] could not load library "C:/Program Files/PostgreSQL/8.2/lib/pljava.dll"
2007-10-19 13:41 [Pljava-dev] could not load library "C:/Program Files/PostgreSQL/8.2/lib/pljava.dll"
@ 2007-10-20 04:23 `
0 siblings, 0 replies; 5+ messages in thread
From: @ 2007-10-20 04:23 UTC (permalink / raw)
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
>
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2007-10-20 04:23 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-09-06 10:57 [Pljava-dev] could not load library "C:/Program Files/PostgreSQL/8.2/lib/pljava.dll" when running deployer on Windows
2007-09-06 20:37 `
2007-09-07 08:16 `
2007-10-19 13:41 [Pljava-dev] could not load library "C:/Program Files/PostgreSQL/8.2/lib/pljava.dll"
2007-10-20 04:23 ` [Pljava-dev] could not load library "C:/Program Files/PostgreSQL/8.2/lib/pljava.dll"
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox