Thread: Re: [Pljava-dev] pljava.dll - bogus error
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
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
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