[Pljava-dev] out of memery

[Thomas Hallgren]

Hi Lifeng,
PL/Java does not impose limitations on the size of a result set. The set
is always perused one row at a time and PL/Java will not make attempts
to bring everything into memory.

What JDBC driver are you using? Are you setting the 'setFetchSize' on
the result set? Perhaps the default is to fetch everything in one go?

Regards,
Thomas Hallgren


lifeng wrote:
> pljava-dev-request,您好！
>
> 	   HI. I used pl/java's function to get resultset from the remote database . When the result was 1GB, i got 'out of memery' error . 
> 		SERVER : p42.8G , 768MB RAM
> 		JVM MEMERY : 384MB
> 	   
>        I don't know where the problem happened . Can pl/java deal with these datas? I hope to get a correct answer.
> 	   Thank you very much.
>
>  
> 				 
> 　　　　　　　　lifeng
> 　　　　　　　　lifenggod at 263.net
> 　　　　　　　　　　2006-03-15
>
> _______________________________________________
> Pljava-dev mailing list
> Pljava-dev at gborg.postgresql.org
> http://gborg.postgresql.org/mailman/listinfo/pljava-dev
>