db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From be...@apache.org
Subject svn commit: r332491 [2/4] - in /db/derby/code/trunk/java: engine/org/apache/derby/iapi/sql/conn/ engine/org/apache/derby/iapi/sql/dictionary/ engine/org/apache/derby/impl/jdbc/ engine/org/apache/derby/impl/sql/ engine/org/apache/derby/impl/sql/compile/...
Date Fri, 11 Nov 2005 08:42:33 GMT
Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/updatableResultSet.out
URL: http://svn.apache.org/viewcvs/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/updatableResultSet.out?rev=332491&r1=332490&r2=332491&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/updatableResultSet.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/updatableResultSet.out Fri Nov 11 00:41:31 2005
@@ -40,14 +40,12 @@
 Now attempting to send a updateRow on a read only resultset with FOR UPDATE clause in the SELECT sql.
 SQL State : null
 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.
-Negative Test5 - request updatable resultset for sql with no FOR UPDATE clause
+Negative Test5 - request resultset with no FOR UPDATE clause and CONCUR_READ_ONLY
 Make sure that we got CONCUR_READ_ONLY? true
-Jira issue Derby-159 : Warnings raised by Derby are not getting passed to the Client in Network Server Mode
-Will see the warnings in embedded mode only
-Now attempting to send a delete on a sql with no FOR UPDATE clause.
+Now attempting to send a delete on a sql with no FOR UPDATE clause and CONCUR_READ_ONLY.
 SQL State : null
 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.
-Now attempting to send a updateRow on a sql with no FOR UPDATE clause.
+Now attempting to send a updateRow on a sql with no FOR UPDATE clause and CONCUR_READ_ONLY.
 SQL State : null
 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.
 Negative Test6 - request updatable resultset for sql with FOR READ ONLY clause
@@ -146,6 +144,31 @@
 Got expected exception Invalid operation to update at current cursor position
 Position the ResultSet with next()
 Should be able to updateRow() on the current row now
+Positive Test1c - use updatable resultset to do postitioned delete
+requested TYPE_FORWARD_ONLY, CONCUR_UPDATABLE
+got TYPE_FORWARD_ONLY? true
+got CONCUR_UPDATABLE? true
+column 1 on this row before positioned delete 234
+column 2 on this row before positioned delete aa                  
+column 1 on this deleted row is 234
+column 2 on this deleted row is aa                  
+doing positioned delete again w/o first positioning the ResultSet on the next row will fail
+SQL State : XCL08
+Got expected exception Cursor '<xxx-cursor-name-xxx>' is not on a row.
+Position the ResultSet with next()
+Should be able to do positioned delete on the current row now
+Positive Test1d - updatable resultset to do positioned update
+column 1 on this row before positioned update is 1
+now dow positioned update on the row
+column 1 on the updated  row is 1
+column 1 on the updated  row is aa                  
+Refreshing the row
+SQL State : null
+Got expected exception This method should only be called on ResultSet objects that are scrollable(type TYPE_SCROLL_SENSITIVE or TYPE_SCROLL_INSENSITIVE)
+doing positioned update again w/o positioning the RS will succeed
+because the cursor is still positioned
+Position the ResultSet with next()
+Should still be able to do positioned update
 Positive Test2 - even if no columns from table specified in the column list, we should be able to get updatable resultset
 Will work in embedded mode because target table is not derived from the columns in the select list
 Will not work in network server mode because it derives the target table from the columns in the select list
@@ -565,7 +588,9 @@
   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.
@@ -583,7 +608,9 @@
   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.
@@ -596,10 +623,14 @@
   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 supported
 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
@@ -650,7 +681,9 @@
       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
@@ -668,7 +701,9 @@
       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
@@ -677,10 +712,14 @@
     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 supported
 Next datatype to test is INTEGER
   Testing updateShort on SQL type INTEGER
     Using column position as first parameter to updateShort
@@ -730,7 +769,9 @@
       Got expected exception : Illegal Conversion
   Testing updateClob on SQL type INTEGER
     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 INTEGER
     Using column position as first parameter to updateDate
       Got expected exception : Illegal Conversion
@@ -748,7 +789,9 @@
       Got expected exception : Illegal Conversion
   Testing updateBlob on SQL type INTEGER
     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 INTEGER
     Using column position as first parameter to updateBoolean
     Using column name as first parameter to updateBoolean
@@ -757,10 +800,14 @@
     Using column name as first parameter to updateNull
   Testing updateArray on SQL type INTEGER
     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 INTEGER
     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 supported
 Next datatype to test is BIGINT
   Testing updateShort on SQL type BIGINT
     Using column position as first parameter to updateShort
@@ -810,7 +857,9 @@
       Got expected exception : Illegal Conversion
   Testing updateClob on SQL type BIGINT
     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 BIGINT
     Using column position as first parameter to updateDate
       Got expected exception : Illegal Conversion
