Examples of java.sql.ResultSet.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

        }
      }
      // 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


      // 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

        }
      }
      // 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


      // 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

        }
      }
      // 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


      // 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

        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

        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

        
        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

        
        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

0 1 2 3 4 5 6 7 8

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.