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


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.html
Sent from the PL/Java mailing list archive at Nabble.com.