[Pljava-dev] PostgresSQL 8.4 PL/Java IO access issue.

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.

marc_firth <marc.r.firth at gmail.com> writes:

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

Use javau as the language. Then you don't have a security manager.

--
Johann Oskarsson http://www.2ndquadrant.com/ |[]
PostgreSQL Development, 24x7 Support, Training and Services --+--
|
Blog: http://my.opera.com/myrkraverk/blog/

Thanks! Setting to the untrusted language javaU works perfect :)

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