From: | thomas at tada(dot)se (Thomas Hallgren) |
---|---|
To: | |
Subject: | [Pljava-dev] The 'setFetchSize' method of ResultSet problem |
Date: | 2006-03-10 13:35:25 |
Message-ID: | 4411809D.9040007@tada.se |
Views: | Whole Thread | Raw Message | Download mbox | Resend email |
Thread: | |
Lists: | pljava-dev |
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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Thomas Hallgren | 2006-03-12 11:16:04 | [Pljava-dev] PL/Java Wiki launched |
Previous Message | Thomas Hallgren | 2006-03-10 13:21:27 | [Pljava-dev] The 'setFetchSize' method of ResultSet problem |