@@ -828,7 +877,9 @@
       Got expected exception : Illegal Conversion
   Testing updateBlob on SQL type BIGINT
     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 BIGINT
     Using column position as first parameter to updateBoolean
     Using column name as first parameter to updateBoolean
@@ -837,10 +888,14 @@
     Using column name as first parameter to updateNull
   Testing updateArray on SQL type BIGINT
     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 BIGINT
     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 supported
 Next datatype to test is DECIMAL(10,5)
   Testing updateShort on SQL type DECIMAL(10,5)
     Using column position as first parameter to updateShort
@@ -890,7 +945,9 @@
       Got expected exception : Illegal Conversion
   Testing updateClob on SQL type DECIMAL(10,5)
     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 DECIMAL(10,5)
     Using column position as first parameter to updateDate
       Got expected exception : Illegal Conversion
@@ -908,7 +965,9 @@
       Got expected exception : Illegal Conversion
   Testing updateBlob on SQL type DECIMAL(10,5)
     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 DECIMAL(10,5)
     Using column position as first parameter to updateBoolean
     Using column name as first parameter to updateBoolean
@@ -917,10 +976,14 @@
     Using column name as first parameter to updateNull
   Testing updateArray on SQL type DECIMAL(10,5)
     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 DECIMAL(10,5)
     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 supported
 Next datatype to test is REAL
   Testing updateShort on SQL type REAL
     Using column position as first parameter to updateShort
@@ -968,7 +1031,9 @@
       Got expected exception : Illegal Conversion
   Testing updateClob on SQL type REAL
     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 REAL
     Using column position as first parameter to updateDate
       Got expected exception : Illegal Conversion
@@ -986,7 +1051,9 @@
       Got expected exception : Illegal Conversion
   Testing updateBlob on SQL type REAL
     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 REAL
     Using column position as first parameter to updateBoolean
     Using column name as first parameter to updateBoolean
@@ -995,10 +1062,14 @@
     Using column name as first parameter to updateNull
   Testing updateArray on SQL type REAL
     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 REAL
     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 supported
 Next datatype to test is DOUBLE
   Testing updateShort on SQL type DOUBLE
     Using column position as first parameter to updateShort
@@ -1046,7 +1117,9 @@
       Got expected exception : Illegal Conversion
   Testing updateClob on SQL type DOUBLE
     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 DOUBLE
     Using column position as first parameter to updateDate
       Got expected exception : Illegal Conversion
@@ -1064,7 +1137,9 @@
       Got expected exception : Illegal Conversion
   Testing updateBlob on SQL type DOUBLE
     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 DOUBLE
     Using column position as first parameter to updateBoolean
     Using column name as first parameter to updateBoolean
@@ -1073,10 +1148,14 @@
     Using column name as first parameter to updateNull
   Testing updateArray on SQL type DOUBLE
     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 DOUBLE
     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 supported
 Next datatype to test is CHAR(60)
   Testing updateShort on SQL type CHAR(60)
     Using column position as first parameter to updateShort
@@ -1120,7 +1199,9 @@
       Got expected exception : Illegal Conversion
   Testing updateClob on SQL type CHAR(60)
     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 CHAR(60)
     Using column position as first parameter to updateDate
     Using column name as first parameter to updateDate
@@ -1132,7 +1213,9 @@
     Using column name as first parameter to updateTimestamp
   Testing updateBlob on SQL type CHAR(60)
     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 CHAR(60)
     Using column position as first parameter to updateBoolean
     Using column name as first parameter to updateBoolean
@@ -1141,10 +1224,14 @@
     Using column name as first parameter to updateNull
   Testing updateArray on SQL type CHAR(60)
     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 CHAR(60)
     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 supported
 Next datatype to test is VARCHAR(60)
   Testing updateShort on SQL type VARCHAR(60)
     Using column position as first parameter to updateShort
@@ -1188,7 +1275,9 @@
       Got expected exception : Illegal Conversion
   Testing updateClob on SQL type VARCHAR(60)
     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 VARCHAR(60)
     Using column position as first parameter to updateDate
     Using column name as first parameter to updateDate
@@ -1200,7 +1289,9 @@
     Using column name as first parameter to updateTimestamp
   Testing updateBlob on SQL type VARCHAR(60)
     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 VARCHAR(60)
     Using column position as first parameter to updateBoolean
     Using column name as first parameter to updateBoolean
@@ -1209,10 +1300,14 @@
     Using column name as first parameter to updateNull
   Testing updateArray on SQL type VARCHAR(60)
     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 VARCHAR(60)
     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 supported
 Next datatype to test is LONG VARCHAR
   Testing updateShort on SQL type LONG VARCHAR
     Using column position as first parameter to updateShort
@@ -1256,7 +1351,9 @@
       Got expected exception : Illegal Conversion
   Testing updateClob on SQL type LONG VARCHAR
     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 LONG VARCHAR
     Using column position as first parameter to updateDate
     Using column name as first parameter to updateDate
