Java Code Examples for javax.sql.rowset.CachedRowSet#beforeFirst()

The following examples show how to use javax.sql.rowset.CachedRowSet#beforeFirst() . You can vote up the ones you like or vote down the ones you don't like, and go to the original project or source file by following the links above each example. You may check out the related API usage on the sidebar.

Example 1

Source File: CommonCachedRowSetTests.java From TencentKona-8 with GNU General Public License v2.0

6 votes

@Test(dataProvider = "rowsetUsingCoffees", enabled = true)
public void commonCachedRowSetTest0059(CachedRowSet rs) throws Exception {
    int rowToDelete = 2;
    try (CachedRowSet crs1 = rsf.createCachedRowSet()) {
        rs.beforeFirst();
        crs1.populate(rs);
        TestRowSetListener rsl = new TestRowSetListener();
        crs1.addRowSetListener(rsl);
        // Delete a row, the PK is also the absolute position as a List
        // backs the RowSet
        crs1.absolute(rowToDelete);
        crs1.deleteRow();
        assertTrue(crs1.rowDeleted());
        assertFalse(findRowByPrimaryKey(crs1, rowToDelete, 1));
        // Restore back to our original state and the
        // previously deleted row should be there
        rsl.resetFlag();
        crs1.restoreOriginal();
        assertTrue(rsl.isNotified(TestRowSetListener.ROWSET_CHANGED));
        assertTrue(crs1.isBeforeFirst());
        crs1.absolute(rowToDelete);
        assertFalse(crs1.rowDeleted());
        assertTrue(findRowByPrimaryKey(crs1, rowToDelete, 1));
    }
    rs.close();
}

Example 2

Source File: CommonCachedRowSetTests.java From dragonwell8_jdk with GNU General Public License v2.0

6 votes

@Test(dataProvider = "rowsetUsingCoffees", enabled = true)
public void commonCachedRowSetTest0059(CachedRowSet rs) throws Exception {
    int rowToDelete = 2;
    try (CachedRowSet crs1 = rsf.createCachedRowSet()) {
        rs.beforeFirst();
        crs1.populate(rs);
        TestRowSetListener rsl = new TestRowSetListener();
        crs1.addRowSetListener(rsl);
        // Delete a row, the PK is also the absolute position as a List
        // backs the RowSet
        crs1.absolute(rowToDelete);
        crs1.deleteRow();
        assertTrue(crs1.rowDeleted());
        assertFalse(findRowByPrimaryKey(crs1, rowToDelete, 1));
        // Restore back to our original state and the
        // previously deleted row should be there
        rsl.resetFlag();
        crs1.restoreOriginal();
        assertTrue(rsl.isNotified(TestRowSetListener.ROWSET_CHANGED));
        assertTrue(crs1.isBeforeFirst());
        crs1.absolute(rowToDelete);
        assertFalse(crs1.rowDeleted());
        assertTrue(findRowByPrimaryKey(crs1, rowToDelete, 1));
    }
    rs.close();
}

Example 3

Source File: CommonCachedRowSetTests.java From openjdk-jdk8u-backup with GNU General Public License v2.0

6 votes

@Test(dataProvider = "rowsetUsingCoffees", enabled = true)
public void commonCachedRowSetTest0059(CachedRowSet rs) throws Exception {
    int rowToDelete = 2;
    try (CachedRowSet crs1 = rsf.createCachedRowSet()) {
        rs.beforeFirst();
        crs1.populate(rs);
        TestRowSetListener rsl = new TestRowSetListener();
        crs1.addRowSetListener(rsl);
        // Delete a row, the PK is also the absolute position as a List
        // backs the RowSet
        crs1.absolute(rowToDelete);
        crs1.deleteRow();
        assertTrue(crs1.rowDeleted());
        assertFalse(findRowByPrimaryKey(crs1, rowToDelete, 1));
        // Restore back to our original state and the
        // previously deleted row should be there
        rsl.resetFlag();
        crs1.restoreOriginal();
        assertTrue(rsl.isNotified(TestRowSetListener.ROWSET_CHANGED));
        assertTrue(crs1.isBeforeFirst());
        crs1.absolute(rowToDelete);
        assertFalse(crs1.rowDeleted());
        assertTrue(findRowByPrimaryKey(crs1, rowToDelete, 1));
    }
    rs.close();
}

