?? updatableresultset.out
字號:
{1}Verify that new data in table0WithTriggers C1,C2 -- -- {123,1} {2,2} {3,3} {4,4}Verify that after rollback, row count is back to 0 in updateTriggerInsertIntoThisTable 1 - {0}Verify that after rollback, table0WithTriggers is back to its original contents C1,C2 -- -- {1,1} {2,2} {3,3} {4,4}Positive Test17 - After deleteRow, resultset is positioned before the next rowgetXXX right after deleteRow will fail because resultset is not positioned on a row, instead it is right before the next rowSQL State : nullGot expected exception Invalid operation to read at current cursor position.Positive Test18 - Test cancelRowUpdates method as the first updatable ResultSet api on a read-only resultsetSQL State : nullGot expected exception This method cannot be invoked while the cursor is on the insert row or if this ResultSet object has a concurrency of CONCUR_READ_ONLY.Positive Test19 - Test updateRow method as the first updatable ResultSet api on a read-only resultset Got expected exception : This method cannot be invoked while the cursor is on the insert row or if the concurrency of this ResultSet object is CONCUR_READ_ONLY.Positive Test20 - Test updateXXX methods as the first updatable ResultSet api on a read-only resultset Test updateShort on a readonly resultset Using column position as first parameter to updateShort Got expected exception : ResultSet is not updatable. Using column name as first parameter to updateShort Got expected exception : ResultSet is not updatable. Test updateInt on a readonly resultset Using column position as first parameter to updateInt Got expected exception : ResultSet is not updatable. Using column name as first parameter to updateInt Got expected exception : ResultSet is not updatable. Test updateLong on a readonly resultset Using column position as first parameter to updateLong Got expected exception : ResultSet is not updatable. Using column name as first parameter to updateLong Got expected exception : ResultSet is not updatable. Test updateBigDecimal on a readonly resultset Using column position as first parameter to updateBigDecimal Got expected exception : ResultSet is not updatable. Using column name as first parameter to updateBigDecimal Got expected exception : ResultSet is not updatable. Test updateFloat on a readonly resultset Using column position as first parameter to updateFloat Got expected exception : ResultSet is not updatable. Using column name as first parameter to updateFloat Got expected exception : ResultSet is not updatable. Test updateDouble on a readonly resultset Using column position as first parameter to updateDouble Got expected exception : ResultSet is not updatable. Using column name as first parameter to updateDouble Got expected exception : ResultSet is not updatable. Test updateString on a readonly resultset Using column position as first parameter to updateString Got expected exception : ResultSet is not updatable. Using column name as first parameter to updateString Got expected exception : ResultSet is not updatable. Test updateAsciiStream on a readonly resultset Using column position as first parameter to updateAsciiStream Got expected exception : ResultSet is not updatable. Using column name as first parameter to updateAsciiStream Got expected exception : ResultSet is not updatable. Test updateCharacterStream on a readonly resultset Using column position as first parameter to updateCharacterStream Got expected exception : ResultSet is not updatable. Using column name as first parameter to updateCharacterStream Got expected exception : ResultSet is not updatable. Test updateByte on a readonly resultset Using column position as first parameter to updateByte Got expected exception : ResultSet is not updatable. Using column name as first parameter to updateByte Got expected exception : ResultSet is not updatable. Test updateBytes on a readonly resultset Using column position as first parameter to updateBytes Got expected exception : ResultSet is not updatable. Using column name as first parameter to updateBytes Got expected exception : ResultSet is not updatable. Test updateBinaryStream on a readonly resultset Using column position as first parameter to updateBinaryStream Got expected exception : ResultSet is not updatable. Using column name as first parameter to updateBinaryStream Got expected exception : ResultSet is not updatable. Test updateClob on a readonly resultset Using column position as first parameter to updateClob Got expected exception : JDBC 3 method called - not yet supported Using column name as first parameter to updateClob Got expected exception : JDBC 3 method called - not yet supported Test updateDate on a readonly resultset Using column position as first parameter to updateDate Got expected exception : ResultSet is not updatable. Using column name as first parameter to updateDate Got expected exception : ResultSet is not updatable. Test updateTime on a readonly resultset Using column position as first parameter to updateTime Got expected exception : ResultSet is not updatable. Using column name as first parameter to updateTime Got expected exception : ResultSet is not updatable. Test updateTimestamp on a readonly resultset Using column position as first parameter to updateTimestamp Got expected exception : ResultSet is not updatable. Using column name as first parameter to updateTimestamp Got expected exception : ResultSet is not updatable. Test updateBlob on a readonly resultset Using column position as first parameter to updateBlob Got expected exception : JDBC 3 method called - not yet supported Using column name as first parameter to updateBlob Got expected exception : JDBC 3 method called - not yet supported Test updateBoolean on a readonly resultset Using column position as first parameter to updateBoolean Got expected exception : ResultSet is not updatable. Using column name as first parameter to updateBoolean Got expected exception : ResultSet is not updatable. Test updateNull on a readonly resultset Using column position as first parameter to updateNull Got expected exception : ResultSet is not updatable. Using column name as first parameter to updateNull Got expected exception : ResultSet is not updatable. Test updateArray on a readonly resultset Using column position as first parameter to updateArray Got expected exception : JDBC 3 method called - not yet supported Using column name as first parameter to updateArray Got expected exception : JDBC 3 method called - not yet supported Test updateRef on a readonly resultset Using column position as first parameter to updateRef Got expected exception : JDBC 3 method called - not yet supported Using column name as first parameter to updateRef Got expected exception : JDBC 3 method called - not yet supportedPositive Test21 - Test all updateXXX(excluding updateObject) methods on all the supported sql datatypesNext datatype to test is SMALLINT Testing updateShort on SQL type SMALLINT Using column position as first parameter to updateShort Using column name as first parameter to updateShort Testing updateInt on SQL type SMALLINT Using column position as first parameter to updateInt Using column name as first parameter to updateInt Testing updateLong on SQL type SMALLINT Using column position as first parameter to updateLong Using column name as first parameter to updateLong Testing updateBigDecimal on SQL type SMALLINT Using column position as first parameter to updateBigDecimal Using column name as first parameter to updateBigDecimal Testing updateFloat on SQL type SMALLINT Using column position as first parameter to updateFloat Using column name as first parameter to updateFloat Testing updateDouble on SQL type SMALLINT Using column position as first parameter to updateDouble Using column name as first parameter to updateDouble Testing updateString on SQL type SMALLINT Using column position as first parameter to updateString Got expected exception : Invalid data conversion: Parameter instance 1992 is invalid for requested conversion. Using column name as first parameter to updateString Got expected exception : Invalid data conversion: Parameter instance 1992 is invalid for requested conversion. Testing updateAsciiStream on SQL type SMALLINT Using column position as first parameter to updateAsciiStream Got expected exception : Illegal Conversion Using column name as first parameter to updateAsciiStream Got expected exception : Illegal Conversion Testing updateCharacterStream on SQL type SMALLINT Using column position as first parameter to updateCharacterStream Got expected exception : Illegal Conversion Using column name as first parameter to updateCharacterStream Got expected exception : Illegal Conversion Testing updateByte on SQL type SMALLINT Using column position as first parameter to updateByte Using column name as first parameter to updateByte Testing updateBytes on SQL type SMALLINT Using column position as first parameter to updateBytes Got expected exception : Illegal Conversion Using column name as first parameter to updateBytes Got expected exception : Illegal Conversion Testing updateBinaryStream on SQL type SMALLINT Using column position as first parameter to updateBinaryStream Got expected exception : Illegal Conversion Using column name as first parameter to updateBinaryStream Got expected exception : Illegal Conversion Testing updateClob on SQL type SMALLINT Using column position as first parameter to updateClob Got expected exception : JDBC 3 method called - not yet supported Using column name as first parameter to updateClob Got expected exception : JDBC 3 method called - not yet supported Testing updateDate on SQL type SMALLINT Using column position as first parameter to updateDate Got expected exception : Illegal Conversion Using column name as first parameter to updateDate Got expected exception : Illegal Conversion Testing updateTime on SQL type SMALLINT Using column position as first parameter to updateTime Got expected exception : Illegal Conversion Using column name as first parameter to updateTime Got expected exception : Illegal Conversion Testing updateTimestamp on SQL type SMALLINT Using column position as first parameter to updateTimestamp Got expected exception : Illegal Conversion Using column name as first parameter to updateTimestamp Got expected exception : Illegal Conversion Testing updateBlob on SQL type SMALLINT Using column position as first parameter to updateBlob Got expected exception : JDBC 3 method called - not yet supported Using column name as first parameter to updateBlob Got expected exception : JDBC 3 method called - not yet supported Testing updateBoolean on SQL type SMALLINT Using column position as first parameter to updateBoolean Using column name as first parameter to updateBoolean Testing updateNull on SQL type SMALLINT Using column position as first parameter to updateNull Using column name as first parameter to updateNull Testing updateArray on SQL type SMALLINT Using column position as first parameter to updateArray Got expected exception : JDBC 3 method called - not yet supported Using column name as first parameter to updateArray Got expected exception : JDBC 3 method called - not yet supported Testing updateRef on SQL type SMALLINT Using column position as first parameter to updateRef Got expected exception : JDBC 3 method called - not yet supported Using column name as first parameter to updateRef Got expected exception : JDBC 3 method called - not yet supportedNext datatype to test is INTEGER Testing updateShort on SQL type INTEGER Using column position as first parameter to updateShort Using column name as first parameter to updateShort Testing updateInt on SQL type INTEGER Using column position as first parameter to updateInt Using column name as first parameter to updateInt Testing updateLong on SQL type INTEGER Using column position as first parameter to updateLong Using column name as first parameter to updateLong Testing updateBigDecimal on SQL type INTEGER Using column position as first parameter to updateBigDecimal Using column name as first parameter to updateBigDecimal Testing updateFloat on SQL type INTEGER Using column position as first parameter to updateFloat
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -