The following bug has been logged online:
Bug reference: 3897
Logged by: David Gradwell
Email address: david@gradwell.com
PostgreSQL version: 8.3rc2
Operating system: Windows Server 2003
Description: plJava dll still doesn't load
Details:
I've successfully installed plJava on postgres 8.2.6 using Kris Jurka's
version at http://www.ejurka.com/pgsql/pljava/826/. Note that I failed to
get the standard distribution download to work.
I've now tried to get plJava running on 8.3rc2 (having failed on rc1 -
already reported) using the pljava.dll and pljava.jar in the distribution.
I can't get these to work, despite having followed the installation
instructions carefully and having got them to work for 8.2.6.
Error message is ERROR: could not load library "C:/pljava/pljava.dll": The
specified module could not be found.
(to be clear, I've set pljava.classpath='C:\\pljava\\pljava.jar'
If I leave pljava.classpath unset then I get a similar error with the
default library location identified.)
I've checked that a copy of the distributed dll is indeed in C:\pljava !
I've got a clean machine available with only Postgres 8.3 rc2 and Netbeans
IDE on it so I'm very happy to test an alternative pljava.dll and pljava.jar
combination.
I have a version of the Deploy code built to run under Netbeans and with
some of my own diagnostics - so I can see exactly which call it is failing
on (see below) and can run repeat tests for you if useful.
Regards
David Gradwell
Failing call is in initJavaHandlers():
stmt.execute(
"CREATE OR REPLACE FUNCTION sqlj.java_call_handler()" +
" RETURNS language_handler" +
" AS 'pljava'" +
" LANGUAGE C");
