Re: [GENERAL] [Pljava-dev] pljava.dll - bogus error

2008-02-01 Thread Kris Jurka



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

---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
  subscribe-nomail command to [EMAIL PROTECTED] so that your
  message can get through to the mailing list cleanly


Re: [GENERAL] [Pljava-dev] pljava.dll - bogus error

2008-02-01 Thread Guy Rouillier

Kris Jurka wrote:



On Fri, 1 Feb 2008, James Calfee wrote:


Please improve error reporting for this:

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.



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?


--
Guy Rouillier

---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
  choose an index scan if your joining column's datatypes do not
  match


Re: [GENERAL] [Pljava-dev] pljava.dll - bogus error

2008-02-01 Thread Kris Jurka



On Fri, 1 Feb 2008, James Calfee wrote:


Please improve error reporting for this:

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.



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.


Kris Jurka

---(end of broadcast)---
TIP 6: explain analyze is your friend