agora inbox for pljava-dev@postgresql.org  

help / color / mirror / Atom feed

Subject: [Pljava-dev] PostgresSQL 8.4 PL/Java IO access issue.
Date: Sun, 4 Sep 2011 03:19:21 -0700 (PDT)
Message-ID: <1315131561130-4767309.post@n5.nabble.com> (raw)


Hello,

I am attempting to create a simple PL/Java function that checks where a file
exists or not but I am getting an IO error.  Are there any security switches
I need to set when creating the PL/Java function or is there anything else I
am missing?

Code below...

Many thanks,
Marc :-)

//Java Code
public class FileExists
{
     public static boolean checkFile (String input) throws Exception
  {
  String errorMessage;

  try
  {
   // Check file exists and pass the value back thru the OUT paramenter

   File f = new File(input);

   return (f.exists());

  }
  catch (SecurityException ioe)
  {
   errorMessage = ioe.getMessage();
   throw new Exception( errorMessage + " FAILED" );
  }
 }
}


-- PL/Java Wrapper Fuction 
CREATE FUNCTION fileexists(character varying) RETURNS boolean
    LANGUAGE java
    AS $$FileExists.checkFile(java.lang.String)$$;

--Results
mydb=# select fileexists('/home/postgres/myfile.txt');
ERROR:  java.lang.Exception: read on /home/postgres/myfile.txt FAILED



--
View this message in context: http://postgresql.1045698.n5.nabble.com/PostgresSQL-8-4-PL-Java-IO-access-issue-tp4767309p4767309.ht...
Sent from the PL/Java mailing list archive at Nabble.com.

view thread (3+ messages)  latest in thread

Message-ID: <1315131561130-4767309.post@n5.nabble.com>
Permalink:  ../1315131561130-4767309.post@n5.nabble.com/
Also on:    postgresql.org/message-id/1315131561130-4767309.post@n5.nabble.com

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] PostgresSQL 8.4 PL/Java IO access issue.
  In-Reply-To: <1315131561130-4767309.post@n5.nabble.com>

* 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