[Pljava-dev] Windows binaries

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> wrote:

On Tue, 25 Jan 2011 00:31:44 -0000, Eric Kolotyluk

<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

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/faac524b/attachment.html>