|Subject||Re: [Firebird-Java] Difference between 1.5.5 an 2.1.1 and ResultSets in autocommit connections|
> With 1.5.5 this works for me, but with 2.1.1 the result set from stmt1Nope. The reasons are described in the release notes and this effect is
> get closed. I think the default ResultSetHoldability is changed
> between the versions (from HOLD_CURSORS_OVER_COMMIT in 1.5.5 to
> CLOSE_CURSORS_AT_COMMIT in 2.1.1). Is this right?
visible only in auto-commit mode.
> And: Is this ok?Yes. But better switch the auto-commit off - in auto-commit mode and
with scrollable result set, everything is fetched to the client and kept