Example 4

Source File: CommonCachedRowSetTests.java From openjdk-jdk9 with GNU General Public License v2.0

5 votes

@Test(dataProvider = "rowsetUsingCoffeeHouses",
        expectedExceptions = SQLException.class)
public void commonCachedRowSetTest0045(CachedRowSet rs) throws Exception {
    rs.setShowDeleted(true);
    rs.beforeFirst();
    rs.undoDelete();
    rs.close();
}

Example 5

Source File: CommonCachedRowSetTests.java From TencentKona-8 with GNU General Public License v2.0

5 votes

@Test(dataProvider = "rowsetUsingCoffeeHouses",
        expectedExceptions = SQLException.class)
public void commonCachedRowSetTest0051(CachedRowSet rs) throws Exception {
    rs.setShowDeleted(true);
    rs.beforeFirst();
    rs.undoInsert();
    rs.close();
}

Example 6

Source File: CommonCachedRowSetTests.java From hottub with GNU General Public License v2.0

5 votes

@Test(dataProvider = "rowsetUsingCoffeeHouses")
public void commonCachedRowSetTest0034(CachedRowSet rs) throws Exception {
    Object[] cities = {"Mendocino", "Seattle", "SF", "Portland", "SF",
        "Sacramento", "Carmel", "LA", "Olympia", "Seattle", "SF",
        "LA", "San Jose", "Eugene"};
    rs.beforeFirst();
    assertEquals(rs.toCollection(2).toArray(), cities);
    assertEquals(rs.toCollection("CITY").toArray(), cities);
    rs.close();
}

Example 7

Source File: CommonCachedRowSetTests.java From TencentKona-8 with GNU General Public License v2.0

5 votes

@Test(dataProvider = "rowsetUsingCoffeeHouses",
        expectedExceptions = SQLException.class)
public void commonCachedRowSetTest0045(CachedRowSet rs) throws Exception {
    rs.setShowDeleted(true);
    rs.beforeFirst();
    rs.undoDelete();
    rs.close();
}

Example 8

Source File: CommonCachedRowSetTests.java From openjdk-jdk9 with GNU General Public License v2.0

5 votes

@Test(dataProvider = "rowsetUsingCoffeeHouses")
public void commonCachedRowSetTest0058(CachedRowSet rs) throws Exception {
    int rowToInsert = 1961;
    assertTrue(rs.size() == COFFEE_HOUSES_ROWS);
    try ( // Add new row
            CachedRowSet crs1 = rsf.createCachedRowSet()) {
        rs.beforeFirst();
        crs1.populate(rs);
        TestRowSetListener rsl = new TestRowSetListener();
        crs1.addRowSetListener(rsl);
        crs1.moveToInsertRow();
        crs1.updateInt(1, rowToInsert);
        crs1.updateString(2, "GOTHAM");
        crs1.updateInt(3, 3450);
        crs1.updateInt(4, 2005);
        crs1.updateInt(5, 5455);
        crs1.insertRow();
        assertTrue(rsl.isNotified(TestRowSetListener.ROW_CHANGED));
        crs1.moveToCurrentRow();
        assertTrue(findRowByPrimaryKey(crs1, rowToInsert, 1));
        // Restore back to our original state and the
        // previously inserted row should not be there
        rsl.resetFlag();
        crs1.restoreOriginal();
        assertTrue(rsl.isNotified(TestRowSetListener.ROWSET_CHANGED));
        assertTrue(crs1.isBeforeFirst());
        crs1.last();
        assertFalse(crs1.rowInserted());
        assertFalse(findRowByPrimaryKey(crs1, rowToInsert, 1));
    }
    rs.close();
}

Example 9

Source File: CommonCachedRowSetTests.java From jdk8u-jdk with GNU General Public License v2.0

5 votes

@Test(dataProvider = "rowsetUsingCoffeeHouses",
        expectedExceptions = SQLException.class)
public void commonCachedRowSetTest0051(CachedRowSet rs) throws Exception {
    rs.setShowDeleted(true);
    rs.beforeFirst();
    rs.undoInsert();
    rs.close();
}

Example 10

Source File: CommonCachedRowSetTests.java From jdk8u-jdk with GNU General Public License v2.0

5 votes

@Test(dataProvider = "rowsetUsingCoffees", enabled = true)
public void commonCachedRowSetTest0060(CachedRowSet rs) throws Exception {
    int rowToUpdate = 2;
    String coffee = "Hazelnut";
    try (CachedRowSet crs1 = rsf.createCachedRowSet()) {
        rs.beforeFirst();
        crs1.populate(rs);
        TestRowSetListener rsl = new TestRowSetListener();
        crs1.addRowSetListener(rsl);
        // Delete a row, the PK is also the absolute position as a List
        // backs the RowSet
        crs1.absolute(rowToUpdate);
        String origCoffee = crs1.getString(2);
        crs1.updateString(2, coffee);
        assertTrue(crs1.columnUpdated(2));
        crs1.updateRow();
        assertTrue(crs1.rowUpdated());
        assertFalse(origCoffee.equals(crs1.getString(2)));
        // Restore back to our original state and the
        // previous value for the column within the row should be there
        rsl.resetFlag();
        crs1.restoreOriginal();
        assertTrue(rsl.isNotified(TestRowSetListener.ROWSET_CHANGED));
        assertTrue(crs1.isBeforeFirst());
        // absolute() is failing for some reason so need to look at this later
        crs1.next();
        crs1.next();
        assertFalse(crs1.columnUpdated(2));
        assertFalse(crs1.rowUpdated());
        assertTrue(origCoffee.equals(crs1.getString(2)));
    }
    rs.close();
}

Example 11

Source File: CommonCachedRowSetTests.java From openjdk-jdk8u with GNU General Public License v2.0

5 votes

@Test(dataProvider = "rowsetUsingCoffeeHouses",
        expectedExceptions = SQLException.class)
public void commonCachedRowSetTest0045(CachedRowSet rs) throws Exception {
    rs.setShowDeleted(true);
    rs.beforeFirst();
    rs.undoDelete();
    rs.close();
}

Example 12

Source File: CommonCachedRowSetTests.java From jdk8u60 with GNU General Public License v2.0

5 votes

@Test(dataProvider = "rowsetUsingCoffeeHouses",
        expectedExceptions = SQLException.class)
public void commonCachedRowSetTest0045(CachedRowSet rs) throws Exception {
    rs.setShowDeleted(true);
    rs.beforeFirst();
    rs.undoDelete();
    rs.close();
}

Example 13

Source File: CommonCachedRowSetTests.java From openjdk-jdk8u with GNU General Public License v2.0

5 votes

@Test(dataProvider = "rowsetUsingCoffeeHouses")
public void commonCachedRowSetTest0062(CachedRowSet rs) throws Exception {
    Object[] expectedRows = {
        32001, 10042, 10024, 10039, 10041, 33005, 33010, 10035, 10037,
        10034, 32004
    };
    int startingRow = 4;
    try (CachedRowSet crs1 = rsf.createCachedRowSet()) {
        rs.beforeFirst();
        crs1.populate(rs, startingRow);
        assertEquals(crs1.size(), COFFEE_HOUSES_ROWS - startingRow + 1);
        assertEquals(getPrimaryKeys(crs1), expectedRows);
    }
    rs.close();
}

Example 14

Source File: CommonCachedRowSetTests.java From jdk8u60 with GNU General Public License v2.0

5 votes

@Test(dataProvider = "rowsetUsingCoffeeHouses")
public void commonCachedRowSetTest0061(CachedRowSet rs) throws Exception {
    try (CachedRowSet crs1 = rsf.createCachedRowSet()) {
        rs.beforeFirst();
        crs1.populate(rs);
        compareRowSets(rs, crs1);
    }
    rs.close();
}

Example 15

Source File: CommonCachedRowSetTests.java From hottub with GNU General Public License v2.0

5 votes

@Test(dataProvider = "rowsetUsingCoffeeHouses")
public void commonCachedRowSetTest0061(CachedRowSet rs) throws Exception {
    try (CachedRowSet crs1 = rsf.createCachedRowSet()) {
        rs.beforeFirst();
        crs1.populate(rs);
        compareRowSets(rs, crs1);
    }
    rs.close();
}

Example 16

Source File: CommonCachedRowSetTests.java From openjdk-jdk8u-backup with GNU General Public License v2.0

5 votes

@Test(dataProvider = "rowsetUsingCoffeeHouses")
public void commonCachedRowSetTest0062(CachedRowSet rs) throws Exception {
    Object[] expectedRows = {
        32001, 10042, 10024, 10039, 10041, 33005, 33010, 10035, 10037,
        10034, 32004
    };
    int startingRow = 4;
    try (CachedRowSet crs1 = rsf.createCachedRowSet()) {
        rs.beforeFirst();
        crs1.populate(rs, startingRow);
        assertEquals(crs1.size(), COFFEE_HOUSES_ROWS - startingRow + 1);
        assertEquals(getPrimaryKeys(crs1), expectedRows);
    }
    rs.close();
}

Example 17

Source File: CommonCachedRowSetTests.java From openjdk-jdk8u-backup with GNU General Public License v2.0

4 votes

@Test(dataProvider = "rowsetUsingDataTypes")
public void commonCachedRowSetTest0041(CachedRowSet rs, JDBCType type) throws Exception {
    rs.beforeFirst();
    assertTrue(rs.next());
    switch (type) {
        case INTEGER:
            assertFalse(rs.columnUpdated(DATATYPES_COLUMN_NAMES[0]));
            rs.updateInt(DATATYPES_COLUMN_NAMES[0], Integer.MIN_VALUE);
            assertTrue(rs.columnUpdated(DATATYPES_COLUMN_NAMES[0]));
            break;
        case CHAR:
            assertFalse(rs.columnUpdated(DATATYPES_COLUMN_NAMES[1]));
            rs.updateString(DATATYPES_COLUMN_NAMES[1], "foo");
            assertTrue(rs.columnUpdated(DATATYPES_COLUMN_NAMES[1]));
            break;
        case VARCHAR:
            assertFalse(rs.columnUpdated(DATATYPES_COLUMN_NAMES[2]));
            rs.updateString(DATATYPES_COLUMN_NAMES[2], "foo");
            assertTrue(rs.columnUpdated(DATATYPES_COLUMN_NAMES[2]));
            break;
        case BIGINT:
            assertFalse(rs.columnUpdated(DATATYPES_COLUMN_NAMES[3]));
            rs.updateLong(DATATYPES_COLUMN_NAMES[3], Long.MIN_VALUE);
            assertTrue(rs.columnUpdated(DATATYPES_COLUMN_NAMES[3]));
            break;
        case BOOLEAN:
            assertFalse(rs.columnUpdated(DATATYPES_COLUMN_NAMES[4]));
            rs.updateBoolean(DATATYPES_COLUMN_NAMES[4], false);
            assertTrue(rs.columnUpdated(DATATYPES_COLUMN_NAMES[4]));
            break;
        case SMALLINT:
            assertFalse(rs.columnUpdated(DATATYPES_COLUMN_NAMES[5]));
            rs.updateShort(DATATYPES_COLUMN_NAMES[5], Short.MIN_VALUE);
            assertTrue(rs.columnUpdated(DATATYPES_COLUMN_NAMES[5]));
            break;
        case DOUBLE:
            assertFalse(rs.columnUpdated(DATATYPES_COLUMN_NAMES[6]));
            rs.updateDouble(DATATYPES_COLUMN_NAMES[6], Double.MIN_VALUE);
            assertTrue(rs.columnUpdated(DATATYPES_COLUMN_NAMES[6]));
            break;
        case DECIMAL:
            assertFalse(rs.columnUpdated(DATATYPES_COLUMN_NAMES[7]));
            rs.updateBigDecimal(DATATYPES_COLUMN_NAMES[7], BigDecimal.TEN);
            assertTrue(rs.columnUpdated(DATATYPES_COLUMN_NAMES[7]));
            break;
        case REAL:
            assertFalse(rs.columnUpdated(DATATYPES_COLUMN_NAMES[8]));
            rs.updateFloat(DATATYPES_COLUMN_NAMES[8], Float.MIN_VALUE);
            assertTrue(rs.columnUpdated(DATATYPES_COLUMN_NAMES[8]));
            break;
        case TINYINT:
            assertFalse(rs.columnUpdated(DATATYPES_COLUMN_NAMES[9]));
            rs.updateByte(DATATYPES_COLUMN_NAMES[9], Byte.MIN_VALUE);
            assertTrue(rs.columnUpdated(DATATYPES_COLUMN_NAMES[9]));
            break;
        case DATE:
            assertFalse(rs.columnUpdated(DATATYPES_COLUMN_NAMES[10]));
            rs.updateDate(DATATYPES_COLUMN_NAMES[10], Date.valueOf(LocalDate.now()));
            assertTrue(rs.columnUpdated(DATATYPES_COLUMN_NAMES[10]));
            break;
        case TIME:
            assertFalse(rs.columnUpdated(DATATYPES_COLUMN_NAMES[11]));
            rs.updateTime(DATATYPES_COLUMN_NAMES[11], Time.valueOf(LocalTime.now()));
            assertTrue(rs.columnUpdated(DATATYPES_COLUMN_NAMES[11]));
            break;
        case TIMESTAMP:
            assertFalse(rs.columnUpdated(DATATYPES_COLUMN_NAMES[12]));
            rs.updateTimestamp(DATATYPES_COLUMN_NAMES[12], Timestamp.valueOf(LocalDateTime.now()));
            assertTrue(rs.columnUpdated(DATATYPES_COLUMN_NAMES[12]));
            break;
        case VARBINARY:
            assertFalse(rs.columnUpdated(DATATYPES_COLUMN_NAMES[13]));
            rs.updateBytes(DATATYPES_COLUMN_NAMES[13], new byte[1]);
            assertTrue(rs.columnUpdated(DATATYPES_COLUMN_NAMES[13]));
            break;
        case ARRAY:
            assertFalse(rs.columnUpdated(DATATYPES_COLUMN_NAMES[14]));
            rs.updateArray(DATATYPES_COLUMN_NAMES[14], new StubArray("VARCHAR", new Object[10]));
            assertTrue(rs.columnUpdated(DATATYPES_COLUMN_NAMES[14]));
            break;
        case REF:
            assertFalse(rs.columnUpdated(DATATYPES_COLUMN_NAMES[15]));
            rs.updateRef(DATATYPES_COLUMN_NAMES[15], new StubRef("INTEGER", query));
            assertTrue(rs.columnUpdated(DATATYPES_COLUMN_NAMES[15]));
            break;
        case FLOAT:
            assertFalse(rs.columnUpdated(DATATYPES_COLUMN_NAMES[16]));
            rs.updateDouble(DATATYPES_COLUMN_NAMES[16], Double.MIN_NORMAL);
            assertTrue(rs.columnUpdated(DATATYPES_COLUMN_NAMES[16]));
            break;
    }

}

Example 18

Source File: CommonCachedRowSetTests.java From TencentKona-8 with GNU General Public License v2.0

4 votes

