Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group