From: thomas at tada.se (Thomas Hallgren)
Date: Mon, 25 Sep 2006 18:23:19 +0200
Subject: [Pljava-dev] Error trapping help
In-Reply-To: <45180048.4040800@softhome.net>
References: <4517F5F4.2020804@softhome.net> <4517F8D3.1080404@tada.se>
	<45180048.4040800@softhome.net>
Message-ID: <45180277.3040200@tada.se>

Scott Petersen wrote:
> Caused by: java.lang.SecurityException: read on C:\Program 
> Files\PostgreSQL\8.1\data\jasperreports.properties
>     at 
>   
Looks like your JRLoader attempts to read from your filesystem. That is 
not permitted in a trusted function. In order to do that, you must use 
LANGUAGE javaU in your CREATE FUNCTION so that you get the untrusted 
language handler. A better solution is probably to provide the 
jasperreport.properties in some other way, a resource in a jar that is 
loaded or something. I don't know Jasper very well so I can't help you 
there.

Regards,
Thomas Hallgren