agora inbox for pljava-dev@postgresql.org  

help / color / mirror / Atom feed

Subject: [Pljava-dev] Class not found error
Date: Tue, 08 Aug 2006 12:28:56 +0100
Message-ID: <44D87578.4030502@starjar.com> (raw)
In-Reply-To: <44D86DA6.3010008@starjar.com>
References: <44D86DA6.3010008@starjar.com>

The power of posting to a mailing list.

About 30 seconds after I hit send, a solution appears.

I needed to set the class path on the schema, to make the functions
available.

SELECT sqlj.set_classpath('javatest', 'samples');

http://wiki.tada.se/wiki/display/pljava/Sample+Tests
http://wiki.tada.se/wiki/display/pljava/set_classpath




Peter Henderson wrote:
> I've just installed PL/Java 1.3 on postgresql 8
> 
> The installation appeared to work well.
> 
> But whenever I try to call any Java function (including the samples) I
> get a Class not found exception
> 
> 
> select * from javatest.print('Hello');
> 
> ERROR:  java.lang.ClassNotFoundException:
> org.postgresql.pljava.example.Parameters
> 
> 
> 
> Yet the tables in the sqlj schema indicate the examples jar file was
> loaded ok.
> 
> starjarpartech20060421=# select entryname from sqlj.jar_entry;
>                                entryname
> ------------------------------------------------------------------------
>  org/postgresql/pljava/example/SetOfRecordTest.class
>  org/postgresql/pljava/example/ComplexTuple.class
>  org/postgresql/pljava/example/Threads.class
>  org/postgresql/pljava/example/ResultSetTest.class
>  org/postgresql/pljava/example/ComplexScalar.class
>  org/postgresql/pljava/example/Threads$Locker.class
>  org/postgresql/pljava/example/RandomInts.class
>  org/postgresql/pljava/example/Parameters.class
>  org/postgresql/pljava/example/SPIActions$1.class
>  org/postgresql/pljava/example/HugeResultSet.class
>  org/postgresql/pljava/example/Users.class
>  org/postgresql/pljava/example/MetaDataStrings$1MethodComparator.class
>  org/postgresql/pljava/example/BinaryColumnTest.class
>  org/postgresql/pljava/example/UsingPropertiesAsResultSet.class
>  org/postgresql/pljava/example/AnyTest.class
>  org/postgresql/pljava/example/Point.class
>  org/postgresql/pljava/example/MetaDataBooleans.class
>  org/postgresql/pljava/example/MetaDataInts$1MethodComparator.class
>  org/postgresql/pljava/example/TupleReturn.class
>  org/postgresql/pljava/example/MetaDataStrings.class
>  org/postgresql/pljava/example/UsingPropertiesAsScalarSet.class
>  org/postgresql/pljava/example/SPIActions.class
>  org/postgresql/pljava/example/MetaDataInts.class
>  org/postgresql/pljava/example/MetaDataBooleans$1MethodComparator.class
>  org/postgresql/pljava/example/Security.class
>  org/postgresql/pljava/example/LoggerTest.class
>  org/postgresql/pljava/example/UsingProperties.class
>  org/postgresql/pljava/example/MetaDataTest.class
>  org/postgresql/pljava/example/Triggers.class
>  .timestamp
>  deployment/examples.ddr
>  org/postgresql/pljava/example/example.properties
>  com/starjar/crm/postgres/BomList.class
> (33 rows)
> 
> 
> 
> What have i missed?
> 
> 
> Peter Henderson
> 
> _______________________________________________
> Pljava-dev mailing list
> Pljava-dev at gborg.postgresql.org
> http://gborg.postgresql.org/mailman/listinfo/pljava-dev
> 

view thread (2+ messages)

Message-ID: <44D87578.4030502@starjar.com>
Permalink:  ../44D87578.4030502@starjar.com/
Also on:    postgresql.org/message-id/44D87578.4030502@starjar.com

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] Class not found error
  In-Reply-To: <44D87578.4030502@starjar.com>

* 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