Subject Re: Big ResultSet
Author Roman Rokytskyy
Hi,

> When I using query returning big ResultSet(record number>100 000)
> JDBC driver try cached _all_ records and can cause OutOfMemory error.
> What is the matter?

In auto-commit case driver loads complete result set locally. This is
written either in release notes, or in faq. You have to switch to
non-autocommit mode.

Best regards,
Roman Rokytskyy