From: jcllario at hotmail.com (JOSE CARLOS MARTINEZ LLARIO)
Date: Fri, 28 Jan 2011 23:02:42 +0100
Subject: [Pljava-dev] Windows binaries
In-Reply-To: <AANLkTinfYnLExCnscrRNxjsbn5tCc487Vk3zbj4rHXHg@mail.gmail.com>
References: <C1A6B6FC8196CF43B9B4D0D2C63BFA5A18C4E39967@SPR3V9.office.local>,
	<op.vpryofceuxs6vk@asuka>
	<4D3C7E10.7080906@gmail.com>,<op.vpr0nfoauxs6vk@asuka>
	<4D3CA4BD.3010206@gmail.com>,<op.vpr76nenuxs6vk@asuka>
	<4D3CAF3D.2060802@hogranch.com>,<4D3CB385.6010403@gmail.com>
	<4D3CB623.2060409@hogranch.com>,<4D3CB765.709@gmail.com>
	<4D3CB76D.2040407@hogranch.com>,<4D3CBAF8.6080006@gmail.com>
	<4D3DB4FA.4090001@gmail.com>,<op.vptpwn1ouxs6vk@asuka>
	<4D3DC136.8010709@gmail.com>, <op.vptr1pfeuxs6vk@asuka>,
	<AANLkTikurAO4_RfSUzU53uYRpuHSz56cPBoQGaV1JmDC@mail.gmail.com>,
	<4D3DE471.8040801@gmail.com>,
	<AANLkTinv44uzq0kS+dS_Dt0RN0bBDiKbB_yEQra41eOG@mail.gmail.com>,
	<op.vpub7pghuxs6vk@asuka> <op.vpuf4bz9uxs6vk@asuka>,
	<AANLkTinfYnLExCnscrRNxjsbn5tCc487Vk3zbj4rHXHg@mail.gmail.com>
Message-ID: <COL116-W2864527E19D11F5B20DFF4D3E10@phx.gbl>


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>