agora inbox for pljava-dev@postgresql.org  

help / color / mirror / Atom feed

[Pljava-dev] The 'setFetchSize' method of ResultSet problem
2+ messages / 0 participants
[nested] [flat]

* [Pljava-dev] The 'setFetchSize' method of ResultSet problem
@ 2006-03-10 13:21  
  0 siblings, 1 reply; 2+ messages in thread

From:  @ 2006-03-10 13:21 UTC (permalink / raw)

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





^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* [Pljava-dev] The 'setFetchSize' method of ResultSet problem
@ 2006-03-10 13:35  
  parent: 
  0 siblings, 0 replies; 2+ messages in thread

From:  @ 2006-03-10 13:35 UTC (permalink / raw)

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
>   





^ permalink  raw  reply  [nested|flat] 2+ messages in thread

end of thread, other threads:[~2006-03-10 13:35 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-03-10 13:21 [Pljava-dev] The 'setFetchSize' method of ResultSet problem 
2006-03-10 13:35 ` 

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