From: johann at 2ndquadrant.com (Johann 'Myrkraverk' Oskarsson)
Date: Tue, 25 Jan 2011 03:03:37 -0000
Subject: [Pljava-dev] Windows binaries
In-Reply-To: <op.vpub7pghuxs6vk@asuka>
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>
Message-ID: <op.vpuf4bz9uxs6vk@asuka>


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/