@@ -1268,7 +1365,9 @@
     Using column name as first parameter to updateTimestamp
   Testing updateBlob on SQL type LONG VARCHAR
     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 LONG VARCHAR
     Using column position as first parameter to updateBoolean
     Using column name as first parameter to updateBoolean
@@ -1277,10 +1376,14 @@
     Using column name as first parameter to updateNull
   Testing updateArray on SQL type LONG VARCHAR
     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 LONG VARCHAR
     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 supported
 Next datatype to test is CHAR(2) FOR BIT DATA
   Testing updateShort on SQL type CHAR(2) FOR BIT DATA
     Using column position as first parameter to updateShort
@@ -1340,7 +1443,9 @@
     Using column name as first parameter to updateBinaryStream
   Testing updateClob on SQL type CHAR(2) FOR BIT DATA
     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 CHAR(2) FOR BIT DATA
     Using column position as first parameter to updateDate
       Got expected exception : Illegal Conversion
@@ -1358,7 +1463,9 @@
       Got expected exception : Illegal Conversion
   Testing updateBlob on SQL type CHAR(2) FOR BIT DATA
     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 CHAR(2) FOR BIT DATA
     Using column position as first parameter to updateBoolean
       Got expected exception : Illegal Conversion
@@ -1369,10 +1476,14 @@
     Using column name as first parameter to updateNull
   Testing updateArray on SQL type CHAR(2) FOR BIT DATA
     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 CHAR(2) FOR BIT DATA
     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 supported
 Next datatype to test is VARCHAR(2) FOR BIT DATA
   Testing updateShort on SQL type VARCHAR(2) FOR BIT DATA
     Using column position as first parameter to updateShort
@@ -1432,7 +1543,9 @@
     Using column name as first parameter to updateBinaryStream
   Testing updateClob on SQL type VARCHAR(2) FOR BIT DATA
     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 VARCHAR(2) FOR BIT DATA
     Using column position as first parameter to updateDate
       Got expected exception : Illegal Conversion
@@ -1450,7 +1563,9 @@
       Got expected exception : Illegal Conversion
   Testing updateBlob on SQL type VARCHAR(2) FOR BIT DATA
     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 VARCHAR(2) FOR BIT DATA
     Using column position as first parameter to updateBoolean
       Got expected exception : Illegal Conversion
@@ -1461,10 +1576,14 @@
     Using column name as first parameter to updateNull
   Testing updateArray on SQL type VARCHAR(2) FOR BIT DATA
     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 VARCHAR(2) FOR BIT DATA
     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 supported
 Next datatype to test is LONG VARCHAR FOR BIT DATA
   Testing updateShort on SQL type LONG VARCHAR FOR BIT DATA
     Using column position as first parameter to updateShort
@@ -1524,7 +1643,9 @@
     Using column name as first parameter to updateBinaryStream
   Testing updateClob on SQL type LONG VARCHAR FOR BIT DATA
     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 LONG VARCHAR FOR BIT DATA
     Using column position as first parameter to updateDate
       Got expected exception : Illegal Conversion
@@ -1542,7 +1663,9 @@
       Got expected exception : Illegal Conversion
   Testing updateBlob on SQL type LONG VARCHAR FOR BIT DATA
     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 LONG VARCHAR FOR BIT DATA
     Using column position as first parameter to updateBoolean
       Got expected exception : Illegal Conversion
@@ -1553,10 +1676,14 @@
     Using column name as first parameter to updateNull
   Testing updateArray on SQL type LONG VARCHAR FOR BIT DATA
     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 LONG VARCHAR FOR BIT DATA
     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 supported
 Next datatype to test is CLOB(1k)
   Testing updateShort on SQL type CLOB(1k)
     Using column position as first parameter to updateShort
@@ -1614,7 +1741,9 @@
       Got expected exception : Illegal Conversion
   Testing updateClob on SQL type CLOB(1k)
     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 CLOB(1k)
     Using column position as first parameter to updateDate
       Got expected exception : Illegal Conversion
@@ -1632,7 +1761,9 @@
       Got expected exception : Illegal Conversion
   Testing updateBlob on SQL type CLOB(1k)
     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 CLOB(1k)
     Using column position as first parameter to updateBoolean
       Got expected exception : Illegal Conversion
@@ -1643,10 +1774,14 @@
     Using column name as first parameter to updateNull
   Testing updateArray on SQL type CLOB(1k)
     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 CLOB(1k)
     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 supported
 Next datatype to test is DATE
   Testing updateShort on SQL type DATE
     Using column position as first parameter to updateShort
@@ -1710,7 +1845,9 @@
       Got expected exception : Illegal Conversion
   Testing updateClob on SQL type DATE
     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 DATE
     Using column position as first parameter to updateDate
     Using column name as first parameter to updateDate
@@ -1724,7 +1861,9 @@
     Using column name as first parameter to updateTimestamp
   Testing updateBlob on SQL type DATE
     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 DATE
     Using column position as first parameter to updateBoolean
       Got expected exception : Illegal Conversion
