> You can have multiple open result sets for different statements in
> non-autocommit mode. So you can loop though one result set and execute
> statements within the loop.
>
> In auto-commit mode specification requires us to close previous
> statement before we execute next one. In this case previous example with
> loop won't work.

I´m very glad to know i can open multiple statements/resultsets in non-autocommit mode. Is it part of JDBC specification? It will avoid me to use CachedRowSets in many places in my application...

> If you specify that you want scrollable result set, Jaybird will cache
> all rows in memory. But that is implementation specifics.

It´s a shame it's not part of JDBC specification :-(

Regards,

Fabiano