From: eg at cybertec.at (Ewald Geschwinde)
Date: Sun, 15 Oct 2006 12:13:27 +0200
Subject: [Pljava-dev] error pljava1.3
Message-ID: <453209C7.9060609@cybertec.at>

'm using pljava with an 8.0.8 and I have done all to get it working


shared objects are ok with ldd for pljava.so

my entries in postgresql.conf are:

dynamic_library_path ='$libdir:/home/eg/pljava/'

custom_variable_classes = 'pljava'
pljava.classpath='/home/eg/pljava/pljava.jar'


I have pljava.so and pljava.jar in this directory

I have compiled it fomr source no compile errors and the output from

ldd pljava.so is:
eg at dhcppc13:~/pljava$ ldd pljava.so
        linux-gate.so.1 =>  (0xffffe000)
        libjvm.so => /opt/java/jre/lib/i386/client/libjvm.so (0xb7796000)
        libc.so.6 => /lib/tls/i686/cmov/libc.so.6 (0xb7663000)
        libm.so.6 => /lib/tls/i686/cmov/libm.so.6 (0xb7641000)
        libdl.so.2 => /lib/tls/i686/cmov/libdl.so.2 (0xb763e000)
        libpthread.so.0 => /lib/tls/i686/cmov/libpthread.so.0 (0xb762c000)
        /lib/ld-linux.so.2 (0x80000000)


then I do createdb test
psql -d test < install.sql
works without problems


but If I want to use the examples.jar the following happens:
test=# SELECT sqlj.install_jar('/home/eg/pljava/examples.jar', 
'samples',  true);
ERROR:  java.sql.SQLException: I/O exception reading jar file: no 
protocol: /home/eg/pljava/examples.jar



Did I miss something ?

Regards EWald Geschwinde