Examples of java.sql.ResultSet.moveToCurrentRow()

java.sql.ResultSet.moveToCurrentRow()
Moves the cursor to the remembered position, usually the current row. This only applies if the cursor is on the Insert row. @throws SQLException if a database error happens

        rs.previous();
        currentPosition = rs.getRow();
        rs.moveToInsertRow();
        rs.updateInt(1, currentPosition + 1000);
        rs.insertRow();
        rs.moveToCurrentRow();
        assertEquals("CurrentPosition should be " + currentPosition, 
                rs.getRow(), currentPosition);


        
        try {

View Full Code Here

                    se.getSQLState().substring(0, 5), 
                    INVALID_CURSOR_STATE_NO_CURRENT_ROW);
        }
        
        try {
            rs.moveToCurrentRow();
            rs.updateInt(1, currentPosition + 2000);
            rs.insertRow();
        } catch (SQLException se) {
            assertEquals("Expected exception", 
                    se.getSQLState().substring(0, 5),

View Full Code Here

                                          "on insertRow before positioning");


        rs.next();
        rs.moveToInsertRow();
        checkDetectabilityCallsOutsideRow(rs, "on insertRow");
        rs.moveToCurrentRow(); // needed until to DERBY-1322 is fixed


        rs.beforeFirst();
        checkDetectabilityCallsOutsideRow(rs, "on beforeFirst row");


        rs.afterLast();

View Full Code Here

        rs.previous();
        currentPosition = rs.getRow();
        rs.moveToInsertRow();
        rs.updateInt(1, currentPosition + 1000);
        rs.insertRow();
        rs.moveToCurrentRow();
        assertEquals("CurrentPosition should be " + currentPosition, 
                rs.getRow(), currentPosition);


        
        try {

View Full Code Here

                    se.getSQLState().substring(0, 5), 
                    INVALID_CURSOR_STATE_NO_CURRENT_ROW);
        }
        
        try {
            rs.moveToCurrentRow();
            rs.updateInt(1, currentPosition + 2000);
            rs.insertRow();
        } catch (SQLException se) {
            assertEquals("Expected exception", 
                    se.getSQLState().substring(0, 5),

View Full Code Here

                                          "on insertRow before positioning");


        rs.next();
        rs.moveToInsertRow();
        checkDetectabilityCallsOutsideRow(rs, "on insertRow");
        rs.moveToCurrentRow(); // needed until to DERBY-1322 is fixed


        rs.beforeFirst();
        checkDetectabilityCallsOutsideRow(rs, "on beforeFirst row");


        rs.afterLast();

View Full Code Here

        rs.previous();
        currentPosition = rs.getRow();
        rs.moveToInsertRow();
        rs.updateInt(1, currentPosition + 1000);
        rs.insertRow();
        rs.moveToCurrentRow();
        assertEquals("CurrentPosition should be " + currentPosition, 
                rs.getRow(), currentPosition);


        
        try {

View Full Code Here

                    se.getSQLState().substring(0, 5), 
                    INVALID_CURSOR_STATE_NO_CURRENT_ROW);
        }
        
        try {
            rs.moveToCurrentRow();
            rs.updateInt(1, currentPosition + 2000);
            rs.insertRow();
        } catch (SQLException se) {
            assertEquals("Expected exception", 
                    se.getSQLState().substring(0, 5),

View Full Code Here

                                          "on insertRow before positioning");


        rs.next();
        rs.moveToInsertRow();
        checkDetectabilityCallsOutsideRow(rs, "on insertRow");
        rs.moveToCurrentRow(); // needed until to DERBY-1322 is fixed


        rs.beforeFirst();
        checkDetectabilityCallsOutsideRow(rs, "on beforeFirst row");


        rs.afterLast();

View Full Code Here

        assertEquals(1, rset.getInt(1));
        rset.moveToInsertRow();
        rset.updateInt(1, 5);
        rset.updateString(2, "insert5");
        rset.insertRow();
        rset.moveToCurrentRow();
        assertEquals(1, rset.getInt(1));
        assertTrue(rset.last());
        assertEquals(5, rset.getInt(1));


        /*

View Full Code Here

0 1 2 3

TOP

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.