Hi

We are updating a (possibly) huge table with a statement like this:

Statement statement = connection.createStatement(
java.sql.ResultSet.TYPE_SCROLL_INSENSITIVE,
java.sql.ResultSet.CONCUR_UPDATABLE );
ResultSet data = statement.executeQuery( "select id, q from t where q is not
null" );
while ( data.next() ) {
String q = data.getString( 2 );
data.updateString( 2, modify( q ) );
data.updateRow();
}
data.close();
statement.close();

Now I need to be sure, that those changes are done during that loop and are
not cached by jaybird and executed afterwards.
Because there may be much more entries that available memory.

Can someone confirm that?

If there is any way to optimize that loops behavior, feel free to comment.
(id is the primary key of that table, q in the example is a varchar(200).)

Best regards,
Steffen



[Non-text portions of this message have been removed]