[Pljava-dev] Windows binaries

On Mon, 24 Jan 2011 17:20:58 -0000, Eric Kolotyluk
<eric.kolotyluk at gmail.com> wrote:

> I installed Dependency Walker to look at the pljava.dll file. It
> complained that it could not find jvm.dll, msvcr71.dll, and msvcr90.dll
> - so I put them all in the postgres lib directory where pljava.dll is.
> That problem went away.
>
> However, Dependency Walker is still complaining about
>
> Error: At least one module has an unresolved import due to a missing
> export function in an implicitly dependent module.
> Error: Modules with different CPU types were found.
> Warning: At least one module has an unresolved import due to a missing
> export function in a delay-load dependent module.

Can you check that the DLLs you copied are all 64 bits? Also, the JVM (on
Unix) needs more DLLs, here is an output I posted previously to this list,
for Solaris:

/export/home/johann/src/external/pljava-head/build/objs/pljava.so
/opt/myrkraverk/jdk1.5.0_22/jre/lib/amd64/server/libjvm.so

<snip>

/opt/myrkraverk/jdk1.5.0_22/jre/lib/amd64/native_threads/libhpi.so
/opt/myrkraverk/solstudio12.2/lib/dbx/amd64/runtime/libdbx_agent.so
/opt/myrkraverk/jdk1.5.0_22/jre/lib/amd64/libverify.so
/opt/myrkraverk/jdk1.5.0_22/jre/lib/amd64/libjava.so
/opt/myrkraverk/jdk1.5.0_22/jre/lib/amd64/libzip.so

Notes:

You don't need to run PL/Java with Java 5, it works equally well with a
Java 6 VM. The libdbx_agent is only for debugging PL/Java code with dbx,
and is not applicable for Windows.

> Is this a problem because I am running on a 64-bit version of Windows 7?

It shouldn't be, but it seems your walker is finding a 32bit DLL where it
expects a 64bit DLL.

> When I try to run install.sql I still get
> psql:install.sql:6: ERROR: could not load library "C:/Program Files
> (x86)/PostgresPlus/9.0SS/lib/pljava.dll": The specified module could not
> be found.

This is an unfortunate message. In Linux it tells me which (sub) DLL is
missing such as "libjvm.so could not be found."

--
Johann Oskarsson http://www.2ndquadrant.com/ |[]
PostgreSQL Development, 24x7 Support, Training and Services --+--
|
Blog: http://my.opera.com/myrkraverk/blog/