[DERBY-1251] cancelRowUpdates() affects rows updated with updateRow() in scrollable updatable resultsets

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 10.2.1.6
• Fix Version/s: 10.2.1.6
• Component/s: JDBC, Network Client
• Issue & fix info: Patch Available
• Assignee: Andreas Korneliussen
• Reporter: Andreas Korneliussen
• Created: 25/Apr/06 16:28
• Updated: 23/May/06 20:51
• Resolved: 14/May/06 14:55

Description

If an application does the following:

rs.updateInt(1, newValueCol1);
rs.updateRow();
rs.updateInt(2, newValueCol2);
rs.cancelRowUpdates();

Then, when calling rs.getInt(1), it will return the old value. Instead it should return the new value.

Workaround: after calling rs.updateRow(), the application could call rs.relative(0).

This problem does not affect forward only resultsets, since after an updateRow() they get positoned before the next row, leaving it impossible to do anything with the current row.