You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-commits@db.apache.org by be...@apache.org on 2005/11/11 09:42:33 UTC
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/...
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