[Pljava-dev] Fwd: Re: Windows binaries

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>