> I have a query that returns a resultset of 70 mb. I'd somehow would like
> J/Connector to fetch only small pieces using Statement.setFetchSize but
it
> still get the whole ResultSet at once and then I get an OutOfMemoryError.
> Is it a bug in setFetchSize? Does J/Connector ignore it? Have I totally
> missunderstood what setFetchSize does?
It works for me, in a similar sort of situation.
Is your Statement TYPE_FORWARD_ONLY and CONCUR_READ_ONLY? These are
defaults, but you may have overridden them, and if so you disable the
setFetchSize().
Do you call setFetchSize() before the query? If not, the query will fetch
it all, and it is no use setting it before you fetch results.
Alec
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
