[DERBY-611] Network client: updateRow() causes a commit when autoCommit = true

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 10.0.2.2, 10.1.1.0, 10.1.2.1, 10.1.3.1, 10.2.1.6
• Fix Version/s: 10.2.1.6
• Component/s: Network Client
• Environment: Java Version: 1.5.0_01; Java Vendor: Sun Microsystems Inc.; Java home: /usr/jdk/instances/jdk1.5.0/jre; Java classpath: classes; OS name: SunOS; OS architecture: x86; OS version: 5.10
• Assignee: Dag H. Wanvik
• Reporter: Fernanda Pizzorno
• Created: 10/Oct/05 17:05
• Updated: 20/Dec/05 10:40
• Resolved: 19/Dec/05 19:09

Description

On the network client driver, the ResultSet method updateRow makes the transaction commit, when autocommit is true. The correct behavior is to commit only when the result set is closed. This works correctly in the embedded driver.

The repro case is uploaded as an attachment "testCSUpdateRowCommits.java".

Output (repro case):
updateRow() should not commit
Value: 16, expected value 1. Should not have committed updateRow()