@@ -1735,10 +1874,14 @@
     Using column name as first parameter to updateNull
   Testing updateArray on SQL type DATE
     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 DATE
     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 supported
 Next datatype to test is TIME
   Testing updateShort on SQL type TIME
     Using column position as first parameter to updateShort
@@ -1802,7 +1945,9 @@
       Got expected exception : Illegal Conversion
   Testing updateClob on SQL type TIME
     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 TIME
     Using column position as first parameter to updateDate
       Got expected exception : Illegal Conversion
@@ -1816,7 +1961,9 @@
     Using column name as first parameter to updateTimestamp
   Testing updateBlob on SQL type TIME
     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 TIME
     Using column position as first parameter to updateBoolean
       Got expected exception : Illegal Conversion
@@ -1827,10 +1974,14 @@
     Using column name as first parameter to updateNull
   Testing updateArray on SQL type TIME
     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 TIME
     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 supported
 Next datatype to test is TIMESTAMP
   Testing updateShort on SQL type TIMESTAMP
     Using column position as first parameter to updateShort
@@ -1894,7 +2045,9 @@
       Got expected exception : Illegal Conversion
   Testing updateClob on SQL type TIMESTAMP
     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 TIMESTAMP
     Using column position as first parameter to updateDate
     Using column name as first parameter to updateDate
@@ -1908,7 +2061,9 @@
     Using column name as first parameter to updateTimestamp
   Testing updateBlob on SQL type TIMESTAMP
     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 TIMESTAMP
     Using column position as first parameter to updateBoolean
       Got expected exception : Illegal Conversion
@@ -1919,10 +2074,14 @@
     Using column name as first parameter to updateNull
   Testing updateArray on SQL type TIMESTAMP
     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 TIMESTAMP
     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 supported
 Next datatype to test is BLOB(1k)
   Testing updateShort on SQL type BLOB(1k)
     Using column position as first parameter to updateShort
@@ -1982,7 +2141,9 @@
     Using column name as first parameter to updateBinaryStream
   Testing updateClob on SQL type BLOB(1k)
     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 BLOB(1k)
     Using column position as first parameter to updateDate
       Got expected exception : Illegal Conversion
@@ -2000,7 +2161,9 @@
       Got expected exception : Illegal Conversion
   Testing updateBlob on SQL type BLOB(1k)
     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 BLOB(1k)
     Using column position as first parameter to updateBoolean
       Got expected exception : Illegal Conversion
@@ -2011,10 +2174,14 @@
     Using column name as first parameter to updateNull
   Testing updateArray on SQL type BLOB(1k)
     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 BLOB(1k)
     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 supported
 Positive Test22 - Test updateObject method
 Next datatype to test is SMALLINT
   updateObject with column position & Short object as parameters
@@ -2037,6 +2204,10 @@
     Got expected exception : Illegal Conversion
   updateObject with column name & bytes[] array as parameters
     Got expected exception : Illegal Conversion
+  updateObject with column position & Clob object as parameters
+    Got expected exception : Illegal Conversion
+  updateObject with column name & Clob object as parameters
+    Got expected exception : Illegal Conversion
   updateObject with column position & Date object as parameters
     Got expected exception : Illegal Conversion
   updateObject with column name & Date object as parameters
@@ -2049,6 +2220,10 @@
     Got expected exception : Illegal Conversion
   updateObject with column name & TimeStamp object as parameters
     Got expected exception : Illegal Conversion
+  updateObject with column position & Blob object as parameters
+    Got expected exception : Illegal Conversion
+  updateObject with column name & Blob object as parameters
+    Got expected exception : Illegal Conversion
   updateObject with column position & Boolean object as parameters
   updateObject with column name & Boolean object as parameters
   updateObject with column position & null as parameters
@@ -2076,6 +2251,10 @@
     Got expected exception : Illegal Conversion
   updateObject with column name & bytes[] array as parameters
     Got expected exception : Illegal Conversion
+  updateObject with column position & Clob object as parameters
+    Got expected exception : Illegal Conversion
+  updateObject with column name & Clob object as parameters
+    Got expected exception : Illegal Conversion
   updateObject with column position & Date object as parameters
     Got expected exception : Illegal Conversion
   updateObject with column name & Date object as parameters
@@ -2088,6 +2267,10 @@
     Got expected exception : Illegal Conversion
   updateObject with column name & TimeStamp object as parameters
     Got expected exception : Illegal Conversion
+  updateObject with column position & Blob object as parameters
+    Got expected exception : Illegal Conversion
+  updateObject with column name & Blob object as parameters
+    Got expected exception : Illegal Conversion
   updateObject with column position & Boolean object as parameters
   updateObject with column name & Boolean object as parameters
   updateObject with column position & null as parameters
@@ -2115,6 +2298,10 @@
     Got expected exception : Illegal Conversion
   updateObject with column name & bytes[] array as parameters
     Got expected exception : Illegal Conversion
