agora inbox for pljava-dev@postgresql.org
help / color / mirror / Atom feedSubject: [Pljava-dev] Windows binaries
Date: Tue, 25 Jan 2011 03:03:37 -0000
Message-ID: <op.vpuf4bz9uxs6vk@asuka> (raw)
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>
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/
view thread (42+ messages) latest in thread
Message-ID: <op.vpuf4bz9uxs6vk@asuka>
Permalink: ../op.vpuf4bz9uxs6vk@asuka/
Also on: postgresql.org/message-id/op.vpuf4bz9uxs6vk@asuka
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pljava-dev@postgresql.org
Subject: Re: [Pljava-dev] Windows binaries
In-Reply-To: <op.vpuf4bz9uxs6vk@asuka>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox