Examples of java.sql.ResultSet.insertRow()

java.sql.ResultSet.insertRow()
Insert the insert row into the ResultSet and into the underlying database. The Cursor must be set to the Insert Row before this method is invoked. @throws SQLException if a database error happens. Particular cases include the Cursor not being on the Insert Row or if any Columns in the Row do not have a value where the column is declared as not-nullable.

        
        // Test moveToInsertRow + insertRow
        rs.moveToInsertRow();
        rs.updateInt(1, 5);
        rs.updateInt(2, 5);
        rs.insertRow();
        
        // Test getXXX on insertRow
        c41 = rs.getInt(1);
        c42 = rs.getInt(2);
        assertEquals("FAIL - wrong value for column c41", 5, c41);

View Full Code Here

        
        // Test insertRow without setting value for NOT NULL column
        rs.moveToInsertRow();
        rs.updateInt(2, 7);
        try {
            rs.insertRow();
            fail("FAIL - should have failed can not insert NULL into " +
                    "not null column");
        } catch (SQLException se) {
            assertSQLState("23502", se);
        }

View Full Code Here

        ResultSet rs = stmt.executeQuery("SELECT * FROM t4");
        assertTrue("FAIL - row not found", rs.next());
        
        rs.moveToCurrentRow();
        try {
            rs.insertRow();
            fail("FAIL - insert row not allowed from current row");
        } catch (SQLException se) {
            assertSQLState("XJ086", se);
        }
        rs.close();

View Full Code Here

        
        rs = stmt.executeQuery("SELECT * FROM t4 WHERE c41 <= 5");
        rs.moveToInsertRow();
        rs.updateInt(1, 1000);
        rs.updateInt(2, 1000);
        rs.insertRow();
        while (rs.next()) {
            c41 = rs.getInt(1);
            c42 = rs.getInt(2);
            rs.moveToInsertRow();
            rs.updateInt(1, c41 + 100);

View Full Code Here

            c41 = rs.getInt(1);
            c42 = rs.getInt(2);
            rs.moveToInsertRow();
            rs.updateInt(1, c41 + 100);
            rs.updateInt(2, c42 + 100);
            rs.insertRow();
        }
        rs.moveToInsertRow();
        rs.updateInt(1, 2000);
        rs.updateInt(2, 2000);
        rs.insertRow();

View Full Code Here

            rs.insertRow();
        }
        rs.moveToInsertRow();
        rs.updateInt(1, 2000);
        rs.updateInt(2, 2000);
        rs.insertRow();
        rs.close();
        
        String[][] expected = {
            {"1", "1"},
            {"2", "2"},

View Full Code Here

                    } else {
                        continue;
                    }
                }
                
                rs.insertRow();
                
                if ((usingDerbyNetClient() && 
                        !updateXXXRulesTableForNetworkClient[sqlType-1][updateXXXName-1].equals("PASS")) ||
                    (usingEmbedded() && 
                        !updateXXXRulesTableForEmbedded[sqlType-1][updateXXXName-1].equals("PASS")))

View Full Code Here


        // Insert a row
        rs.moveToInsertRow();
        rs.updateInt(1,42);
        rs.updateInt(2,42);
        rs.insertRow();


        // Delete a row
        rs.previous();
        rs.deleteRow();

View Full Code Here

//            assertTrue(rs.rowUpdated()); // MS API cursors appear not to support this
            rs.moveToInsertRow();
            rs.updateInt(1, 17);
            rs.updateString(2, "XXXX");
            rs.updateString(3, "LINE 17");
            rs.insertRow();
            rs.moveToCurrentRow();
            rs.last();
//            assertTrue(rs.rowInserted()); // MS API cursors appear not to support this
            Statement stmt2 = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY);
            ResultSet rs2 = stmt2.executeQuery("SELECT * FROM jTDS_CachedCursorTest ORDER BY key1");

View Full Code Here

      Statement stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE);
      ResultSet rs = stmt.executeQuery("SELECT id, ts FROM updateable");
      rs.moveToInsertRow();
      rs.updateInt(1, 1);
      rs.updateTimestamp(2, ts);
      rs.insertRow();
      assertTrue(rs.first());
      assertEquals(ts, rs.getTimestamp(2));
    }
    finally {
      TimeZone.setDefault(origTZ);

View Full Code Here

0 1 2 3 4 5 6 7 8 9

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.