+  updateObject with column position & Clob object as parameters
+    Got expected exception : Illegal Conversion
+  updateObject with column name & Clob object as parameters
+    Got expected exception : Illegal Conversion
   updateObject with column position & Date object as parameters
     Got expected exception : Illegal Conversion
   updateObject with column name & Date object as parameters
@@ -2127,6 +2314,10 @@
     Got expected exception : Illegal Conversion
   updateObject with column name & TimeStamp object as parameters
     Got expected exception : Illegal Conversion
+  updateObject with column position & Blob object as parameters
+    Got expected exception : Illegal Conversion
+  updateObject with column name & Blob object as parameters
+    Got expected exception : Illegal Conversion
   updateObject with column position & Boolean object as parameters
   updateObject with column name & Boolean object as parameters
   updateObject with column position & null as parameters
@@ -2154,6 +2345,10 @@
     Got expected exception : Illegal Conversion
   updateObject with column name & bytes[] array as parameters
     Got expected exception : Illegal Conversion
+  updateObject with column position & Clob object as parameters
+    Got expected exception : Illegal Conversion
+  updateObject with column name & Clob object as parameters
+    Got expected exception : Illegal Conversion
   updateObject with column position & Date object as parameters
     Got expected exception : Illegal Conversion
   updateObject with column name & Date object as parameters
@@ -2166,6 +2361,10 @@
     Got expected exception : Illegal Conversion
   updateObject with column name & TimeStamp object as parameters
     Got expected exception : Illegal Conversion
+  updateObject with column position & Blob object as parameters
+    Got expected exception : Illegal Conversion
+  updateObject with column name & Blob object as parameters
+    Got expected exception : Illegal Conversion
   updateObject with column position & Boolean object as parameters
   updateObject with column name & Boolean object as parameters
   updateObject with column position & null as parameters
@@ -2191,6 +2390,10 @@
     Got expected exception : Illegal Conversion
   updateObject with column name & bytes[] array as parameters
     Got expected exception : Illegal Conversion
+  updateObject with column position & Clob object as parameters
+    Got expected exception : Illegal Conversion
+  updateObject with column name & Clob object as parameters
+    Got expected exception : Illegal Conversion
   updateObject with column position & Date object as parameters
     Got expected exception : Illegal Conversion
   updateObject with column name & Date object as parameters
@@ -2203,6 +2406,10 @@
     Got expected exception : Illegal Conversion
   updateObject with column name & TimeStamp object as parameters
     Got expected exception : Illegal Conversion
+  updateObject with column position & Blob object as parameters
+    Got expected exception : Illegal Conversion
+  updateObject with column name & Blob object as parameters
+    Got expected exception : Illegal Conversion
   updateObject with column position & Boolean object as parameters
   updateObject with column name & Boolean object as parameters
   updateObject with column position & null as parameters
@@ -2228,6 +2435,10 @@
     Got expected exception : Illegal Conversion
   updateObject with column name & bytes[] array as parameters
     Got expected exception : Illegal Conversion
+  updateObject with column position & Clob object as parameters
+    Got expected exception : Illegal Conversion
+  updateObject with column name & Clob object as parameters
+    Got expected exception : Illegal Conversion
   updateObject with column position & Date object as parameters
     Got expected exception : Illegal Conversion
   updateObject with column name & Date object as parameters
@@ -2240,6 +2451,10 @@
     Got expected exception : Illegal Conversion
   updateObject with column name & TimeStamp object as parameters
     Got expected exception : Illegal Conversion
+  updateObject with column position & Blob object as parameters
+    Got expected exception : Illegal Conversion
+  updateObject with column name & Blob object as parameters
+    Got expected exception : Illegal Conversion
   updateObject with column position & Boolean object as parameters
   updateObject with column name & Boolean object as parameters
   updateObject with column position & null as parameters
@@ -2265,12 +2480,18 @@
     Got expected exception : Illegal Conversion
   updateObject with column name & bytes[] array as parameters
     Got expected exception : Illegal Conversion
+  updateObject with column position & Clob object as parameters
+  updateObject with column name & Clob object as parameters
   updateObject with column position & Date object as parameters
   updateObject with column name & Date object as parameters
   updateObject with column position & Time object as parameters
   updateObject with column name & Time object as parameters
   updateObject with column position & TimeStamp object as parameters
   updateObject with column name & TimeStamp object as parameters
+  updateObject with column position & Blob object as parameters
+    Got expected exception : Illegal Conversion
+  updateObject with column name & Blob object as parameters
+    Got expected exception : Illegal Conversion
   updateObject with column position & Boolean object as parameters
   updateObject with column name & Boolean object as parameters
   updateObject with column position & null as parameters
@@ -2296,12 +2517,18 @@
     Got expected exception : Illegal Conversion
   updateObject with column name & bytes[] array as parameters
     Got expected exception : Illegal Conversion
+  updateObject with column position & Clob object as parameters
+  updateObject with column name & Clob object as parameters
   updateObject with column position & Date object as parameters
   updateObject with column name & Date object as parameters
   updateObject with column position & Time object as parameters
   updateObject with column name & Time object as parameters
   updateObject with column position & TimeStamp object as parameters
   updateObject with column name & TimeStamp object as parameters
