> With 1.5.5 this works for me, but with 2.1.1 the result set from stmt1
> 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?

Nope. The reasons are described in the release notes and this effect is
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
in memory.

Roman