[Pljava-dev] The 'setFetchSize' method of ResultSet problem

[Thomas Hallgren]

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
>