+  updateObject with column position & Blob object as parameters
+    Got expected exception : Illegal Conversion
+  updateObject with column name & Blob object as parameters
+    Got expected exception : Illegal Conversion
   updateObject with column position & Boolean object as parameters
   updateObject with column name & Boolean object as parameters
   updateObject with column position & null as parameters
@@ -2327,12 +2554,18 @@
     Got expected exception : Illegal Conversion
   updateObject with column name & bytes[] array as parameters
     Got expected exception : Illegal Conversion
+  updateObject with column position & Clob object as parameters
+  updateObject with column name & Clob object as parameters
   updateObject with column position & Date object as parameters
   updateObject with column name & Date object as parameters
   updateObject with column position & Time object as parameters
   updateObject with column name & Time object as parameters
   updateObject with column position & TimeStamp object as parameters
   updateObject with column name & TimeStamp object as parameters
+  updateObject with column position & Blob object as parameters
+    Got expected exception : Illegal Conversion
+  updateObject with column name & Blob object as parameters
+    Got expected exception : Illegal Conversion
   updateObject with column position & Boolean object as parameters
   updateObject with column name & Boolean object as parameters
   updateObject with column position & null as parameters
@@ -2370,6 +2603,10 @@
     Got expected exception : Illegal Conversion
   updateObject with column position & bytes[] array as parameters
   updateObject with column name & bytes[] array as parameters
+  updateObject with column position & Clob object as parameters
+    Got expected exception : Illegal Conversion
+  updateObject with column name & Clob object as parameters
+    Got expected exception : Illegal Conversion
   updateObject with column position & Date object as parameters
     Got expected exception : Illegal Conversion
   updateObject with column name & Date object as parameters
@@ -2382,6 +2619,10 @@
     Got expected exception : Illegal Conversion
   updateObject with column name & TimeStamp object as parameters
     Got expected exception : Illegal Conversion
+  updateObject with column position & Blob object as parameters
+    Got expected exception : A truncation error was encountered trying to shrink CHAR () FOR BIT DATA 'XX-RESOLVE-XX' to length 2.
+  updateObject with column name & Blob object as parameters
+    Got expected exception : A truncation error was encountered trying to shrink CHAR () FOR BIT DATA 'XX-RESOLVE-XX' to length 2.
   updateObject with column position & Boolean object as parameters
     Got expected exception : Illegal Conversion
   updateObject with column name & Boolean object as parameters
@@ -2421,6 +2662,10 @@
     Got expected exception : Illegal Conversion
   updateObject with column position & bytes[] array as parameters
   updateObject with column name & bytes[] array as parameters
+  updateObject with column position & Clob object as parameters
+    Got expected exception : Illegal Conversion
+  updateObject with column name & Clob object as parameters
+    Got expected exception : Illegal Conversion
   updateObject with column position & Date object as parameters
     Got expected exception : Illegal Conversion
   updateObject with column name & Date object as parameters
@@ -2433,6 +2678,10 @@
     Got expected exception : Illegal Conversion
   updateObject with column name & TimeStamp object as parameters
     Got expected exception : Illegal Conversion
+  updateObject with column position & Blob object as parameters
+    Got expected exception : A truncation error was encountered trying to shrink VARCHAR () FOR BIT DATA 'XX-RESOLVE-XX' to length 2.
+  updateObject with column name & Blob object as parameters
+    Got expected exception : A truncation error was encountered trying to shrink VARCHAR () FOR BIT DATA 'XX-RESOLVE-XX' to length 2.
   updateObject with column position & Boolean object as parameters
     Got expected exception : Illegal Conversion
   updateObject with column name & Boolean object as parameters
@@ -2472,6 +2721,10 @@
     Got expected exception : Illegal Conversion
   updateObject with column position & bytes[] array as parameters
   updateObject with column name & bytes[] array as parameters
+  updateObject with column position & Clob object as parameters
+    Got expected exception : Illegal Conversion
+  updateObject with column name & Clob object as parameters
+    Got expected exception : Illegal Conversion
   updateObject with column position & Date object as parameters
     Got expected exception : Illegal Conversion
   updateObject with column name & Date object as parameters
@@ -2484,6 +2737,8 @@
     Got expected exception : Illegal Conversion
   updateObject with column name & TimeStamp object as parameters
     Got expected exception : Illegal Conversion
+  updateObject with column position & Blob object as parameters
+  updateObject with column name & Blob object as parameters
   updateObject with column position & Boolean object as parameters
     Got expected exception : Illegal Conversion
   updateObject with column name & Boolean object as parameters
@@ -2523,6 +2778,8 @@
     Got expected exception : Illegal Conversion
   updateObject with column name & bytes[] array as parameters
     Got expected exception : Illegal Conversion
+  updateObject with column position & Clob object as parameters
+  updateObject with column name & Clob object as parameters
   updateObject with column position & Date object as parameters
     Got expected exception : Illegal Conversion
   updateObject with column name & Date object as parameters
@@ -2535,6 +2792,10 @@
     Got expected exception : Illegal Conversion
   updateObject with column name & TimeStamp object as parameters
     Got expected exception : Illegal Conversion
+  updateObject with column position & Blob object as parameters
+    Got expected exception : Illegal Conversion
+  updateObject with column name & Blob object as parameters
+    Got expected exception : Illegal Conversion
   updateObject with column position & Boolean object as parameters
     Got expected exception : Illegal Conversion
   updateObject with column name & Boolean object as parameters
@@ -2576,6 +2837,10 @@
     Got expected exception : Illegal Conversion
   updateObject with column name & bytes[] array as parameters
     Got expected exception : Illegal Conversion
+  updateObject with column position & Clob object as parameters
+    Got expected exception : Illegal Conversion
+  updateObject with column name & Clob object as parameters
+    Got expected exception : Illegal Conversion
   updateObject with column position & Date object as parameters
   updateObject with column name & Date object as parameters
   updateObject with column position & Time object as parameters
@@ -2584,6 +2849,10 @@
     Got expected exception : Illegal Conversion
   updateObject with column position & TimeStamp object as parameters
   updateObject with column name & TimeStamp object as parameters
+  updateObject with column position & Blob object as parameters
+    Got expected exception : Illegal Conversion
+  updateObject with column name & Blob object as parameters
+    Got expected exception : Illegal Conversion
   updateObject with column position & Boolean object as parameters
     Got expected exception : Illegal Conversion
   updateObject with column name & Boolean object as parameters
@@ -2625,6 +2894,10 @@
     Got expected exception : Illegal Conversion
   updateObject with column name & bytes[] array as parameters
     Got expected exception : Illegal Conversion
+  updateObject with column position & Clob object as parameters
+    Got expected exception : Illegal Conversion
+  updateObject with column name & Clob object as parameters
+    Got expected exception : Illegal Conversion
   updateObject with column position & Date object as parameters
     Got expected exception : Illegal Conversion
   updateObject with column name & Date object as parameters
@@ -2633,6 +2906,10 @@
   updateObject with column name & Time object as parameters
   updateObject with column position & TimeStamp object as parameters
   updateObject with column name & TimeStamp object as parameters
+  updateObject with column position & Blob object as parameters
+    Got expected exception : Illegal Conversion
+  updateObject with column name & Blob object as parameters
+    Got expected exception : Illegal Conversion
   updateObject with column position & Boolean object as parameters
     Got expected exception : Illegal Conversion
   updateObject with column name & Boolean object as parameters
@@ -2674,6 +2951,10 @@
     Got expected exception : Illegal Conversion
   updateObject with column name & bytes[] array as parameters
     Got expected exception : Illegal Conversion
+  updateObject with column position & Clob object as parameters
+    Got expected exception : Illegal Conversion
+  updateObject with column name & Clob object as parameters
+    Got expected exception : Illegal Conversion
   updateObject with column position & Date object as parameters
   updateObject with column name & Date object as parameters
   updateObject with column position & Time object as parameters
@@ -2682,6 +2963,10 @@
     Got expected exception : Illegal Conversion
   updateObject with column position & TimeStamp object as parameters
   updateObject with column name & TimeStamp object as parameters
+  updateObject with column position & Blob object as parameters
+    Got expected exception : Illegal Conversion
+  updateObject with column name & Blob object as parameters
+    Got expected exception : Illegal Conversion
   updateObject with column position & Boolean object as parameters
     Got expected exception : Illegal Conversion
   updateObject with column name & Boolean object as parameters
@@ -2721,6 +3006,10 @@
     Got expected exception : Illegal Conversion
   updateObject with column position & bytes[] array as parameters
   updateObject with column name & bytes[] array as parameters
+  updateObject with column position & Clob object as parameters
+    Got expected exception : Illegal Conversion
+  updateObject with column name & Clob object as parameters
+    Got expected exception : Illegal Conversion
   updateObject with column position & Date object as parameters
     Got expected exception : Illegal Conversion
   updateObject with column name & Date object as parameters
@@ -2733,6 +3022,8 @@
     Got expected exception : Illegal Conversion
   updateObject with column name & TimeStamp object as parameters
     Got expected exception : Illegal Conversion
+  updateObject with column position & Blob object as parameters
+  updateObject with column name & Blob object as parameters
   updateObject with column position & Boolean object as parameters
     Got expected exception : Illegal Conversion
   updateObject with column name & Boolean object as parameters

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/jdk14/updatableResultSet.out
URL: http://svn.apache.org/viewcvs/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/jdk14/updatableResultSet.out?rev=332491&r1=332490&r2=332491&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/jdk14/updatableResultSet.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/jdk14/updatableResultSet.out Fri Nov 11 00:41:31 2005
@@ -40,15 +40,12 @@
 Now attempting to send a updateRow on a read only resultset with FOR UPDATE clause in the SELECT sql.
 SQL State : XJ083
 Got expected exception 'updateRow' not allowed because the ResultSet is not an updatable ResultSet. 
