agora inbox for pljava-dev@postgresql.org  

help / color / mirror / Atom feed

Subject: [Pljava-dev] Problems loading jars with sqlj.install_jar
Date: Wed, 01 Mar 2006 12:09:55 +0100
Message-ID: <44058103.4030201@tada.se> (raw)
In-Reply-To: <44055B8C.1080904@hyett.org>
References: <44055B8C.1080904@hyett.org>

Hi Jason,
The only reason I can think of is that the account that runs the backend 
process (postmaster) lacks the needed privileges to read the file or the 
/tmp directory.

Regards,
Thomas Hallgren

Jason Hyett wrote:
> 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
>
>
> _______________________________________________
> Pljava-dev mailing list
> Pljava-dev at gborg.postgresql.org
> http://gborg.postgresql.org/mailman/listinfo/pljava-dev
>   

view thread (6+ messages)  latest in thread

Message-ID: <44058103.4030201@tada.se>
Permalink:  ../44058103.4030201@tada.se/
Also on:    postgresql.org/message-id/44058103.4030201@tada.se

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] Problems loading jars with sqlj.install_jar
  In-Reply-To: <44058103.4030201@tada.se>

* 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