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

[Quan Zongliang]

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&#8217;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&#8217;ve tried setting the PATH variable to:  C:/Program Files/PostgreSQL/8.2/lib/
> I&#8217;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 &#8211; saying it can&#8217;t load from the new directory.
>  
> Help please !
>  
> David Gradwell
>