assertEquals("str" + counter, rs.getString(3));
    public void testUpdatableResultSet() throws Exception {        connection.setAutoCommit(false);                int recordCount = 10;        PreparedStatement ps = connection                .prepareStatement("INSERT INTO test_table("                        + "id, long_str) VALUES (?, ?)");        try {            for (int i = 0; i < recordCount; i++) {                ps.setInt(1, i);                ps.setString(2, "oldString" + i);                ps.executeUpdate();            }        } finally {            ps.close();        }        connection.commit();        connection.setAutoCommit(true);                connection.clearWarnings();        Statement stmt = connection.createStatement(            ResultSet.TYPE_SCROLL_INSENSITIVE,             ResultSet.CONCUR_UPDATABLE);                try {            assertTrue("No warnings should be added", connection.getWarnings() == null);                        ResultSet rs = stmt.executeQuery("SELECT id, long_str FROM test_table ORDER BY id");            int counter = 0;            while(rs.next()) {                                int id = rs.getInt(1);                assertEquals(counter, id);                                String longStr = rs.getString(2);                assertEquals("oldString" + counter, longStr);                                rs.updateString(2, "newString" + counter);                                assertEquals(counter, rs.getInt(1));                 assertEquals("newString" + counter, rs.getString(2));                rs.updateRow();                assertEquals(counter, rs.getInt(1));                 assertEquals("newString" + counter, rs.getString(2));                counter++;            }                        assertTrue("Should process " + recordCount + " rows.", counter == recordCount);                        rs.moveToInsertRow();            rs.updateInt(1, recordCount);            rs.updateString(2, "newString" + recordCount);            rs.insertRow();                        rs = stmt.executeQuery("SELECT id, long_str FROM test_table ORDER BY id");                        counter = 0;            while(rs.next()) {                int id = rs.getInt(1);                assertTrue(id == counter);                                String longStr = rs.getString(2);                assertTrue(("newString" + counter).equals(longStr));                counter++;                                if (counter == recordCount + 1)                    rs.deleteRow();            }                        assertTrue(counter == recordCount + 1);                        rs = stmt.executeQuery("SELECT count(*) FROM test_table");                        assertTrue(rs.next());            assertTrue(rs.getInt(1) == recordCount);                    } finally {            stmt.close();        }            }