[Pljava-dev] Windows binaries

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/