[Pljava-dev] could not load library "C:/Program Files/PostgreSQL/8.2/lib/pljava.dll" when running deployer on Windows

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