List of rowDeleted() Examples

Examples of rowDeleted()

com.sun.star.sdbc.XResultSet.rowDeleted()
java.sql.ResultSet.rowDeleted()
Indicates whether a row has been deleted. This method depends on whether the JDBC driver and database can detect deletions. @return true if a row has been deleted and if deletions are detected,false otherwise. @throws SQLException if a database error happens
javax.sql.rowset.CachedRowSet.rowDeleted()
javax.sql.rowset.WebRowSet.rowDeleted()
javax.sql.rowset.spi.SyncResolver.rowDeleted()
org.apache.harmony.sql.internal.rowset.SyncResolverImpl.rowDeleted()

Examples of java.sql.ResultSet.rowDeleted()


            // if we were asked not to return data, mark QRYDTA null; do not
            // return yet, need to make rowCount right
            // if the row has been deleted return QRYDTA null (delete hole)
            boolean noRetrieveRS = (rs != null && 
                    (!stmt.getQryrtndta() || rs.rowDeleted()));
            if (noRetrieveRS) {
                writer.writeByte(0xFF);  //QRYDTA null indicator: IS NULL
            } else {
                writer.writeByte(0);  //QRYDTA null indicator: not null
            }

View Full Code Here

Examples of java.sql.ResultSet.rowDeleted()

        rs.deleteRow();


        // .. and see that a hole is left in its place
        rs.previous();
        rs.next();
        assertTrue(rs.rowDeleted());


        rs.close();


        queryAndCheck(
            stm,

View Full Code Here

Examples of java.sql.ResultSet.rowDeleted()

        rs.updateRow();
        
        SQLWarning warn = rs.getWarnings();
        assertWarning(warn, CURSOR_OPERATION_CONFLICT);
        assertEquals("Did not expect the resultset to be updated", oldValue, rs.getInt(2));
        assertTrue("Expected rs.rowDeleted() to be false", !rs.rowDeleted());
        assertTrue("Expected rs.rowUpdated() to be false", !rs.rowUpdated());
        
        rs.clearWarnings();
        rs.deleteRow();
        warn = rs.getWarnings();

View Full Code Here

Examples of java.sql.ResultSet.rowDeleted()

        rs.deleteRow();
        warn = rs.getWarnings();
        assertWarning(warn, CURSOR_OPERATION_CONFLICT);
        rs.relative(0);
        assertTrue("Expected rs.rowUpdated() to be false", !rs.rowUpdated());
        assertTrue("Expected rs.rowDeleted() to be false", !rs.rowDeleted());
        assertEquals("Did not expect the resultset to be updated", oldValue, rs.getInt(2));
        
        rs.close();
        s.close();
    }

View Full Code Here

Examples of java.sql.ResultSet.rowDeleted()

        
        rs.relative(0);
        SQLWarning warn = s3.getWarnings();
        assertWarning(warn, CURSOR_OPERATION_CONFLICT);
        assertTrue("Expected rs.rowUpdated() to be false", !rs.rowUpdated());
        assertTrue("Expected rs.rowDeleted() to be false", !rs.rowDeleted());
        assertEquals("Did not expect the resultset to be updated", oldValue, rs.getInt(2));
        assertEquals("Expected update count to be 0", 0, updateCount);
        
        Statement s4 = createStatement();
        updateCount = s4.executeUpdate("delete from t1 where current of " +

View Full Code Here

Examples of java.sql.ResultSet.rowDeleted()

        
        rs.relative(0);
        warn = s4.getWarnings();
        assertWarning(warn, CURSOR_OPERATION_CONFLICT);
        assertTrue("Expected rs.rowUpdated() to be false", !rs.rowUpdated());
        assertTrue("Expected rs.rowDeleted() to be false", !rs.rowDeleted());
        assertEquals("Did not expect the resultset to be updated", oldValue, rs.getInt(2));
        assertEquals("Expected update count to be 0", 0, updateCount);
        
        rs.close();
        s.close();

View Full Code Here

Examples of java.sql.ResultSet.rowDeleted()

        }
      }
      // Delete holes are manifest as a row consisting of a non-null
      // SQLCARD and a null data group. The SQLCARD has a warning
      // SQLSTATE of 02502
      if (rs != null && rs.rowDeleted()) {
        SQLWarning w = new SQLWarning("", SQLState.ROW_DELETED,
            ExceptionSeverity.WARNING_SEVERITY);
        if (sqlw != null) {
          sqlw.setNextWarning(w);
        } else {

View Full Code Here

Examples of javax.sql.rowset.CachedRowSet.rowDeleted()

        crset2.deleteRow();


        crset2.beforeFirst();
        while (crset2.next()) {
            if (crset2.getInt(1) == 4) {
                assertTrue(crset2.rowDeleted());
            }
        }


        jrs.addRowSet(crset2, 1);

View Full Code Here

Examples of javax.sql.rowset.WebRowSet.rowDeleted()

         * any more after populate to WebRowSet.
         */
        if (!"true".equals(System.getProperty("Testing Harmony"))) {
            assertTrue(webRs.absolute(3));
            assertEquals(3, webRs.getInt(1));
            assertFalse(webRs.rowDeleted());
            webRs.deleteRow();
        }


        Document srcDoc = DocumentBuilderFactory.newInstance()
                .newDocumentBuilder().parse(currentUrl);

View Full Code Here

Examples of javax.sql.rowset.WebRowSet.rowDeleted()

         * any more after populating to WebRowSet.
         */
        if (!"true".equals(System.getProperty("Testing Harmony"))) {
            assertTrue(webRs.absolute(3));
            assertEquals(3, webRs.getInt(1));
            assertFalse(webRs.rowDeleted());
            webRs.deleteRow();
        }


        Document srcDoc = DocumentBuilderFactory.newInstance()
                .newDocumentBuilder().parse(currentUrl);

View Full Code Here

0 1 2 3 4 5

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.