Jordi Marqu?s wrote:
> I need read file into pljava trigger, but when I read the file I
> obtain the following error:
>
> java.lang.SecurityException: read on C:\postgresql\test.txt
>
> Somebody knows the solution
>
> Thank you very much
As most of the PostgreSQL PL's, PL/Java comes with two language
handlers, a "java" and a "javaU". The former is "trusted" and will not
permit your functions access to the file system. You need to use
LANGUAGE javaU in your function declaration.
Regards,
Thomas Hallgren