@Test(dataProvider = "rowsetUsingDataTypes")
public void commonCachedRowSetTest0041(CachedRowSet rs, JDBCType type) throws Exception {
    rs.beforeFirst();
    assertTrue(rs.next());
    switch (type) {
        case INTEGER:
            assertFalse(rs.columnUpdated(DATATYPES_COLUMN_NAMES[0]));
            rs.updateInt(DATATYPES_COLUMN_NAMES[0], Integer.MIN_VALUE);
            assertTrue(rs.columnUpdated(DATATYPES_COLUMN_NAMES[0]));
            break;
        case CHAR:
            assertFalse(rs.columnUpdated(DATATYPES_COLUMN_NAMES[1]));
            rs.updateString(DATATYPES_COLUMN_NAMES[1], "foo");
            assertTrue(rs.columnUpdated(DATATYPES_COLUMN_NAMES[1]));
            break;
        case VARCHAR:
            assertFalse(rs.columnUpdated(DATATYPES_COLUMN_NAMES[2]));
            rs.updateString(DATATYPES_COLUMN_NAMES[2], "foo");
            assertTrue(rs.columnUpdated(DATATYPES_COLUMN_NAMES[2]));
            break;
        case BIGINT:
            assertFalse(rs.columnUpdated(DATATYPES_COLUMN_NAMES[3]));
            rs.updateLong(DATATYPES_COLUMN_NAMES[3], Long.MIN_VALUE);
            assertTrue(rs.columnUpdated(DATATYPES_COLUMN_NAMES[3]));
            break;
        case BOOLEAN:
            assertFalse(rs.columnUpdated(DATATYPES_COLUMN_NAMES[4]));
            rs.updateBoolean(DATATYPES_COLUMN_NAMES[4], false);
            assertTrue(rs.columnUpdated(DATATYPES_COLUMN_NAMES[4]));
            break;
        case SMALLINT:
            assertFalse(rs.columnUpdated(DATATYPES_COLUMN_NAMES[5]));
            rs.updateShort(DATATYPES_COLUMN_NAMES[5], Short.MIN_VALUE);
            assertTrue(rs.columnUpdated(DATATYPES_COLUMN_NAMES[5]));
            break;
        case DOUBLE:
            assertFalse(rs.columnUpdated(DATATYPES_COLUMN_NAMES[6]));
            rs.updateDouble(DATATYPES_COLUMN_NAMES[6], Double.MIN_VALUE);
            assertTrue(rs.columnUpdated(DATATYPES_COLUMN_NAMES[6]));
            break;
        case DECIMAL:
            assertFalse(rs.columnUpdated(DATATYPES_COLUMN_NAMES[7]));
            rs.updateBigDecimal(DATATYPES_COLUMN_NAMES[7], BigDecimal.TEN);
            assertTrue(rs.columnUpdated(DATATYPES_COLUMN_NAMES[7]));
            break;
        case REAL:
            assertFalse(rs.columnUpdated(DATATYPES_COLUMN_NAMES[8]));
            rs.updateFloat(DATATYPES_COLUMN_NAMES[8], Float.MIN_VALUE);
            assertTrue(rs.columnUpdated(DATATYPES_COLUMN_NAMES[8]));
            break;
        case TINYINT:
            assertFalse(rs.columnUpdated(DATATYPES_COLUMN_NAMES[9]));
            rs.updateByte(DATATYPES_COLUMN_NAMES[9], Byte.MIN_VALUE);
            assertTrue(rs.columnUpdated(DATATYPES_COLUMN_NAMES[9]));
            break;
        case DATE:
            assertFalse(rs.columnUpdated(DATATYPES_COLUMN_NAMES[10]));
            rs.updateDate(DATATYPES_COLUMN_NAMES[10], Date.valueOf(LocalDate.now()));
            assertTrue(rs.columnUpdated(DATATYPES_COLUMN_NAMES[10]));
            break;
        case TIME:
            assertFalse(rs.columnUpdated(DATATYPES_COLUMN_NAMES[11]));
            rs.updateTime(DATATYPES_COLUMN_NAMES[11], Time.valueOf(LocalTime.now()));
            assertTrue(rs.columnUpdated(DATATYPES_COLUMN_NAMES[11]));
            break;
        case TIMESTAMP:
            assertFalse(rs.columnUpdated(DATATYPES_COLUMN_NAMES[12]));
            rs.updateTimestamp(DATATYPES_COLUMN_NAMES[12], Timestamp.valueOf(LocalDateTime.now()));
            assertTrue(rs.columnUpdated(DATATYPES_COLUMN_NAMES[12]));
            break;
        case VARBINARY:
            assertFalse(rs.columnUpdated(DATATYPES_COLUMN_NAMES[13]));
            rs.updateBytes(DATATYPES_COLUMN_NAMES[13], new byte[1]);
            assertTrue(rs.columnUpdated(DATATYPES_COLUMN_NAMES[13]));
            break;
        case ARRAY:
            assertFalse(rs.columnUpdated(DATATYPES_COLUMN_NAMES[14]));
            rs.updateArray(DATATYPES_COLUMN_NAMES[14], new StubArray("VARCHAR", new Object[10]));
            assertTrue(rs.columnUpdated(DATATYPES_COLUMN_NAMES[14]));
            break;
        case REF:
            assertFalse(rs.columnUpdated(DATATYPES_COLUMN_NAMES[15]));
            rs.updateRef(DATATYPES_COLUMN_NAMES[15], new StubRef("INTEGER", query));
            assertTrue(rs.columnUpdated(DATATYPES_COLUMN_NAMES[15]));
            break;
        case FLOAT:
            assertFalse(rs.columnUpdated(DATATYPES_COLUMN_NAMES[16]));
            rs.updateDouble(DATATYPES_COLUMN_NAMES[16], Double.MIN_NORMAL);
            assertTrue(rs.columnUpdated(DATATYPES_COLUMN_NAMES[16]));
            break;
    }

}

Example 19

Source File: CommonCachedRowSetTests.java From jdk8u_jdk with GNU General Public License v2.0

4 votes

@Test(dataProvider = "rowsetUsingDataTypes")
public void commonCachedRowSetTest0040(CachedRowSet rs, JDBCType type) throws Exception {
    rs.beforeFirst();
    assertTrue(rs.next());
    switch (type) {
        case INTEGER:
            assertFalse(rs.columnUpdated(1));
            rs.updateInt(1, Integer.MIN_VALUE);
            assertTrue(rs.columnUpdated(1));
            break;
        case CHAR:
            assertFalse(rs.columnUpdated(2));
            rs.updateString(2, "foo");
            assertTrue(rs.columnUpdated(2));
            break;
        case VARCHAR:
            assertFalse(rs.columnUpdated(3));
            rs.updateString(3, "foo");
            assertTrue(rs.columnUpdated(3));
            break;
        case BIGINT:
            assertFalse(rs.columnUpdated(4));
            rs.updateLong(4, Long.MIN_VALUE);
            assertTrue(rs.columnUpdated(4));
            break;
        case BOOLEAN:
            assertFalse(rs.columnUpdated(5));
            rs.updateBoolean(5, false);
            assertTrue(rs.columnUpdated(5));
            break;
        case SMALLINT:
            assertFalse(rs.columnUpdated(6));
            rs.updateShort(6, Short.MIN_VALUE);
            assertTrue(rs.columnUpdated(6));
            break;
        case DOUBLE:
            assertFalse(rs.columnUpdated(7));
            rs.updateDouble(7, Double.MIN_VALUE);
            assertTrue(rs.columnUpdated(7));
            break;
        case DECIMAL:
            assertFalse(rs.columnUpdated(8));
            rs.updateBigDecimal(8, BigDecimal.TEN);
            assertTrue(rs.columnUpdated(8));
            break;
        case REAL:
            assertFalse(rs.columnUpdated(9));
            rs.updateFloat(9, Float.MIN_VALUE);
            assertTrue(rs.columnUpdated(9));
            break;
        case TINYINT:
            assertFalse(rs.columnUpdated(10));
            rs.updateByte(10, Byte.MIN_VALUE);
            assertTrue(rs.columnUpdated(10));
            break;
        case DATE:
            assertFalse(rs.columnUpdated(11));
            rs.updateDate(11, Date.valueOf(LocalDate.now()));
            assertTrue(rs.columnUpdated(11));
            break;
        case TIME:
            assertFalse(rs.columnUpdated(12));
            rs.updateTime(12, Time.valueOf(LocalTime.now()));
            assertTrue(rs.columnUpdated(12));
            break;
        case TIMESTAMP:
            assertFalse(rs.columnUpdated(13));
            rs.updateTimestamp(13, Timestamp.valueOf(LocalDateTime.now()));
            assertTrue(rs.columnUpdated(13));
            break;
        case VARBINARY:
            assertFalse(rs.columnUpdated(14));
            rs.updateBytes(14, new byte[1]);
            assertTrue(rs.columnUpdated(14));
            break;
        case ARRAY:
            assertFalse(rs.columnUpdated(15));
            rs.updateArray(15, new StubArray("VARCHAR", new Object[10]));
            assertTrue(rs.columnUpdated(15));
            break;
        case REF:
            assertFalse(rs.columnUpdated(16));
            rs.updateRef(16, new StubRef("INTEGER", query));
            assertTrue(rs.columnUpdated(16));
            break;
        case FLOAT:
            assertFalse(rs.columnUpdated(17));
            rs.updateDouble(17, Double.MIN_NORMAL);
            assertTrue(rs.columnUpdated(17));
    }

}

