From: jason at hyett.org (Jason Hyett)
Date: Wed, 01 Mar 2006 08:30:04 +0000
Subject: [Pljava-dev] Problems loading jars with sqlj.install_jar
Message-ID: <44055B8C.1080904@hyett.org>

Hello all,

I'm getting a permission denied error when I try and install any jar 
into the database with sqlj.install_jar(). The following output is 
produced in the Postgresql log:

STATEMENT:  select sqlj.install_jar('file:///tmp/test.jar','test',false);
java.sql.SQLException: I/O exception reading jar file: /tmp/test.jar 
(Permission denied)
       at 
org.postgresql.pljava.internal.Backend.addClassImages(Backend.java:201)
       at 
org.postgresql.pljava.management.Commands.installJar(Commands.java:527)
       at 
org.postgresql.pljava.management.Commands.installJar(Commands.java:205)
ERROR:  XX000: java.sql.SQLException: I/O exception reading jar file: 
/tmp/test.jar (Permission denied)

I'm running Fedora Core 4 with the Postgresql 8.1.3 and PL/Java 1.2.0 
binaries plus Sun's 1.5.0_06 VM.

Has anyone else seen this and do you know of a workaround?

thanks, Jason