Is there a way to create connections in my connection pool with autocommit
off? Or do I have to set it off for each one after they are created? eg
in SAP you can specify it in the connection string...

Many thanks,

David




"Roman Rokytskyy" <rrokytskyy@...> on 11/11/2003 03:56:15 AM

Please respond to Firebird-Java@yahoogroups.com

To: Firebird-Java@yahoogroups.com
cc:
Subject: [Firebird-Java] Re: Big ResultSet


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





To unsubscribe from this group, send an email to:
Firebird-Java-unsubscribe@yahoogroups.com



Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/