Author: kmarsden
Date: Fri Sep 9 18:26:34 2005
New Revision: 279930
URL: http://svn.apache.org/viewcvs?rev=279930&view=rev
Log:
DERBY-213 Master update for updatableResultSet.out for jdk131
Contributed by Deepa Remesh
Modified:
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/updatableResultSet.out
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=279930&r1=279929&r2=279930&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 Sep 9 18:26:34 2005
@@ -70,11 +70,11 @@
SQL State : null
Got expected exception Invalid operation to update at current cursor position
ResultSet is positioned after the last row. attempt to deleteRow at this point should fail!
-SQL State : null
-Got expected exception Invalid operation: result set closed
+SQL State : XCL08
+Got expected exception Cursor '<xxx-cursor-name-xxx>' is not on a row.
ResultSet is positioned after the last row. attempt to updateRow at this point should fail!
SQL State : null
-Got expected exception Invalid operation: result set closed
+Got expected exception Invalid operation to update at current cursor position
Negative Test8 - attempt deleteRow & updateRow on updatable resultset after closing the
resultset
Make sure that we got CONCUR_UPDATABLE? true
SQL State : null
@@ -374,8 +374,8 @@
Positive Test13a - Another test case for delete trigger
column 1 on this row is 1
this delete row will fire the delete trigger which will delete all the rows from the table
and from the resultset
-SQL State : null
-Got expected exception Invalid operation: result set closed
+SQL State : XCL08
+Got expected exception Cursor '<xxx-cursor-name-xxx>' is not on a row.
Verify that delete trigger got fired by verifying the row count to be 0 in table1WithTriggers
1
-
@@ -391,7 +391,7 @@
column 1 on this row is 2
this update row will fire the update trigger which will update all the rows in the table
to have c1=1 and hence no more rows will qualify for the resultset
SQL State : null
-Got expected exception Invalid operation: result set closed
+Got expected exception Invalid operation to update at current cursor position
Verify that update trigger got fired by verifying that all column c1s have value 1 in table2WithTriggers
C1,C2
-- --
@@ -408,8 +408,8 @@
{e4,e3}
column 1 on this row is e1
this delete row will cause the delete cascade constraint to delete all the rows from the
table and from the resultset
-SQL State : null
-Got expected exception Invalid operation: result set closed
+SQL State : XCL08
+Got expected exception Cursor '<xxx-cursor-name-xxx>' is not on a row.
Verify that delete trigger got fired by verifying the row count to be 0 in selfReferencingT1
1
-