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:21:27 +0100
Message-ID: <44117D57.2090502@tada.se> (raw)
In-Reply-To: <20060310131642.0FBE2188E71@smtp.263.net>
References: <20060310131642.0FBE2188E71@smtp.263.net>

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 ????????=======
>   

view thread (2+ messages)  latest in thread

Message-ID: <44117D57.2090502@tada.se>
Permalink:  ../44117D57.2090502@tada.se/
Also on:    postgresql.org/message-id/44117D57.2090502@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: <44117D57.2090502@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