Example 20

Source File: CommonCachedRowSetTests.java From jdk8u-jdk with GNU General Public License v2.0

4 votes

@Test(dataProvider = "rowsetUsingDataTypes")
public void commonCachedRowSetTest0040(CachedRowSet rs, JDBCType type) throws Exception {
    rs.beforeFirst();
    assertTrue(rs.next());
    switch (type) {
        case INTEGER:
            assertFalse(rs.columnUpdated(1));
            rs.updateInt(1, Integer.MIN_VALUE);
            assertTrue(rs.columnUpdated(1));
            break;
        case CHAR:
            assertFalse(rs.columnUpdated(2));
            rs.updateString(2, "foo");
            assertTrue(rs.columnUpdated(2));
            break;
        case VARCHAR:
            assertFalse(rs.columnUpdated(3));
            rs.updateString(3, "foo");
            assertTrue(rs.columnUpdated(3));
            break;
        case BIGINT:
            assertFalse(rs.columnUpdated(4));
            rs.updateLong(4, Long.MIN_VALUE);
            assertTrue(rs.columnUpdated(4));
            break;
        case BOOLEAN:
            assertFalse(rs.columnUpdated(5));
            rs.updateBoolean(5, false);
            assertTrue(rs.columnUpdated(5));
            break;
        case SMALLINT:
            assertFalse(rs.columnUpdated(6));
            rs.updateShort(6, Short.MIN_VALUE);
            assertTrue(rs.columnUpdated(6));
            break;
        case DOUBLE:
            assertFalse(rs.columnUpdated(7));
            rs.updateDouble(7, Double.MIN_VALUE);
            assertTrue(rs.columnUpdated(7));
            break;
        case DECIMAL:
            assertFalse(rs.columnUpdated(8));
            rs.updateBigDecimal(8, BigDecimal.TEN);
            assertTrue(rs.columnUpdated(8));
            break;
        case REAL:
            assertFalse(rs.columnUpdated(9));
            rs.updateFloat(9, Float.MIN_VALUE);
            assertTrue(rs.columnUpdated(9));
            break;
        case TINYINT:
            assertFalse(rs.columnUpdated(10));
            rs.updateByte(10, Byte.MIN_VALUE);
            assertTrue(rs.columnUpdated(10));
            break;
        case DATE:
            assertFalse(rs.columnUpdated(11));
            rs.updateDate(11, Date.valueOf(LocalDate.now()));
            assertTrue(rs.columnUpdated(11));
            break;
        case TIME:
            assertFalse(rs.columnUpdated(12));
            rs.updateTime(12, Time.valueOf(LocalTime.now()));
            assertTrue(rs.columnUpdated(12));
            break;
        case TIMESTAMP:
            assertFalse(rs.columnUpdated(13));
            rs.updateTimestamp(13, Timestamp.valueOf(LocalDateTime.now()));
            assertTrue(rs.columnUpdated(13));
            break;
        case VARBINARY:
            assertFalse(rs.columnUpdated(14));
            rs.updateBytes(14, new byte[1]);
            assertTrue(rs.columnUpdated(14));
            break;
        case ARRAY:
            assertFalse(rs.columnUpdated(15));
            rs.updateArray(15, new StubArray("VARCHAR", new Object[10]));
            assertTrue(rs.columnUpdated(15));
            break;
        case REF:
            assertFalse(rs.columnUpdated(16));
            rs.updateRef(16, new StubRef("INTEGER", query));
            assertTrue(rs.columnUpdated(16));
            break;
        case FLOAT:
            assertFalse(rs.columnUpdated(17));
            rs.updateDouble(17, Double.MIN_NORMAL);
            assertTrue(rs.columnUpdated(17));
    }

}