[Pljava-dev] Problems loading jars with sqlj.install_jar

From: jason at hyett(dot)org (Jason Hyett)
To:
Subject: [Pljava-dev] Problems loading jars with sqlj.install_jar
Date: 2006-03-01 08:30:04
Message-ID: 44055B8C.1080904@hyett.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pljava-dev

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

Responses

Browse pljava-dev by date

  From Date Subject
Next Message Thomas Hallgren 2006-03-01 11:09:55 [Pljava-dev] Problems loading jars with sqlj.install_jar
Previous Message Thomas Hallgren 2006-02-28 14:04:56 [Pljava-dev] ERROR: java.sql.SQLException: The url cannot benull