List of updateNull() Examples

Examples of updateNull()

com.sun.star.sdb.XColumnUpdate.updateNull()
java.sql.ResultSet.updateNull()
Updates a column specified by a column index with a null value. @param columnIndex the index of the column to update @throws SQLException if a database error happens
javax.sql.rowset.spi.SyncResolver.updateNull()

Examples of java.sql.ResultSet.updateNull()

        ResultSet rs = s.executeQuery("select * from t1");
        rs.absolute(5);
        final int oldCol2 = rs.getInt(2);
        final int oldCol3 = rs.getInt(3);
        
        rs.updateNull(2);
        assertEquals("Expected the resultset to be updated after updateNull",
                     0, rs.getInt(2));
        assertTrue("Expected wasNull to be true after updateNull", rs.wasNull());
        rs.cancelRowUpdates();
        assertEquals("Expected updateXXX to have no effect after cancelRowUpdated",

View Full Code Here

Examples of java.sql.ResultSet.updateNull()

        try {
          ResultSet rs = stmt.executeQuery(query);
          if (rs.next()) {
            // This connector property exists, update the property value.
            if (fieldValue == null) {
              rs.updateNull(propertyValueColumn);
            } else {
              rs.updateString(propertyValueColumn, fieldValue);
            }
            // Bump the ModifyStamp, so others may know the value has changed.
            rs.updateInt(modifyStampColumn, rs.getInt(modifyStampColumn) + 1);

View Full Code Here

Examples of java.sql.ResultSet.updateNull()

            rs.moveToInsertRow();
            rs.updateInt(modifyStampColumn, 1); // Bootstrap the ModifyStamp
            rs.updateString(connectorNameColumn, context.getConnectorName());
            rs.updateString(propertyNameColumn, fieldName);
            if (fieldValue == null) {
              rs.updateNull(propertyValueColumn);
            } else {
              rs.updateString(propertyValueColumn, fieldValue);
            }
            rs.insertRow();
          }

View Full Code Here

Examples of java.sql.ResultSet.updateNull()

            rs.updateAsciiStream("F13", null, 0);
            rs.updateAsciiStream("F13", null, 0L);
            rs.updateCharacterStream("F14", null);
            rs.updateCharacterStream("F14", null, 0);
            rs.updateCharacterStream("F14", null, 0L);
            rs.updateNull("F14");
            rs.updateObject("F15", "object");
            rs.updateObject("F15", "object", 0);
            rs.updateBoolean("F17", false);
            rs.cancelRowUpdates();
            rs.deleteRow();

View Full Code Here

Examples of java.sql.ResultSet.updateNull()

            rs.updateAsciiStream(13, null, 0);
            rs.updateAsciiStream(13, null, 0L);
            rs.updateCharacterStream(14, null);
            rs.updateCharacterStream(14, null, 0);
            rs.updateCharacterStream(14, null, 0L);
            rs.updateNull(14);
            rs.updateObject(15, "object");
            rs.updateObject(15, "object", 0);
            rs.updateBoolean(17, false);
            rs.updateRow();

View Full Code Here

Examples of javax.sql.rowset.spi.SyncResolver.updateNull()

            fail("should throw UnsupportedOperationException");
        } catch (UnsupportedOperationException e) {
            // expected
        }
        try {
            resolver.updateNull(100);
            fail("should throw UnsupportedOperationException");
        } catch (UnsupportedOperationException e) {
            // expected
        }
        try {

View Full Code Here

Examples of javax.sql.rowset.spi.SyncResolver.updateNull()

            fail("should throw UnsupportedOperationException");
        } catch (UnsupportedOperationException e) {
            // expected
        }
        try {
            resolver.updateNull("not");
            fail("should throw UnsupportedOperationException");
        } catch (UnsupportedOperationException e) {
            // expected
        }
        try {

View Full Code Here

0 1 2 3 4

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.