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 da...@apache.org on 2006/04/14 00:59:24 UTC
svn commit: r393967 [4/4] - in /db/derby/code/trunk:
java/build/org/apache/derbyBuild/ java/client/org/apache/derby/client/am/
java/client/org/apache/derby/loc/ java/engine/org/apache/derby/impl/jdbc/
java/engine/org/apache/derby/loc/ java/shared/org/a...
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=393967&r1=393966&r2=393967&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 Thu Apr 13 15:59:22 2006
@@ -8,10 +8,10 @@
othersDeletesAreVisible(ResultSet.TYPE_SCROLL_INSENSITIVE)? false
deletesAreDetected(ResultSet.TYPE_SCROLL_INSENSITIVE)? false
JDBC 2.0 updatable resultset api will fail on this resultset because this is not an updatable resultset
-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.
-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.
+SQL State : XJ086
+Got expected exception This method cannot be invoked while the cursor is not on the insert row or if the concurrency of this ResultSet object is CONCUR_READ_ONLY.
+SQL State : XJ086
+Got expected exception This method cannot be invoked while the cursor is not on the insert row or if the concurrency of this ResultSet object is CONCUR_READ_ONLY.
Negative Test2 - request for scroll sensitive updatable resultset will give a read only scroll insensitive resultset
WARNING 01J10: Scroll sensitive result sets are not supported by server; remapping to forward-only cursor
requested TYPE_SCROLL_SENSITIVE, CONCUR_UPDATABLE but that is not supported
@@ -19,44 +19,44 @@
Make sure that we got TYPE_SCROLL_INSENSITIVE? true
Make sure that we got CONCUR_READ_ONLY? true
JDBC 2.0 updatable resultset api will fail on this resultset because this is not an updatable resultset
-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.
-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.
+SQL State : XJ086
+Got expected exception This method cannot be invoked while the cursor is not on the insert row or if the concurrency of this ResultSet object is CONCUR_READ_ONLY.
+SQL State : XJ086
+Got expected exception This method cannot be invoked while the cursor is not on the insert row or if the concurrency of this ResultSet object is CONCUR_READ_ONLY.
Negative Test3 - request a read only resultset and attempt deleteRow and updateRow on it
Make sure that we got CONCUR_READ_ONLY? true
Now attempting to send a deleteRow on a read only resultset.
-SQL State : null
-Got expected exception This method cannot be invoked while the cursor is on the insert row or if the concurrency of this ResultSet object is CONCUR_READ_ONLY.
+SQL State : XJ086
+Got expected exception This method cannot be invoked while the cursor is not on the insert row or if the concurrency of this ResultSet object is CONCUR_READ_ONLY.
Now attempting to send an updateRow on a read only resultset.
-SQL State : null
-Got expected exception This method cannot be invoked while the cursor is on the insert row or if the concurrency of this ResultSet object is CONCUR_READ_ONLY.
+SQL State : XJ086
+Got expected exception This method cannot be invoked while the cursor is not on the insert row or if the concurrency of this ResultSet object is CONCUR_READ_ONLY.
Negative Test4 - request a read only resultset and send a sql with FOR UPDATE clause and attempt deleteRow/updateRow on it
Make sure that we got CONCUR_READ_ONLY? true
Now attempting to send a deleteRow 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.
+SQL State : XJ086
+Got expected exception This method cannot be invoked while the cursor is not on the insert row or if the concurrency of this ResultSet object is CONCUR_READ_ONLY.
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.
+SQL State : XJ086
+Got expected exception This method cannot be invoked while the cursor is not on the insert row or if the concurrency of this ResultSet object is CONCUR_READ_ONLY.
Negative Test5 - request resultset with no FOR UPDATE clause and CONCUR_READ_ONLY
Make sure that we got CONCUR_READ_ONLY? true
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.
+SQL State : XJ086
+Got expected exception This method cannot be invoked while the cursor is not 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 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.
+SQL State : XJ086
+Got expected exception This method cannot be invoked while the cursor is not 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
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 FOR READ ONLY clause.
-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.
+SQL State : XJ086
+Got expected exception This method cannot be invoked while the cursor is not 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 FOR READ ONLY clause.
-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.
+SQL State : XJ086
+Got expected exception This method cannot be invoked while the cursor is not on the insert row or if the concurrency of this ResultSet object is CONCUR_READ_ONLY.
Negative Test7 - attempt to deleteRow & updateRow on updatable resultset when the resultset is not positioned on a row
Make sure that we got CONCUR_UPDATABLE? true
Now attempt a deleteRow without first doing next on the resultset.
@@ -64,20 +64,20 @@
Got expected exception Cursor '<xxx-cursor-name-xxx>' is not on a row.
Now attempt a updateRow without first doing next on the resultset.
updateRow will check if it is on a row or not even though no changes have been made to the row using updateXXX
-SQL State : null
-Got expected exception Invalid operation to update at current cursor position
+SQL State : XJ121
+Got expected exception Invalid operation at current cursor position.
ResultSet is positioned after the last row. attempt to deleteRow at this point should fail!
SQL State : XCL07
Got expected exception Cursor '<xxx-cursor-name-xxx>' is closed. Verify that autocommit is OFF.
ResultSet is positioned after the last row. attempt to updateRow at this point should fail!
-SQL State : null
-Got expected exception Invalid operation to update at current cursor position
+SQL State : XJ121
+Got expected exception Invalid operation 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
-Got expected exception Invalid operation: result set closed
-SQL State : null
-Got expected exception Invalid operation: result set closed
+SQL State : XJ012
+Got expected exception 'ResultSet' already closed.
+SQL State : XJ012
+Got expected exception 'ResultSet' already closed.
Negative Test9 - try updatable resultset on system table
SQL State : 42Y90
Got expected exception FOR UPDATE is not permitted in this type of statement.
@@ -109,12 +109,12 @@
Jira entry Derby-160 : for Network Server because next should have failed
FAIL!!! next should have failed because foreign key constraint failure resulted in a runtime rollback
Negative Test15 - Can't call updateXXX methods on columns that do not correspond to a column in the table
-SQL State : null
-Got expected exception Column not updatable
+SQL State : XJ124
+Got expected exception Column not updatable.
Negative Test16 - Call updateXXX method on out of the range column
There are only 2 columns in the select list and we are trying to send updateXXX on column position 3
-SQL State : null
-Got expected exception Invalid argument: parameter index 3 is out of range.
+SQL State : XCL14
+Got expected exception The column position '3' is out of range. The number of columns for this ResultSet is '2'.
Positive Test1a - request updatable resultset for forward only type resultset
requested TYPE_FORWARD_ONLY, CONCUR_UPDATABLE
got TYPE_FORWARD_ONLY? true
@@ -123,8 +123,8 @@
column 1 on this row before deleteRow is 1
column 2 on this row before deleteRow is aa
Since after deleteRow(), in embedded mode and Network Server mode using Derby Net Client, ResultSet is positioned before the next row, getXXX will fail
-SQL State : null
-Got expected exception Invalid operation to read at current cursor position.
+SQL State : XJ121
+Got expected exception Invalid operation at current cursor position.
calling deleteRow 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.
@@ -136,11 +136,11 @@
column 2 on this row before updateString is aa
now updateRow on the row
Since after updateRow(), in embedded mode and Network Server mode using Derby Net Client, ResultSet is positioned before the next row, getXXX will fail
-SQL State : null
-Got expected exception Invalid operation to read at current cursor position.
+SQL State : XJ121
+Got expected exception Invalid operation at current cursor position.
calling updateRow again w/o first positioning the ResultSet on the next row will fail
-SQL State : null
-Got expected exception Invalid operation to update at current cursor position
+SQL State : XJ121
+Got expected exception Invalid operation 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
@@ -162,8 +162,8 @@
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)
+SQL State : XJ125
+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()
@@ -188,8 +188,8 @@
got CONCUR_UPDATABLE? true
column 1 on this row is 1
Since after deleteRow(), ResultSet is positioned before the next row, getXXX will fail
-SQL State : null
-Got expected exception Invalid operation to read at current cursor position.
+SQL State : XJ121
+Got expected exception Invalid operation at current cursor position.
calling deleteRow 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.
@@ -202,14 +202,14 @@
column 1 on this row is 1
column 1 on this row after updateInt is 5
Since after updateRow(), ResultSet is positioned before the next row, getXXX will fail
-SQL State : null
-Got expected exception Invalid operation to read at current cursor position.
+SQL State : XJ121
+Got expected exception Invalid operation at current cursor position.
calling updateRow/updateXXX again w/o first positioning the ResultSet on the next row will fail
-SQL State : null
-Got expected exception Invalid operation to update at current cursor position
-SQL State : null
-Got expected exception Invalid operation to update at current cursor position
-SQL State : null
+SQL State : XJ121
+Got expected exception Invalid operation at current cursor position.
+SQL State : XJ121
+Got expected exception Invalid operation at current cursor position.
+SQL State : XJ121
Got expected exception Invalid operation at current cursor position.
Position the ResultSet with next()
Should be able to cancelRowUpdates() on the current row now
@@ -219,8 +219,8 @@
got CONCUR_UPDATABLE? true
column 1 on this row is 1
Since after deleteRow(), ResultSet is positioned before the next row, getXXX will fail
-SQL State : null
-Got expected exception Invalid operation to read at current cursor position.
+SQL State : XJ121
+Got expected exception Invalid operation at current cursor position.
calling deleteRow 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.
@@ -306,8 +306,8 @@
{2,bb }
{3,cc }
Positive Test9c - try to updateXXX on a readonly column. Should get error
-SQL State : null
-Got expected exception Column not updatable
+SQL State : XJ124
+Got expected exception Column not updatable.
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
@@ -317,8 +317,8 @@
{2,bb }
{3,cc }
Positive Test9d - try to updateXXX on a readonly column with correlation name. Should get error
-SQL State : null
-Got expected exception Column not updatable
+SQL State : XJ124
+Got expected exception Column not updatable.
Table t1 has following rows
C1,C2
-- --
@@ -412,8 +412,8 @@
{4,4}
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 to update at current cursor position
+SQL State : XJ121
+Got expected exception Invalid operation at current cursor position.
Verify that update trigger got fired by verifying that all column c1s have value 1 in table2WithTriggers
C1,C2
-- --
@@ -517,105 +517,105 @@
{4,4}
Positive Test17 - After deleteRow, resultset is positioned before the next row
getXXX right after deleteRow will fail because resultset is not positioned on a row, instead it is right before the next row
-SQL State : null
-Got expected exception Invalid operation to read at current cursor position.
+SQL State : XJ121
+Got expected exception Invalid operation at current cursor position.
Positive Test18 - Test cancelRowUpdates method as the first updatable ResultSet api on a read-only resultset
-SQL State : null
-Got expected exception This method cannot be invoked while the cursor is on the insert row or if this ResultSet object has a concurrency of CONCUR_READ_ONLY.
+SQL State : XJ086
+Got expected exception This method cannot be invoked while the cursor is not on the insert row or if the concurrency of this ResultSet object is CONCUR_READ_ONLY.
Positive Test19 - Test updateRow method as the first updatable ResultSet api on a read-only resultset
- Got expected exception : This method cannot be invoked while the cursor is on the insert row or if the concurrency of this ResultSet object is CONCUR_READ_ONLY.
+ Got expected exception : This method cannot be invoked while the cursor is not on the insert row or if the concurrency of this ResultSet object is CONCUR_READ_ONLY.
Positive Test20 - Test updateXXX methods as the first updatable ResultSet api on a read-only resultset
Test updateShort on a readonly resultset
Using column position as first parameter to updateShort
- Got expected exception : ResultSet is not updatable.
+ Got expected exception : 'updateXXX' not allowed because the ResultSet is not an updatable ResultSet.
Using column name as first parameter to updateShort
- Got expected exception : ResultSet is not updatable.
+ Got expected exception : 'updateXXX' not allowed because the ResultSet is not an updatable ResultSet.
Test updateInt on a readonly resultset
Using column position as first parameter to updateInt
- Got expected exception : ResultSet is not updatable.
+ Got expected exception : 'updateXXX' not allowed because the ResultSet is not an updatable ResultSet.
Using column name as first parameter to updateInt
- Got expected exception : ResultSet is not updatable.
+ Got expected exception : 'updateXXX' not allowed because the ResultSet is not an updatable ResultSet.
Test updateLong on a readonly resultset
Using column position as first parameter to updateLong
- Got expected exception : ResultSet is not updatable.
+ Got expected exception : 'updateXXX' not allowed because the ResultSet is not an updatable ResultSet.
Using column name as first parameter to updateLong
- Got expected exception : ResultSet is not updatable.
+ Got expected exception : 'updateXXX' not allowed because the ResultSet is not an updatable ResultSet.
Test updateBigDecimal on a readonly resultset
Using column position as first parameter to updateBigDecimal
- Got expected exception : ResultSet is not updatable.
+ Got expected exception : 'updateXXX' not allowed because the ResultSet is not an updatable ResultSet.
Using column name as first parameter to updateBigDecimal
- Got expected exception : ResultSet is not updatable.
+ Got expected exception : 'updateXXX' not allowed because the ResultSet is not an updatable ResultSet.
Test updateFloat on a readonly resultset
Using column position as first parameter to updateFloat
- Got expected exception : ResultSet is not updatable.
+ Got expected exception : 'updateXXX' not allowed because the ResultSet is not an updatable ResultSet.
Using column name as first parameter to updateFloat
- Got expected exception : ResultSet is not updatable.
+ Got expected exception : 'updateXXX' not allowed because the ResultSet is not an updatable ResultSet.
Test updateDouble on a readonly resultset
Using column position as first parameter to updateDouble
- Got expected exception : ResultSet is not updatable.
+ Got expected exception : 'updateXXX' not allowed because the ResultSet is not an updatable ResultSet.
Using column name as first parameter to updateDouble
- Got expected exception : ResultSet is not updatable.
+ Got expected exception : 'updateXXX' not allowed because the ResultSet is not an updatable ResultSet.
Test updateString on a readonly resultset
Using column position as first parameter to updateString
- Got expected exception : ResultSet is not updatable.
+ Got expected exception : 'updateXXX' not allowed because the ResultSet is not an updatable ResultSet.
Using column name as first parameter to updateString
- Got expected exception : ResultSet is not updatable.
+ Got expected exception : 'updateXXX' not allowed because the ResultSet is not an updatable ResultSet.
Test updateAsciiStream on a readonly resultset
Using column position as first parameter to updateAsciiStream
- Got expected exception : ResultSet is not updatable.
+ Got expected exception : 'updateXXX' not allowed because the ResultSet is not an updatable ResultSet.
Using column name as first parameter to updateAsciiStream
- Got expected exception : ResultSet is not updatable.
+ Got expected exception : 'updateXXX' not allowed because the ResultSet is not an updatable ResultSet.
Test updateCharacterStream on a readonly resultset
Using column position as first parameter to updateCharacterStream
- Got expected exception : ResultSet is not updatable.
+ Got expected exception : 'updateXXX' not allowed because the ResultSet is not an updatable ResultSet.
Using column name as first parameter to updateCharacterStream
- Got expected exception : ResultSet is not updatable.
+ Got expected exception : 'updateXXX' not allowed because the ResultSet is not an updatable ResultSet.
Test updateByte on a readonly resultset
Using column position as first parameter to updateByte
- Got expected exception : ResultSet is not updatable.
+ Got expected exception : 'updateXXX' not allowed because the ResultSet is not an updatable ResultSet.
Using column name as first parameter to updateByte
- Got expected exception : ResultSet is not updatable.
+ Got expected exception : 'updateXXX' not allowed because the ResultSet is not an updatable ResultSet.
Test updateBytes on a readonly resultset
Using column position as first parameter to updateBytes
- Got expected exception : ResultSet is not updatable.
+ Got expected exception : 'updateXXX' not allowed because the ResultSet is not an updatable ResultSet.
Using column name as first parameter to updateBytes
- Got expected exception : ResultSet is not updatable.
+ Got expected exception : 'updateXXX' not allowed because the ResultSet is not an updatable ResultSet.
Test updateBinaryStream on a readonly resultset
Using column position as first parameter to updateBinaryStream
- Got expected exception : ResultSet is not updatable.
+ Got expected exception : 'updateXXX' not allowed because the ResultSet is not an updatable ResultSet.
Using column name as first parameter to updateBinaryStream
- Got expected exception : ResultSet is not updatable.
+ Got expected exception : 'updateXXX' not allowed because the ResultSet is not an updatable ResultSet.
Test updateClob on a readonly resultset
Using column position as first parameter to updateClob
Using column name as first parameter to updateClob
Test updateDate on a readonly resultset
Using column position as first parameter to updateDate
- Got expected exception : ResultSet is not updatable.
+ Got expected exception : 'updateXXX' not allowed because the ResultSet is not an updatable ResultSet.
Using column name as first parameter to updateDate
- Got expected exception : ResultSet is not updatable.
+ Got expected exception : 'updateXXX' not allowed because the ResultSet is not an updatable ResultSet.
Test updateTime on a readonly resultset
Using column position as first parameter to updateTime
- Got expected exception : ResultSet is not updatable.
+ Got expected exception : 'updateXXX' not allowed because the ResultSet is not an updatable ResultSet.
Using column name as first parameter to updateTime
- Got expected exception : ResultSet is not updatable.
+ Got expected exception : 'updateXXX' not allowed because the ResultSet is not an updatable ResultSet.
Test updateTimestamp on a readonly resultset
Using column position as first parameter to updateTimestamp
- Got expected exception : ResultSet is not updatable.
+ Got expected exception : 'updateXXX' not allowed because the ResultSet is not an updatable ResultSet.
Using column name as first parameter to updateTimestamp
- Got expected exception : ResultSet is not updatable.
+ Got expected exception : 'updateXXX' not allowed because the ResultSet is not an updatable ResultSet.
Test updateBlob on a readonly resultset
Using column position as first parameter to updateBlob
Using column name as first parameter to updateBlob
Test updateBoolean on a readonly resultset
Using column position as first parameter to updateBoolean
- Got expected exception : ResultSet is not updatable.
+ Got expected exception : 'updateXXX' not allowed because the ResultSet is not an updatable ResultSet.
Using column name as first parameter to updateBoolean
- Got expected exception : ResultSet is not updatable.
+ Got expected exception : 'updateXXX' not allowed because the ResultSet is not an updatable ResultSet.
Test updateNull on a readonly resultset
Using column position as first parameter to updateNull
- Got expected exception : ResultSet is not updatable.
+ Got expected exception : 'updateXXX' not allowed because the ResultSet is not an updatable ResultSet.
Using column name as first parameter to updateNull
- Got expected exception : ResultSet is not updatable.
+ Got expected exception : 'updateXXX' not allowed because the ResultSet is not an updatable ResultSet.
Test updateArray on a readonly resultset
Using column position as first parameter to updateArray
Using column name as first parameter to updateArray
@@ -2754,19 +2754,19 @@
Since after cancelRowUpdates(), ResultSet is positioned on the same row, a deleteRow at this point will pass
PASS : deleteRow passed as expected
calling updateRow after deleteRow w/o first positioning the ResultSet on the next row will fail
-SQL State : null
-Got expected exception Invalid operation to update at current cursor position
+SQL State : XJ121
+Got expected exception Invalid operation at current cursor position.
Position the ResultSet with next()
Should be able to updateRow() on the current row now
Positive Test25 - issue cancelRowUpdates without any updateXXX
Positive Test26 - issue updateRow without any updateXXX will not move the resultset position
Positive Test27 - issue updateXXX and then deleteRow
-SQL State : null
-Got expected exception Invalid operation to update at current cursor position
-SQL State : null
-Got expected exception Invalid operation to update at current cursor position
-SQL State : null
-Got expected exception Invalid operation to read at current cursor position.
+SQL State : XJ121
+Got expected exception Invalid operation at current cursor position.
+SQL State : XJ121
+Got expected exception Invalid operation at current cursor position.
+SQL State : XJ121
+Got expected exception Invalid operation at current cursor position.
Positive Test28 - issue updateXXXs and then move off the row, the changes should be ignored
C1,C2
-- --
@@ -2827,8 +2827,8 @@
{22,xxxxxxx }
{2,bb }
{3,cc }
-SQL State : null
-Got expected exception Column not updatable
+SQL State : XJ124
+Got expected exception Column not updatable.
updateRow passed
Make sure the contents of table are unchanged
C1,C2
@@ -2914,13 +2914,13 @@
Got expected exception: Column 'C41' cannot accept a NULL value.
Negative Test 39 - run updateRow and deleterow when positioned at insertRow
Negative Test 39.a - run updateRow on insertRow
-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.
+SQL State: XJ086
+Got expected exception: This method cannot be invoked while the cursor is not on the insert row or if the concurrency of this ResultSet object is CONCUR_READ_ONLY.
Negative Test 39.a - run deleteRow on insertRow
-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.
+SQL State: XJ086
+Got expected exception: This method cannot be invoked while the cursor is not on the insert row or if the concurrency of this ResultSet object is CONCUR_READ_ONLY.
Negative test 40 - Try to insert row from currentRow
-SQL State: null
+SQL State: XJ086
Got expected exception: This method cannot be invoked while the cursor is not on the insert row or if the concurrency of this ResultSet object is CONCUR_READ_ONLY.
Positive test 41 - try to insertRow from all posible positions
Positive test 42 - InsertRow leaving a nullable columns = NULL
@@ -2931,29 +2931,29 @@
Negative test 43 - Commit while on insertRow with not holdable cursor
Negative test 44 - Closed RS
Negative test 44.a - try insertRow on closed RS
-SQL State: null
-Got expected exception: Invalid operation: result set closed
+SQL State: XJ012
+Got expected exception: 'ResultSet' already closed.
Negative test 44.b - try moveToCurrentRow on closed RS
-SQL State: null
-Got expected exception: Invalid operation: result set closed
+SQL State: XJ012
+Got expected exception: 'ResultSet' already closed.
Negative test 44.c - try moveToInsertRow on closed RS
-SQL State: null
-Got expected exception: Invalid operation: result set closed
+SQL State: XJ012
+Got expected exception: 'ResultSet' already closed.
Positive test 45 - try to insert without updating all columns. All columns allow nulls or have a default value
Positive test 46 - Rollback with AutoCommit on
Negative test 47 - insertRow and read-only RS
Negative test 47.a - try moveToInsertRow on read-only RS
-SQL State: null
-Got expected exception: This method should only be called on ResultSet objects that are updatable(concurrency type CONCUR_UPDATABLE).
+SQL State: XJ083
+Got expected exception: 'moveToInsertRow()' not allowed because the ResultSet is not an updatable ResultSet.
Negative test 47.b - try updateXXX on read-only RS
-SQL State: null
-Got expected exception: ResultSet is not updatable.
+SQL State: XJ083
+Got expected exception: 'updateXXX' not allowed because the ResultSet is not an updatable ResultSet.
Negative test 47.c - try insertRow on read-only RS
-SQL State: null
+SQL State: XJ086
Got expected exception: This method cannot be invoked while the cursor is not on the insert row or if the concurrency of this ResultSet object is CONCUR_READ_ONLY.
Negative test 47.d - try moveToCurrentRow on read-only RS
-SQL State: null
-Got expected exception: This method should only be called on ResultSet objects that are updatable(concurrency type CONCUR_UPDATABLE).
+SQL State: XJ083
+Got expected exception: 'moveToCurrentRow()' not allowed because the ResultSet is not an updatable ResultSet.
Positive test 48 - Test all updateXXX methods on all the supported sql datatypes
Next datatype to test is SMALLINT
Testing updateShort on SQL type SMALLINT
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=393967&r1=393966&r2=393967&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 Thu Apr 13 15:59:22 2006
@@ -3158,7 +3158,7 @@
Got expected exception: Invalid cursor state - no current row.
Negative test 40 - Try to insert row from currentRow
SQL State: XJ086
-Got expected exception: This method cannot be invoked unless the cursor is positioned on the insert row.
+Got expected exception: This method cannot be invoked while the cursor is not on the insert row or if the concurrency of this ResultSet object is CONCUR_READ_ONLY.
Positive test 41 - try to insertRow from all posible positions
Positive test 42 - InsertRow leaving a nullable columns = NULL
Positive and negative tests 43 - Commit while on insertRow
Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/updatableResultSet.out
URL: http://svn.apache.org/viewcvs/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/updatableResultSet.out?rev=393967&r1=393966&r2=393967&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/updatableResultSet.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/updatableResultSet.out Thu Apr 13 15:59:22 2006
@@ -2884,7 +2884,7 @@
Got expected exception: Invalid cursor state - no current row.
Negative test 40 - Try to insert row from currentRow
SQL State: XJ086
-Got expected exception: This method cannot be invoked unless the cursor is positioned on the insert row.
+Got expected exception: This method cannot be invoked while the cursor is not on the insert row or if the concurrency of this ResultSet object is CONCUR_READ_ONLY.
Positive test 41 - try to insertRow from all posible positions
Positive test 42 - InsertRow leaving a nullable columns = NULL
Positive and negative tests 43 - Commit while on insertRow
Modified: db/derby/code/trunk/tools/testing/i18nTestGenerator/genClient2.sed
URL: http://svn.apache.org/viewcvs/db/derby/code/trunk/tools/testing/i18nTestGenerator/genClient2.sed?rev=393967&r1=393966&r2=393967&view=diff
==============================================================================
--- db/derby/code/trunk/tools/testing/i18nTestGenerator/genClient2.sed (original)
+++ db/derby/code/trunk/tools/testing/i18nTestGenerator/genClient2.sed Thu Apr 13 15:59:22 2006
@@ -27,7 +27,7 @@
# compile errors saying "symbol not found"
#
s/fileName/"fileName"/g
-s/e.getMessage()/"e.getMessage"/g
+s/[[:space:]]e.getMessage()/"e.getMessage"/g
s/Configuration.packageNameForDNC/"Configuration.packageNameForDNC"/g
s/Configuration.dncDriverName/"Configuration.dncDriverName"/g
s/[^\.]packageNameForDNC/"packageNameForDNC"/g
@@ -36,12 +36,26 @@
s/encoding/"encoding"/g
s/source.getClass().getName()/"source"/g
s/e.getException()/new Exception("foo")/g
-s/[[:space:]]e);/testException);/
-s/e.getClass().getName()/"exceptionClassName"/g
-s/[[:space:]]sourceType/"sourceType"/g
+s/[[:space:]]e);/ testException);/g
+s/[[:space:]]ae/ testException/g
+s/{ae/{testException/g
+s/[[:space:]]e.getClass().getName()/ "exceptionClassName"/g
+s/{e.getClass().getName()/{"exceptionClassName"/g
+s/[[:space:]]sourceType/ "sourceType"/g
s/[[:space:]]targetType/ "targetType"/g
s/[[:space:]]columnName/ "columnName"/g
s/[[:space:]]charsetName/ "charsetName"/g
+s/[[:space:]]cursorName/ "cursorName"/g
+s/[[:space:]]cursorName/ "cursorName"/g
+s/[[:space:]]methodName/ "methodName"/g
+
+#
+# Deal with extra updateCounts argument to BatchUpdateExceptoins.
+# This is a bit of a hack, but turn them into a Throwable. Otherwise
+# the SqlException code thinks its another Object argument to the
+# message and we get a runtime assertion error
+s/updateCounts/(Throwable)null/g
+
#
# Subsitute Long and Integer params with 0 as a default