|Subject||Fwd: Re: Problem with multi-threaded update/query causing JDBC driver errors|
> You can have multiple open result sets for different statements inI´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...
> 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.
> If you specify that you want scrollable result set, Jaybird will cacheIt´s a shame it's not part of JDBC specification :-(
> all rows in memory. But that is implementation specifics.