BUG #3897: plJava dll still doesn't load

From: "David Gradwell" <david(at)gradwell(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #3897: plJava dll still doesn't load
Date: 2008-01-23 16:27:22
Message-ID: 200801231627.m0NGRMls025999@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 3897
Logged by: David Gradwell
Email address: david(at)gradwell(dot)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");

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Guillaume Smet 2008-01-23 16:48:14 Re: 8.2 and 8.3 postgresql.conf oddity
Previous Message Tom Lane 2008-01-23 15:22:11 Re: 8.2 and 8.3 postgresql.conf oddity