agora inbox for pljava-dev@postgresql.org  

help / color / mirror / Atom feed

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

view thread (2+ messages)

Message-ID: <4411809D.9040007@tada.se>
Permalink:  ../4411809D.9040007@tada.se/
Also on:    postgresql.org/message-id/4411809D.9040007@tada.se

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pljava-dev@postgresql.org
  Subject: Re: [Pljava-dev] The 'setFetchSize' method of ResultSet problem
  In-Reply-To: <4411809D.9040007@tada.se>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox