From: thomas at tada.se (Thomas Hallgren)
Date: Fri, 10 Mar 2006 14:35:25 +0100
Subject: [Pljava-dev] The 'setFetchSize' method of ResultSet problem
In-Reply-To: <44117D57.2090502@tada.se>
References: <20060310131642.0FBE2188E71@smtp.263.net>
	<44117D57.2090502@tada.se>
Message-ID: <4411809D.9040007@tada.se>

Doh. Yes, you do use another driver. Sorry...

What happens is probably that the SQLServer driver is attempting to open
a temporary file in order to accomodate the huge result. PL/Java, when
used as a 'trusted' language, will not permit file system access. You
will need to use an untrusted function to do that (i.e. a CREATE
FUNCTION that uses LANGUAGE javaU).

Regards,
Thomas Hallgren


Thomas Hallgren wrote:
> I doubt this message comes from the PL/Java JDBC driver. Are you by any
> chance trying to use some other JDBC driver from inside PL/Java? How do
> you obtain your connection?
>
> - thomas
>
> PS. Please post to the PL/Java mailing list and not to me personally.
> PL/Java is an open source project and discussions concerning PL/Java
> should benefit the community.
>
>
> lifeng wrote:
>   
>> Thomas Hallgren,???
>>
>> 	   I use pl/java 1.2 . I wrote a function which using sqlserver's jdbcdriver to get recordset from remote sqlserverdb's table . For increasing performance ,i used 'setFetchSize' method(ResultSet'method) in the java function to set Fetch size .I set 20000 row.The data size is 2.5M data in per fetch.When i ran the function , i got the erro(JAVA SQL SQLEXCEPTION: IO Erro creating temp file : null) from pgsql.How can i do with the problem?
>>
>> ======= 2006-01-25 15:08:29 ????????=======
>>   
>>     
>
> _______________________________________________
> Pljava-dev mailing list
> Pljava-dev at gborg.postgresql.org
> http://gborg.postgresql.org/mailman/listinfo/pljava-dev
>