-Negative Test5 - request updatable resultset for sql with no FOR UPDATE clause
+Negative Test5 - request resultset with no FOR UPDATE clause and CONCUR_READ_ONLY
 Make sure that we got CONCUR_READ_ONLY? true
-Jira issue Derby-159 : Warnings raised by Derby are not getting passed to the Client in Network Server Mode
-Will see the warnings in embedded mode only
-WARNING 01J06: ResultSet not updatable. Query does not qualify to generate an updatable ResultSet.
-Now attempting to send a delete on a sql with no FOR UPDATE clause.
+Now attempting to send a delete on a sql with no FOR UPDATE clause and CONCUR_READ_ONLY.
 SQL State : XJ083
 Got expected exception 'deleteRow' not allowed because the ResultSet is not an updatable ResultSet. 
-Now attempting to send a updateRow on a sql with no FOR UPDATE clause.
+Now attempting to send a updateRow on a sql with no FOR UPDATE clause and CONCUR_READ_ONLY.
 SQL State : XJ083
 Got expected exception 'updateRow' not allowed because the ResultSet is not an updatable ResultSet. 
 Negative Test6 - request updatable resultset for sql with FOR READ ONLY clause
@@ -148,6 +145,31 @@
 Got expected exception Invalid cursor state - no current row.
 Position the ResultSet with next()
 Should be able to updateRow() on the current row now
+Positive Test1c - use updatable resultset to do postitioned delete
+requested TYPE_FORWARD_ONLY, CONCUR_UPDATABLE
+got TYPE_FORWARD_ONLY? true
+got CONCUR_UPDATABLE? true
+column 1 on this row before positioned delete 234
+column 2 on this row before positioned delete aa                  
+column 1 on this deleted row is 234
+column 2 on this deleted row is aa                  
+doing positioned delete again w/o first positioning the ResultSet on the next row will fail
+SQL State : XCL08
+Got expected exception Cursor 'SQLCUR4' is not on a row.
+Position the ResultSet with next()
+Should be able to do positioned delete on the current row now
+Positive Test1d - updatable resultset to do positioned update
+column 1 on this row before positioned update is 1
+now dow positioned update on the row
+column 1 on the updated  row is 1
+column 1 on the updated  row is aa                  
+Refreshing the row
+SQL State : 0A000
+Got expected exception Feature not implemented: no details.
+doing positioned update again w/o positioning the RS will succeed
+because the cursor is still positioned
+Position the ResultSet with next()
+Should still be able to do positioned update
 Positive Test2 - even if no columns from table specified in the column list, we should be able to get updatable resultset
 Will work in embedded mode because target table is not derived from the columns in the select list
 Will not work in network server mode because it derives the target table from the columns in the select list
@@ -284,7 +306,7 @@
 	{3,cc                  }
 Positive Test9c - try to updateXXX on a readonly column. Should get error
 SQL State : 42X31
-Got expected exception Column 'C2' is not in the FOR UPDATE list of cursor 'SQLCUR15'.
+Got expected exception Column 'C2' is not in the FOR UPDATE list of cursor 'SQLCUR17'.
 attempt to get an updatable resultset using correlation name for an readonly column. It should work
 The sql is SELECT c1, c2 as col2 FROM t1 abcde FOR UPDATE of c1
 Table t1 after updateRow has following rows
@@ -295,7 +317,7 @@
 	{3,cc                  }
 Positive Test9d - try to updateXXX on a readonly column with correlation name. Should get error
 SQL State : 42X31
-Got expected exception Column 'COL2' is not in the FOR UPDATE list of cursor 'SQLCUR17'.
+Got expected exception Column 'COL2' is not in the FOR UPDATE list of cursor 'SQLCUR19'.
 Table t1 has following rows
 	 C1,C2
 	 -- --
@@ -306,7 +328,7 @@
 delete using first resultset
 attempt to send deleteRow on the same row through a different resultset should throw an exception
 SQL State : XCL08
-Got expected exception Cursor 'SQLCUR19' is not on a row.
+Got expected exception Cursor 'SQLCUR21' is not on a row.
 Move to next row in the 2nd resultset and then delete using the second resultset
 Positive Test11 - setting the fetch size to > 1 will be ignored by updatable resultset. Same as updatable cursors
 Notice the Fetch Size in run time statistics output.
@@ -3047,7 +3069,7 @@
 	{2,bb                  }
 	{3,cc                  }
 SQL State : 42X31
-Got expected exception Column 'C2' is not in the FOR UPDATE list of cursor 'SQLCUR37'.
+Got expected exception Column 'C2' is not in the FOR UPDATE list of cursor 'SQLCUR39'.
 updateRow passed
   Make sure the contents of table are unchanged
 	 C1,C2



Mime
View raw message