Date: Fri, 1 Feb 2008 18:31:47 -0500 (EST)
From: Kris Jurka <books@ejurka.com>
To: Guy Rouillier <guyr-ml1@burntmail.com>
cc: pljava-dev@pgfoundry.org, pgsql-general@postgresql.org
Subject: Re: [Pljava-dev] pljava.dll - bogus error
In-Reply-To: <47A39FF2.8070004@burntmail.com>
Message-ID: <Pine.BSO.4.64.0802011826240.24134@leary.csoft.net>
References: <47A37BC9.6050009@jcalfee.info>
	<Pine.BSO.4.64.0802011547460.7522@leary.csoft.net>
	<47A39FF2.8070004@burntmail.com>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed


On Fri, 1 Feb 2008, Guy Rouillier wrote:

> Kris Jurka wrote:
>> 
>> Unfortunately this error message comes from the server which gets it from 
>> windows.  So pljava is at least two steps removed from it, so we're in no 
>> position to improve it.  Perhaps the server guys can coax some more details 
>> out of windows.
>
> I looked on archives for both mailing lists and could not find this email 
> thread.  This error happened to me years ago and I don't remember what the 
> real issue was.  Could you point to the actual problem and I'll see if 
> Windows can identify it?

The problem is that pljava.dll depends on jvm.dll, when jvm.dll is not 
available pljava.dll can't be loaded.  That problem is true of any shared 
library, but it often hits pljava because jvm.dll is in different places 
for different people.

That's not the only potential error though.  Consider the latest security 
releases that adjusted an API that pljava uses.  If you try to run a 
pljava that was built for 8.2.5 against a 8.2.6 server it won't load 
because of missing symbols.

Here's the windows code to open a dll.  If there's any way to get more 
information out of the error message, we'd love to hear it:

http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/port/dynloader/win32.c?rev=1.9;content-type=text%2Fx-cvsweb-markup

Kris Jurka