Java Code Examples for javax.sql.rowset.CachedRowSet#updateBoolean()
The following examples show how to use
javax.sql.rowset.CachedRowSet#updateBoolean() .
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 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 2
| Source File: CommonCachedRowSetTests.java From jdk8u_jdk 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 3
| 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 4
| Source File: CommonCachedRowSetTests.java From hottub 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 5
| Source File: CommonCachedRowSetTests.java From hottub 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 6
| Source File: CommonCachedRowSetTests.java From jdk8u-jdk 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 7
| 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 8
| Source File: CommonCachedRowSetTests.java From openjdk-jdk9 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 9
| Source File: CommonCachedRowSetTests.java From openjdk-jdk9 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 10
| Source File: CommonCachedRowSetTests.java From dragonwell8_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 11
| Source File: CommonCachedRowSetTests.java From openjdk-jdk8u-backup 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 12
| Source File: CommonCachedRowSetTests.java From openjdk-jdk8u 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 13
| Source File: CommonCachedRowSetTests.java From openjdk-jdk8u 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 14
| Source File: CommonCachedRowSetTests.java From jdk8u60 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 15
| Source File: CommonCachedRowSetTests.java From jdk8u60 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 16
| 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 17
| Source File: CommonCachedRowSetTests.java From TencentKona-8 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 18
| Source File: CommonCachedRowSetTests.java From dragonwell8_jdk 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;
}
}
