From: | marc(dot)r(dot)firth at gmail(dot)com (marc_firth) |
---|---|
To: | |
Subject: | [Pljava-dev] PostgresSQL 8.4 PL/Java IO access issue. |
Date: | 2011-09-04 10:19:21 |
Message-ID: | 1315131561130-4767309.post@n5.nabble.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pljava-dev |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Johann 'Myrkraverk' Oskarsson | 2011-09-04 21:42:00 | [Pljava-dev] PostgresSQL 8.4 PL/Java IO access issue. |
Previous Message | Vorarlberger | 2011-09-01 09:41:18 | [Pljava-dev] Return a Anonymous ResultSet |