From: eric.kolotyluk at gmail.com (Eric Kolotyluk)
Date: Fri, 28 Jan 2011 16:51:34 -0800
Subject: [Pljava-dev] Fwd: Re:  Windows binaries
Message-ID: <4D436496.2040909@gmail.com>

In this particular case I was using 32-bit PostgreSQL on 64-bit Windows 
Ultimate - I could not get pljava.dll to load. According to Dependency 
Walker the DLL is trying to resolve all kinds of 64-bit DLLs which are 
not compatible with the 32-bit pljava.

When I ran the same download of 32-bit PostgreSQL on 32-bit Windows 
Professional - the pljava.dll loaded fine presumably because there are 
no 64-bit DLLs to resolve to.

Enterprise DB do not seem to have a binary release of 64-bit Postgres 
Plus for me to try.

At the moment this is a bit of a showstopper for us as we need to be 
able to deploy on both 32-bit and 64-bit Windows.

Off hand neither me nor my colleagues have heard of a situation where a 
32-bit DLL does not run on 64-bit windows, so we cannot imagine what is 
wrong with pljava.dll.

Cheers, Eric

On 2011-01-28 2:02 PM, JOSE CARLOS MARTINEZ LLARIO wrote:
> Hi Eric,
> When you said pljava does not work on 64-bit Windows, you are using 
> postgres 64 bits or postgres 32 bits on 64-bit Windows?
> Regards,
> Jose
>
> ------------------------------------------------------------------------
> Date: Tue, 25 Jan 2011 07:26:16 -0800
> From: eric.kolotyluk at gmail.com
> To: johann at 2ndquadrant.com
> CC: pljava-dev at pgfoundry.org
> Subject: Re: [Pljava-dev] Windows binaries
>
> Thanks, that did the trick. I am able to run helloworld()
>
> Phew - nice to finally get something working.
>
> Thanks enormously everyone for helping.
>
> Who can I talk to about the reason pljava does not work on 64-bit 
> Windows? I have never come across 32-bit software that does not run on 
> 64-bit windows before. There must be something funny about how they 
> built the DLL.
>
> Cheers, Eric
>
> On Mon, Jan 24, 2011 at 7:03 PM, Johann 'Myrkraverk' Oskarsson 
> <johann at 2ndquadrant.com <mailto:johann at 2ndquadrant.com>> wrote:
>
>
>     On Tue, 25 Jan 2011 00:31:44 -0000, Eric Kolotyluk
>     <eric.kolotyluk at gmail.com <mailto:eric.kolotyluk at gmail.com>> wrote:
>
>
>         but now when I try to do
>
>         SELECT helloWorld();
>
>         I get
>
>         ERROR:  java.lang.ClassNotFoundException:
>         org.postgis.pljava.HelloWorld
>
>
>     Seems you forgot (or did not know to) to set the classpath.
>
>     SELECT sqlj.set_classpath( <schema>, <jar name> );
>
>     In your case, I believe it is
>
>     SELECT sqlj.set_classpath( 'public', 'postgis_pljava_jar' );
>
>     You can see the proper schema to use with
>
>     SHOW search_path;
>
>     which, if you haven't set it to anything, will be the public one
>     as in my
>     example.
>
>
>     -- 
>      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 <mailto:Pljava-dev at pgfoundry.org>
>     http://pgfoundry.org/mailman/listinfo/pljava-dev
>
>
>
> _______________________________________________ Pljava-dev mailing 
> list Pljava-dev at pgfoundry.org 
> http://pgfoundry.org/mailman/listinfo/pljava-dev
>
>
> _______________________________________________
> 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/20110128/8bb1c087/attachment.html>