From: thomas at tada.se (Thomas Hallgren) Date: Fri, 10 Mar 2006 14:21:27 +0100 Subject: [Pljava-dev] The 'setFetchSize' method of ResultSet problem In-Reply-To: <20060310131642.0FBE2188E71@smtp.263.net> References: <20060310131642.0FBE2188E71@smtp.263.net> Message-ID: <44117D57.2090502@tada.se> 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 ????????======= >