Hi Roman!

>> 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.

But I never close the AC-Connection. Without any commit.
Is it possible that I run into problems without commiting the
read connection?

best regards,
josh.