int key = rs.getInt(1); String value = rs.getString(2);
String marker = rs.getString(1); int key = rs.getInt(2); String value = rs.getString(3);  assertTrue("Marker should be correct.", "marker".equals(marker)); assertTrue("Key should be same as counter.", key == counter); assertTrue("EMPTY_CHAR string should be empty.", "".equals(value));
    public void testEmptyColumnInView() throws Exception {        PreparedStatement ps =             connection.prepareStatement(INSERT_INTO_TABLE_STATEMENT);                    try {            for(int i = 0; i < 10; i++) {                ps.setInt(1, i);                ps.executeUpdate();            }        } finally {            ps.close();        }                        connection.setAutoCommit(false);        Statement stmt = connection.createStatement();                try {                        ResultSet rs = stmt.executeQuery(SELECT_FROM_VIEW_STATEMENT);                        int counter = 0;            while(rs.next()) {                int key = rs.getInt(1);                String value = rs.getString(2);                                counter++;            }                        assertTrue("Should read 10 records", counter == 10);                    }finally {            stmt.close();        }                connection.setAutoCommit(true);    }