[Pljava-dev] Class not found error

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

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
>