updatableresultset.out

derby database source code.good for you.

	{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 row
getXXX right after deleteRow will fail because resultset is not positioned on a row, instead it is right before the next row
SQL State : null
Got 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 resultset
SQL State : null
Got 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
  Using column name as first parameter to updateClob
  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
  Using column name as first parameter to updateBlob
  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
  Using column name as first parameter to updateArray
  Test updateRef on a readonly resultset
  Using column position as first parameter to updateRef
  Using column name as first parameter to updateRef
Positive Test21 - Test all updateXXX(excluding updateObject) methods on all the supported sql datatypes
Next 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
    Using column name as first parameter to updateClob
  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
    Using column name as first parameter to updateBlob
  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
    Using column name as first parameter to updateArray
  Testing updateRef on SQL type SMALLINT
    Using column position as first parameter to updateRef
    Using column name as first parameter to updateRef
Next 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
    Using column name as first parameter to updateFloat
  Testing updateDouble on SQL type INTEGER
    Using column position as first parameter to updateDouble
    Using column name as first parameter to updateDouble
  Testing updateString on SQL type INTEGER
    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 INTEGER
    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 INTEGER
    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 INTEGER
    Using column position as first parameter to updateByte
    Using column name as first parameter to updateByte
  Testing updateBytes on SQL type INTEGER
    Using column position as first parameter to updateBytes
      Got expected exception : Illegal Conversion