[Pljava-dev] Problem with pljava-1.4.3 on Windows x86_64

Hi,

I am facing problem with pljava-1.4.3 against postgresql-9.1 on windows
x86_64 machine. When I try to load pljava.dll, I am getting "missing
PG_MODULE_MAGIC" error.

I came to know that symbols are not being exported correctly for x86_64 in
pljava-1.4.3/src/C/pljava/Makefile, though the previous mechanism to export
symbols i.e: for x86_32 is working fine, problematic area of Makefile is
given below:

ifeq ($(host_cpu), x86_64)
$(DLLTOOL) --export-all --output-def $(NAME).def $(OBJS)
$(DLLTOOL) --dllname $(plugin) $(DLLTOOL_LIBFLAGS) --def $(NAME).def
gendef - ${JVM_LIB}/jvm.dll > jvm.def
${DLLTOOL} --export-all-symbols --input-def jvm.def --output-lib
libjvm.dll.a
${CC} -shared -o ${plugin} ${OBJS} ${BE_DLLLIBS} -L.
$(JAVA_HOME)/lib/jvm.lib
else
$(DLLTOOL) --export-all $(DLLTOOL_DEFFLAGS) --output-def $(NAME).def $(OBJS)
$(DLLWRAP) $(LDFLAGS_SL) -o $(plugin) --dllname $(plugin) $(DLLWRAP_FLAGS)
--def $(NAME).def $(OBJS) $(SHLIB_LINK)
$(DLLTOOL) --dllname $(plugin) $(DLLTOOL_LIBFLAGS) --def $(NAME).def
endif

I can get rid of this error by removing a check for x86_64 and use a
previous mechanism (i.e: the 'else' part) to generate the dll.

Can someone explain why the dll generation mechanism has been changed for
x86_64.

thanks
-- talha
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.pgfoundry.org/pipermail/pljava-dev/attachments/20111123/6a46771c/attachment.html>

Talha Bin Rizwan <talha.rizwan at enterprisedb.com> writes:

> Hi,
>
> I am facing problem with pljava-1.4.3 against postgresql-9.1 on windows
> x86_64?machine. When I try to load pljava.dll, I am getting "missing
> PG_MODULE_MAGIC" error.
[snip]
> I can get rid of this error by removing a check for?x86_64 and use a
> previous mechanism (i.e: the 'else' part) to generate the dll.
>
> Can someone explain why the dll generation mechanism has been
> changed for x86_64.

Apparently I had some trouble getting it to work when I was building
1.4.2.

The method used to build the 32bit binaries was (and probably is)
using methods deprecated, according to the mingw-w64 team.

Unfortunately, I did not blog about this and now I've forgotten the
details.

One detail is that the jvm.def file, which comes with PL/Java may not
be compatible with 64bit builds - or that may just have been an extra
caution on my part. The 64bit build (re)creates it.

Another detail is that the EDB built 64bit server for Windows is (or
was) configured with --disable-float8-byval which results in an
incompateble PG_MODULE_MAGIC.

That's all I recall at the moment,

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

On Wed, Nov 23, 2011 at 4:17 PM, Johann 'Myrkraverk' Oskarsson <
johann at 2ndquadrant.com> wrote:

> Talha Bin Rizwan <talha.rizwan at enterprisedb.com> writes:
>
> > Hi,
> >
> > I am facing problem with pljava-1.4.3 against postgresql-9.1 on windows
> > x86_64 machine. When I try to load pljava.dll, I am getting "missing
> > PG_MODULE_MAGIC" error.
> [snip]
> > I can get rid of this error by removing a check for x86_64 and use a
> > previous mechanism (i.e: the 'else' part) to generate the dll.
> >
> > Can someone explain why the dll generation mechanism has been
> > changed for x86_64.
>
> Apparently I had some trouble getting it to work when I was building
> 1.4.2.
>
> The method used to build the 32bit binaries was (and probably is)
> using methods deprecated, according to the mingw-w64 team.
>
> Unfortunately, I did not blog about this and now I've forgotten the
> details.
>
> One detail is that the jvm.def file, which comes with PL/Java may not
> be compatible with 64bit builds - or that may just have been an extra
> caution on my part. The 64bit build (re)creates it.
>
> Another detail is that the EDB built 64bit server for Windows is (or
> was) configured with --disable-float8-byval which results in an
> incompateble PG_MODULE_MAGIC.
>

I am building 64bit server for Windows configured
with --disable-float8-byval and I am getting following error:

+ ERROR: incompatible library "c:/inst/lib/pljava.dll": missing magic block
+ HINT: Extension libraries are required to use the PG_MODULE_MAGIC macro.

Is there any solution to this incompatibility or should I use x86_32 dll
generation mechanism to fix this problem?

thanks
-- talha

>
> That's all I recall at the moment,
>
> --
> Johann Oskarsson http://www.2ndquadrant.com/ |[]
> PostgreSQL Development, 24x7 Support, Training and Services --+--
> |
> Blog: http://my.opera.com/myrkraverk/blog/
> _______________________________________________
> Pljava-dev mailing list
> Pljava-dev at pgfoundry.org
> http://pgfoundry.org/mailman/listinfo/pljava-dev
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.pgfoundry.org/pipermail/pljava-dev/attachments/20111128/ba16f699/attachment.html>

Talha Bin Rizwan <talha.rizwan at enterprisedb.com> writes:

> I am building 64bit server for Windows configured
> with?--disable-float8-byval and I am getting following error:
>
> + ERROR: incompatible library "c:/inst/lib/pljava.dll": missing magic block
> + HINT: Extension libraries are required to use the PG_MODULE_MAGIC macro.
>
> Is there any solution to this?incompatibility?or should I use x86_32
> dll generation mechanism to fix this problem?

For now, just go with the 32bit build process. I'll take a look at
the whole thing later.

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