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


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

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

        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

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.