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 [2/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/jdk14/LOBTest.out
URL: http://svn.apache.org/viewcvs/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/jdk14/LOBTest.out?rev=393967&r1=393966&r2=393967&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/jdk14/LOBTest.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/jdk14/LOBTest.out Thu Apr 13 15:59:22 2006
@@ -2761,7 +2761,7 @@
 === Columntype int
 select col_0 as col_0_1, col_0 as col_0_2, col_0 as col_0_3, col_0 as col_0_4, col_0 as col_0_5, col_0 as col_0_6, col_0 as col_0_7, col_0 as col_0_8, col_0 as col_0_9, col_0 as col_0_10, col_0 as col_0_11, col_0 as col_0_12, col_0 as col_0_13, col_0 as col_0_14, col_0 as col_0_15, col_0 as col_0_16, col_0 as col_0_17, col_0 as col_0_18, col_0 as col_0_19, col_0 as col_0_20, col_0 as col_0_21 from clob_table
 	0 getObject            ->		EXCEPTION (null)
-	0 getArray             ->		EXCEPTION (jdbc 2 method not yet implemented)
+	0 getArray             ->		EXCEPTION (JDBC method is not yet implemented.)
 	0 getAsciiStream       ->		EXCEPTION (null)
 	0 getBigDecimal        ->		EXCEPTION (null)
 	0 getBinaryStream      ->		EXCEPTION (null)
@@ -2776,7 +2776,7 @@
 	0 getFloat             ->'0.0'    	: java.lang.Float
 	0 getInt               ->'0'    	: java.lang.Integer
 	0 getLong              ->'0'    	: java.lang.Long
-	0 getRef               ->		EXCEPTION (jdbc 2 method not yet implemented)
+	0 getRef               ->		EXCEPTION (JDBC method is not yet implemented.)
 	0 getShort             ->'0'    	: java.lang.Short
 	0 getString            ->		EXCEPTION (null)
 	0 getTime              ->		EXCEPTION (null)
@@ -2807,7 +2807,7 @@
 === Columntype varchar(80)
 select col_2 as col_2_1, col_2 as col_2_2, col_2 as col_2_3, col_2 as col_2_4, col_2 as col_2_5, col_2 as col_2_6, col_2 as col_2_7, col_2 as col_2_8, col_2 as col_2_9, col_2 as col_2_10, col_2 as col_2_11, col_2 as col_2_12, col_2 as col_2_13, col_2 as col_2_14, col_2 as col_2_15, col_2 as col_2_16, col_2 as col_2_17, col_2 as col_2_18, col_2 as col_2_19, col_2 as col_2_20, col_2 as col_2_21 from clob_table
 	2 getObject            ->		EXCEPTION (null)
-	2 getArray             ->		EXCEPTION (jdbc 2 method not yet implemented)
+	2 getArray             ->		EXCEPTION (JDBC method is not yet implemented.)
 	2 getAsciiStream       ->		EXCEPTION (null)
 	2 getBigDecimal        ->		EXCEPTION (null)
 	2 getBinaryStream      ->		EXCEPTION (null)
@@ -2822,7 +2822,7 @@
 	2 getFloat             ->'0.0'    	: java.lang.Float
 	2 getInt               ->'0'    	: java.lang.Integer
 	2 getLong              ->'0'    	: java.lang.Long
-	2 getRef               ->		EXCEPTION (jdbc 2 method not yet implemented)
+	2 getRef               ->		EXCEPTION (JDBC method is not yet implemented.)
 	2 getShort             ->'0'    	: java.lang.Short
 	2 getString            ->		EXCEPTION (null)
 	2 getTime              ->		EXCEPTION (null)
@@ -2830,7 +2830,7 @@
 === Columntype long varchar
 select col_3 as col_3_1, col_3 as col_3_2, col_3 as col_3_3, col_3 as col_3_4, col_3 as col_3_5, col_3 as col_3_6, col_3 as col_3_7, col_3 as col_3_8, col_3 as col_3_9, col_3 as col_3_10, col_3 as col_3_11, col_3 as col_3_12, col_3 as col_3_13, col_3 as col_3_14, col_3 as col_3_15, col_3 as col_3_16, col_3 as col_3_17, col_3 as col_3_18, col_3 as col_3_19, col_3 as col_3_20, col_3 as col_3_21 from clob_table
 	3 getObject            ->		EXCEPTION (null)
-	3 getArray             ->		EXCEPTION (jdbc 2 method not yet implemented)
+	3 getArray             ->		EXCEPTION (JDBC method is not yet implemented.)
 	3 getAsciiStream       ->		EXCEPTION (null)
 	3 getBigDecimal        ->		EXCEPTION (null)
 	3 getBinaryStream      ->		EXCEPTION (null)
@@ -2845,7 +2845,7 @@
 	3 getFloat             ->'0.0'    	: java.lang.Float
 	3 getInt               ->'0'    	: java.lang.Integer
 	3 getLong              ->'0'    	: java.lang.Long
-	3 getRef               ->		EXCEPTION (jdbc 2 method not yet implemented)
+	3 getRef               ->		EXCEPTION (JDBC method is not yet implemented.)
 	3 getShort             ->'0'    	: java.lang.Short
 	3 getString            ->		EXCEPTION (null)
 	3 getTime              ->		EXCEPTION (null)
@@ -2853,7 +2853,7 @@
 === Columntype char(10) for bit data
 select col_4 as col_4_1, col_4 as col_4_2, col_4 as col_4_3, col_4 as col_4_4, col_4 as col_4_5, col_4 as col_4_6, col_4 as col_4_7, col_4 as col_4_8, col_4 as col_4_9, col_4 as col_4_10, col_4 as col_4_11, col_4 as col_4_12, col_4 as col_4_13, col_4 as col_4_14, col_4 as col_4_15, col_4 as col_4_16, col_4 as col_4_17, col_4 as col_4_18, col_4 as col_4_19, col_4 as col_4_20, col_4 as col_4_21 from clob_table
 	4 getObject            ->		EXCEPTION (null)
-	4 getArray             ->		EXCEPTION (jdbc 2 method not yet implemented)
+	4 getArray             ->		EXCEPTION (JDBC method is not yet implemented.)
 	4 getAsciiStream       ->		EXCEPTION (null)
 	4 getBigDecimal        ->		EXCEPTION (null)
 	4 getBinaryStream      ->		EXCEPTION (null)
@@ -2868,7 +2868,7 @@
 	4 getFloat             ->'0.0'    	: java.lang.Float
 	4 getInt               ->'0'    	: java.lang.Integer
 	4 getLong              ->'0'    	: java.lang.Long
-	4 getRef               ->		EXCEPTION (jdbc 2 method not yet implemented)
+	4 getRef               ->		EXCEPTION (JDBC method is not yet implemented.)
 	4 getShort             ->'0'    	: java.lang.Short
 	4 getString            ->		EXCEPTION (null)
 	4 getTime              ->		EXCEPTION (null)
@@ -2876,7 +2876,7 @@
 === Columntype long varchar for bit data
 select col_5 as col_5_1, col_5 as col_5_2, col_5 as col_5_3, col_5 as col_5_4, col_5 as col_5_5, col_5 as col_5_6, col_5 as col_5_7, col_5 as col_5_8, col_5 as col_5_9, col_5 as col_5_10, col_5 as col_5_11, col_5 as col_5_12, col_5 as col_5_13, col_5 as col_5_14, col_5 as col_5_15, col_5 as col_5_16, col_5 as col_5_17, col_5 as col_5_18, col_5 as col_5_19, col_5 as col_5_20, col_5 as col_5_21 from clob_table
 	5 getObject            ->		EXCEPTION (null)
-	5 getArray             ->		EXCEPTION (jdbc 2 method not yet implemented)
+	5 getArray             ->		EXCEPTION (JDBC method is not yet implemented.)
 	5 getAsciiStream       ->		EXCEPTION (null)
 	5 getBigDecimal        ->		EXCEPTION (null)
 	5 getBinaryStream      ->		EXCEPTION (null)
@@ -2891,7 +2891,7 @@
 	5 getFloat             ->'0.0'    	: java.lang.Float
 	5 getInt               ->'0'    	: java.lang.Integer
 	5 getLong              ->'0'    	: java.lang.Long
-	5 getRef               ->		EXCEPTION (jdbc 2 method not yet implemented)
+	5 getRef               ->		EXCEPTION (JDBC method is not yet implemented.)
 	5 getShort             ->'0'    	: java.lang.Short
 	5 getString            ->		EXCEPTION (null)
 	5 getTime              ->		EXCEPTION (null)
@@ -2899,7 +2899,7 @@
 === Columntype blob(80)
 select col_6 as col_6_1, col_6 as col_6_2, col_6 as col_6_3, col_6 as col_6_4, col_6 as col_6_5, col_6 as col_6_6, col_6 as col_6_7, col_6 as col_6_8, col_6 as col_6_9, col_6 as col_6_10, col_6 as col_6_11, col_6 as col_6_12, col_6 as col_6_13, col_6 as col_6_14, col_6 as col_6_15, col_6 as col_6_16, col_6 as col_6_17, col_6 as col_6_18, col_6 as col_6_19, col_6 as col_6_20, col_6 as col_6_21 from clob_table
 	6 getObject            ->		EXCEPTION (null)
-	6 getArray             ->		EXCEPTION (jdbc 2 method not yet implemented)
+	6 getArray             ->		EXCEPTION (JDBC method is not yet implemented.)
 	6 getAsciiStream       ->		EXCEPTION (null)
 	6 getBigDecimal        ->		EXCEPTION (null)
 	6 getBinaryStream      ->		EXCEPTION (null)
@@ -2914,7 +2914,7 @@
 	6 getFloat             ->'0.0'    	: java.lang.Float
 	6 getInt               ->'0'    	: java.lang.Integer
 	6 getLong              ->'0'    	: java.lang.Long
-	6 getRef               ->		EXCEPTION (jdbc 2 method not yet implemented)
+	6 getRef               ->		EXCEPTION (JDBC method is not yet implemented.)
 	6 getShort             ->'0'    	: java.lang.Short
 	6 getString            ->		EXCEPTION (null)
 	6 getTime              ->		EXCEPTION (null)
@@ -2922,7 +2922,7 @@
 === Columntype clob (2 K)
 select typecol as typecol_1, typecol as typecol_2, typecol as typecol_3, typecol as typecol_4, typecol as typecol_5, typecol as typecol_6, typecol as typecol_7, typecol as typecol_8, typecol as typecol_9, typecol as typecol_10, typecol as typecol_11, typecol as typecol_12, typecol as typecol_13, typecol as typecol_14, typecol as typecol_15, typecol as typecol_16, typecol as typecol_17, typecol as typecol_18, typecol as typecol_19, typecol as typecol_20, typecol as typecol_21 from clob_table
 	7 getObject            ->		EXCEPTION (null)
-	7 getArray             ->		EXCEPTION (jdbc 2 method not yet implemented)
+	7 getArray             ->		EXCEPTION (JDBC method is not yet implemented.)
 	7 getAsciiStream       ->		EXCEPTION (null)
 	7 getBigDecimal        ->		EXCEPTION (null)
 	7 getBinaryStream      ->		EXCEPTION (null)
@@ -2937,7 +2937,7 @@
 	7 getFloat             ->'0.0'    	: java.lang.Float
 	7 getInt               ->'0'    	: java.lang.Integer
 	7 getLong              ->'0'    	: java.lang.Long
-	7 getRef               ->		EXCEPTION (jdbc 2 method not yet implemented)
+	7 getRef               ->		EXCEPTION (JDBC method is not yet implemented.)
 	7 getShort             ->'0'    	: java.lang.Short
 	7 getString            ->		EXCEPTION (null)
 	7 getTime              ->		EXCEPTION (null)
@@ -3314,7 +3314,7 @@
 === Columntype int
 select col_0 as col_0_1, col_0 as col_0_2, col_0 as col_0_3, col_0 as col_0_4, col_0 as col_0_5, col_0 as col_0_6, col_0 as col_0_7, col_0 as col_0_8, col_0 as col_0_9, col_0 as col_0_10, col_0 as col_0_11, col_0 as col_0_12, col_0 as col_0_13, col_0 as col_0_14, col_0 as col_0_15, col_0 as col_0_16, col_0 as col_0_17, col_0 as col_0_18, col_0 as col_0_19, col_0 as col_0_20, col_0 as col_0_21 from clob_table
 	0 getObject            ->		EXCEPTION (null)
-	0 getArray             ->		EXCEPTION (jdbc 2 method not yet implemented)
+	0 getArray             ->		EXCEPTION (JDBC method is not yet implemented.)
 	0 getAsciiStream       ->		EXCEPTION (null)
 	0 getBigDecimal        ->		EXCEPTION (null)
 	0 getBinaryStream      ->		EXCEPTION (null)
@@ -3329,7 +3329,7 @@
 	0 getFloat             ->'0.0'    	: java.lang.Float
 	0 getInt               ->'0'    	: java.lang.Integer
 	0 getLong              ->'0'    	: java.lang.Long
-	0 getRef               ->		EXCEPTION (jdbc 2 method not yet implemented)
+	0 getRef               ->		EXCEPTION (JDBC method is not yet implemented.)
 	0 getShort             ->'0'    	: java.lang.Short
 	0 getString            ->		EXCEPTION (null)
 	0 getTime              ->		EXCEPTION (null)
@@ -3360,7 +3360,7 @@
 === Columntype varchar(80)
 select col_2 as col_2_1, col_2 as col_2_2, col_2 as col_2_3, col_2 as col_2_4, col_2 as col_2_5, col_2 as col_2_6, col_2 as col_2_7, col_2 as col_2_8, col_2 as col_2_9, col_2 as col_2_10, col_2 as col_2_11, col_2 as col_2_12, col_2 as col_2_13, col_2 as col_2_14, col_2 as col_2_15, col_2 as col_2_16, col_2 as col_2_17, col_2 as col_2_18, col_2 as col_2_19, col_2 as col_2_20, col_2 as col_2_21 from clob_table
 	2 getObject            ->		EXCEPTION (null)
-	2 getArray             ->		EXCEPTION (jdbc 2 method not yet implemented)
+	2 getArray             ->		EXCEPTION (JDBC method is not yet implemented.)
 	2 getAsciiStream       ->		EXCEPTION (null)
 	2 getBigDecimal        ->		EXCEPTION (null)
 	2 getBinaryStream      ->		EXCEPTION (null)
@@ -3375,7 +3375,7 @@
 	2 getFloat             ->'0.0'    	: java.lang.Float
 	2 getInt               ->'0'    	: java.lang.Integer
 	2 getLong              ->'0'    	: java.lang.Long
-	2 getRef               ->		EXCEPTION (jdbc 2 method not yet implemented)
+	2 getRef               ->		EXCEPTION (JDBC method is not yet implemented.)
 	2 getShort             ->'0'    	: java.lang.Short
 	2 getString            ->		EXCEPTION (null)
 	2 getTime              ->		EXCEPTION (null)
@@ -3383,7 +3383,7 @@
 === Columntype long varchar
 select col_3 as col_3_1, col_3 as col_3_2, col_3 as col_3_3, col_3 as col_3_4, col_3 as col_3_5, col_3 as col_3_6, col_3 as col_3_7, col_3 as col_3_8, col_3 as col_3_9, col_3 as col_3_10, col_3 as col_3_11, col_3 as col_3_12, col_3 as col_3_13, col_3 as col_3_14, col_3 as col_3_15, col_3 as col_3_16, col_3 as col_3_17, col_3 as col_3_18, col_3 as col_3_19, col_3 as col_3_20, col_3 as col_3_21 from clob_table
 	3 getObject            ->		EXCEPTION (null)
-	3 getArray             ->		EXCEPTION (jdbc 2 method not yet implemented)
+	3 getArray             ->		EXCEPTION (JDBC method is not yet implemented.)
 	3 getAsciiStream       ->		EXCEPTION (null)
 	3 getBigDecimal        ->		EXCEPTION (null)
 	3 getBinaryStream      ->		EXCEPTION (null)
@@ -3398,7 +3398,7 @@
 	3 getFloat             ->'0.0'    	: java.lang.Float
 	3 getInt               ->'0'    	: java.lang.Integer
 	3 getLong              ->'0'    	: java.lang.Long
-	3 getRef               ->		EXCEPTION (jdbc 2 method not yet implemented)
+	3 getRef               ->		EXCEPTION (JDBC method is not yet implemented.)
 	3 getShort             ->'0'    	: java.lang.Short
 	3 getString            ->		EXCEPTION (null)
 	3 getTime              ->		EXCEPTION (null)
@@ -3406,7 +3406,7 @@
 === Columntype char(10) for bit data
 select col_4 as col_4_1, col_4 as col_4_2, col_4 as col_4_3, col_4 as col_4_4, col_4 as col_4_5, col_4 as col_4_6, col_4 as col_4_7, col_4 as col_4_8, col_4 as col_4_9, col_4 as col_4_10, col_4 as col_4_11, col_4 as col_4_12, col_4 as col_4_13, col_4 as col_4_14, col_4 as col_4_15, col_4 as col_4_16, col_4 as col_4_17, col_4 as col_4_18, col_4 as col_4_19, col_4 as col_4_20, col_4 as col_4_21 from clob_table
 	4 getObject            ->		EXCEPTION (null)
-	4 getArray             ->		EXCEPTION (jdbc 2 method not yet implemented)
+	4 getArray             ->		EXCEPTION (JDBC method is not yet implemented.)
 	4 getAsciiStream       ->		EXCEPTION (null)
 	4 getBigDecimal        ->		EXCEPTION (null)
 	4 getBinaryStream      ->		EXCEPTION (null)
@@ -3421,7 +3421,7 @@
 	4 getFloat             ->'0.0'    	: java.lang.Float
 	4 getInt               ->'0'    	: java.lang.Integer
 	4 getLong              ->'0'    	: java.lang.Long
-	4 getRef               ->		EXCEPTION (jdbc 2 method not yet implemented)
+	4 getRef               ->		EXCEPTION (JDBC method is not yet implemented.)
 	4 getShort             ->'0'    	: java.lang.Short
 	4 getString            ->		EXCEPTION (null)
 	4 getTime              ->		EXCEPTION (null)
@@ -3429,7 +3429,7 @@
 === Columntype long varchar for bit data
 select col_5 as col_5_1, col_5 as col_5_2, col_5 as col_5_3, col_5 as col_5_4, col_5 as col_5_5, col_5 as col_5_6, col_5 as col_5_7, col_5 as col_5_8, col_5 as col_5_9, col_5 as col_5_10, col_5 as col_5_11, col_5 as col_5_12, col_5 as col_5_13, col_5 as col_5_14, col_5 as col_5_15, col_5 as col_5_16, col_5 as col_5_17, col_5 as col_5_18, col_5 as col_5_19, col_5 as col_5_20, col_5 as col_5_21 from clob_table
 	5 getObject            ->		EXCEPTION (null)
-	5 getArray             ->		EXCEPTION (jdbc 2 method not yet implemented)
+	5 getArray             ->		EXCEPTION (JDBC method is not yet implemented.)
 	5 getAsciiStream       ->		EXCEPTION (null)
 	5 getBigDecimal        ->		EXCEPTION (null)
 	5 getBinaryStream      ->		EXCEPTION (null)
@@ -3444,7 +3444,7 @@
 	5 getFloat             ->'0.0'    	: java.lang.Float
 	5 getInt               ->'0'    	: java.lang.Integer
 	5 getLong              ->'0'    	: java.lang.Long
-	5 getRef               ->		EXCEPTION (jdbc 2 method not yet implemented)
+	5 getRef               ->		EXCEPTION (JDBC method is not yet implemented.)
 	5 getShort             ->'0'    	: java.lang.Short
 	5 getString            ->		EXCEPTION (null)
 	5 getTime              ->		EXCEPTION (null)
@@ -3452,7 +3452,7 @@
 === Columntype blob(80)
 select col_6 as col_6_1, col_6 as col_6_2, col_6 as col_6_3, col_6 as col_6_4, col_6 as col_6_5, col_6 as col_6_6, col_6 as col_6_7, col_6 as col_6_8, col_6 as col_6_9, col_6 as col_6_10, col_6 as col_6_11, col_6 as col_6_12, col_6 as col_6_13, col_6 as col_6_14, col_6 as col_6_15, col_6 as col_6_16, col_6 as col_6_17, col_6 as col_6_18, col_6 as col_6_19, col_6 as col_6_20, col_6 as col_6_21 from clob_table
 	6 getObject            ->		EXCEPTION (null)
-	6 getArray             ->		EXCEPTION (jdbc 2 method not yet implemented)
+	6 getArray             ->		EXCEPTION (JDBC method is not yet implemented.)
 	6 getAsciiStream       ->		EXCEPTION (null)
 	6 getBigDecimal        ->		EXCEPTION (null)
 	6 getBinaryStream      ->		EXCEPTION (null)
@@ -3467,7 +3467,7 @@
 	6 getFloat             ->'0.0'    	: java.lang.Float
 	6 getInt               ->'0'    	: java.lang.Integer
 	6 getLong              ->'0'    	: java.lang.Long
-	6 getRef               ->		EXCEPTION (jdbc 2 method not yet implemented)
+	6 getRef               ->		EXCEPTION (JDBC method is not yet implemented.)
 	6 getShort             ->'0'    	: java.lang.Short
 	6 getString            ->		EXCEPTION (null)
 	6 getTime              ->		EXCEPTION (null)
@@ -3475,7 +3475,7 @@
 === Columntype clob (64  )
 select typecol as typecol_1, typecol as typecol_2, typecol as typecol_3, typecol as typecol_4, typecol as typecol_5, typecol as typecol_6, typecol as typecol_7, typecol as typecol_8, typecol as typecol_9, typecol as typecol_10, typecol as typecol_11, typecol as typecol_12, typecol as typecol_13, typecol as typecol_14, typecol as typecol_15, typecol as typecol_16, typecol as typecol_17, typecol as typecol_18, typecol as typecol_19, typecol as typecol_20, typecol as typecol_21 from clob_table
 	7 getObject            ->		EXCEPTION (null)
-	7 getArray             ->		EXCEPTION (jdbc 2 method not yet implemented)
+	7 getArray             ->		EXCEPTION (JDBC method is not yet implemented.)
 	7 getAsciiStream       ->		EXCEPTION (null)
 	7 getBigDecimal        ->		EXCEPTION (null)
 	7 getBinaryStream      ->		EXCEPTION (null)
@@ -3490,7 +3490,7 @@
 	7 getFloat             ->'0.0'    	: java.lang.Float
 	7 getInt               ->'0'    	: java.lang.Integer
 	7 getLong              ->'0'    	: java.lang.Long
-	7 getRef               ->		EXCEPTION (jdbc 2 method not yet implemented)
+	7 getRef               ->		EXCEPTION (JDBC method is not yet implemented.)
 	7 getShort             ->'0'    	: java.lang.Short
 	7 getString            ->		EXCEPTION (null)
 	7 getTime              ->		EXCEPTION (null)

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/jdk14/updatableResultSet.out
URL: http://svn.apache.org/viewcvs/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/jdk14/updatableResultSet.out?rev=393967&r1=393966&r2=393967&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/jdk14/updatableResultSet.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/jdk14/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,74 +517,74 @@
 	{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
   Got expected exception : JDBC 3 method called - not yet supported
@@ -592,19 +592,19 @@
   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.
+  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
   Got expected exception : JDBC 3 method called - not yet supported
@@ -612,14 +612,14 @@
   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.
+  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
   Got expected exception : JDBC 3 method called - not yet supported
@@ -3022,19 +3022,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
 	 -- --
@@ -3095,8 +3095,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
@@ -3182,46 +3182,46 @@
 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
 Positive and negative tests 43 - Commit while on insertRow
 Positive test 43 - Commit while on insertRow with holdable cursor
 Negative test 43 - Commit while on insertRow with not holdable cursor
-SQL State: null
-Got expected exception: Invalid operation: result set closed
+SQL State: XJ012
+Got expected exception: 'ResultSet' already closed.
 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/DerbyNetClient/jdk16/parameterMapping.out
URL: http://svn.apache.org/viewcvs/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/jdk16/parameterMapping.out?rev=393967&r1=393966&r2=393967&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/jdk16/parameterMapping.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/jdk16/parameterMapping.out Thu Apr 13 15:59:22 2006
@@ -152,8 +152,8 @@
   setBlob(null) as batch getShort=0 was null true CLOUD EXT (OK)
   setUnicodeStream()  (22018):Invalid character string format for type SMALLINT. JDBC MATCH (INVALID)
   setUnicodeStream(null) getShort=0 was null true CLOUD EXT (OK)
-  setObject(null)  OK Invalid data conversion: Parameter object type is invalid for requested conversion.
-  setObject(null) as batch  OK Invalid data conversion: Parameter object type is invalid for requested conversion.
+  setObject(null)  OK Type is not supported.
+  setObject(null) as batch  OK Type is not supported.
   setObject(java.lang.String) getShort=46 was null false JDBC MATCH(OK)
   setObject(java.lang.String) as batch getShort=46 was null false JDBC MATCH(OK)
   setObject(java.math.BigDecimal) getShort=72 was null false JDBC MATCH(OK)
@@ -325,8 +325,8 @@
   setBlob(null) as batch getInt=0 was null true CLOUD EXT (OK)
   setUnicodeStream()  (22018):Invalid character string format for type INTEGER. JDBC MATCH (INVALID)
   setUnicodeStream(null) getInt=0 was null true CLOUD EXT (OK)
-  setObject(null)  OK Invalid data conversion: Parameter object type is invalid for requested conversion.
-  setObject(null) as batch  OK Invalid data conversion: Parameter object type is invalid for requested conversion.
+  setObject(null)  OK Type is not supported.
+  setObject(null) as batch  OK Type is not supported.
   setObject(java.lang.String) getInt=46 was null false JDBC MATCH(OK)
   setObject(java.lang.String) as batch getInt=46 was null false JDBC MATCH(OK)
   setObject(java.math.BigDecimal) getInt=72 was null false JDBC MATCH(OK)
@@ -498,8 +498,8 @@
   setBlob(null) as batch getLong=0 was null true CLOUD EXT (OK)
   setUnicodeStream()  (22018):Invalid character string format for type BIGINT. JDBC MATCH (INVALID)
   setUnicodeStream(null) getLong=0 was null true CLOUD EXT (OK)
-  setObject(null)  OK Invalid data conversion: Parameter object type is invalid for requested conversion.
-  setObject(null) as batch  OK Invalid data conversion: Parameter object type is invalid for requested conversion.
+  setObject(null)  OK Type is not supported.
+  setObject(null) as batch  OK Type is not supported.
   setObject(java.lang.String) getLong=46 was null false JDBC MATCH(OK)
   setObject(java.lang.String) as batch getLong=46 was null false JDBC MATCH(OK)
   setObject(java.math.BigDecimal) getLong=72 was null false JDBC MATCH(OK)
@@ -671,8 +671,8 @@
   setBlob(null) as batch getFloat=0.0 was null true CLOUD EXT (OK)
   setUnicodeStream()  (22018):Invalid character string format for type REAL. JDBC MATCH (INVALID)
   setUnicodeStream(null) getFloat=0.0 was null true CLOUD EXT (OK)
-  setObject(null)  OK Invalid data conversion: Parameter object type is invalid for requested conversion.
-  setObject(null) as batch  OK Invalid data conversion: Parameter object type is invalid for requested conversion.
+  setObject(null)  OK Type is not supported.
+  setObject(null) as batch  OK Type is not supported.
   setObject(java.lang.String) getFloat=46.0 was null false JDBC MATCH(OK)
   setObject(java.lang.String) as batch getFloat=46.0 was null false JDBC MATCH(OK)
   setObject(java.math.BigDecimal) getFloat=72.0 was null false JDBC MATCH(OK)
@@ -845,8 +845,8 @@
   setBlob(null) as batch getDouble=0.0 was null true CLOUD EXT (OK)
   setUnicodeStream()  (22018):Invalid character string format for type DOUBLE. JDBC MATCH (INVALID)
   setUnicodeStream(null) getDouble=0.0 was null true CLOUD EXT (OK)
-  setObject(null)  OK Invalid data conversion: Parameter object type is invalid for requested conversion.
-  setObject(null) as batch  OK Invalid data conversion: Parameter object type is invalid for requested conversion.
+  setObject(null)  OK Type is not supported.
+  setObject(null) as batch  OK Type is not supported.
   setObject(java.lang.String) getDouble=46.0 was null false JDBC MATCH(OK)
   setObject(java.lang.String) as batch getDouble=46.0 was null false JDBC MATCH(OK)
   setObject(java.math.BigDecimal) getDouble=72.0 was null false JDBC MATCH(OK)
@@ -1018,8 +1018,8 @@
   setBlob(null) as batch getDouble=0.0 was null true CLOUD EXT (OK)
   setUnicodeStream()  (22018):Invalid character string format for type DOUBLE. JDBC MATCH (INVALID)
   setUnicodeStream(null) getDouble=0.0 was null true CLOUD EXT (OK)
-  setObject(null)  OK Invalid data conversion: Parameter object type is invalid for requested conversion.
-  setObject(null) as batch  OK Invalid data conversion: Parameter object type is invalid for requested conversion.
+  setObject(null)  OK Type is not supported.
+  setObject(null) as batch  OK Type is not supported.
   setObject(java.lang.String) getDouble=46.0 was null false JDBC MATCH(OK)
   setObject(java.lang.String) as batch getDouble=46.0 was null false JDBC MATCH(OK)
   setObject(java.math.BigDecimal) getDouble=72.0 was null false JDBC MATCH(OK)
@@ -1191,8 +1191,8 @@
   setBlob(null) as batch getBigDecimal=null was null true CLOUD EXT (OK)
   setUnicodeStream()  (22018):Invalid character string format for type DECIMAL. JDBC MATCH (INVALID)
   setUnicodeStream(null) getBigDecimal=null was null true CLOUD EXT (OK)
-  setObject(null)  OK Invalid data conversion: Parameter object type is invalid for requested conversion.
-  setObject(null) as batch  OK Invalid data conversion: Parameter object type is invalid for requested conversion.
+  setObject(null)  OK Type is not supported.
+  setObject(null) as batch  OK Type is not supported.
   setObject(java.lang.String) getBigDecimal=46.00000 was null false JDBC MATCH(OK)
   setObject(java.lang.String) as batch getBigDecimal=46.00000 was null false JDBC MATCH(OK)
   setObject(java.math.BigDecimal) getBigDecimal=72.00000 was null false JDBC MATCH(OK)
@@ -1369,8 +1369,8 @@
   setBlob(null) as batch getString=null was null true CLOUD EXT (OK)
   setUnicodeStream() getString=EncodedString: > 33347 51966 50 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 < was null false CLOUD EXT (OK)
   setUnicodeStream(null) getString=null was null true CLOUD EXT (OK)
-  setObject(null)  OK Invalid data conversion: Parameter object type is invalid for requested conversion.
-  setObject(null) as batch  OK Invalid data conversion: Parameter object type is invalid for requested conversion.
+  setObject(null)  OK Type is not supported.
+  setObject(null) as batch  OK Type is not supported.
   setObject(java.lang.String) getString=46                                                           was null false JDBC MATCH(OK)
   setObject(java.lang.String) as batch getString=46                                                           was null false JDBC MATCH(OK)
   setObject(java.math.BigDecimal) getString=72                                                           was null false JDBC MATCH(OK)
@@ -1541,8 +1541,8 @@
   setBlob(null) as batch getString=null was null true CLOUD EXT (OK)
   setUnicodeStream() getString=EncodedString: > 33347 51966 50 < was null false CLOUD EXT (OK)
   setUnicodeStream(null) getString=null was null true CLOUD EXT (OK)
-  setObject(null)  OK Invalid data conversion: Parameter object type is invalid for requested conversion.
-  setObject(null) as batch  OK Invalid data conversion: Parameter object type is invalid for requested conversion.
+  setObject(null)  OK Type is not supported.
+  setObject(null) as batch  OK Type is not supported.
   setObject(java.lang.String) getString=46 was null false JDBC MATCH(OK)
   setObject(java.lang.String) as batch getString=46 was null false JDBC MATCH(OK)
   setObject(java.math.BigDecimal) getString=72 was null false JDBC MATCH(OK)
@@ -1713,8 +1713,8 @@
   setBlob(null) as batch getString=null was null true CLOUD EXT (OK)
   setUnicodeStream() getString=EncodedString: > 33347 51966 50 < was null false CLOUD EXT (OK)
   setUnicodeStream(null) getString=null was null true CLOUD EXT (OK)
-  setObject(null)  OK Invalid data conversion: Parameter object type is invalid for requested conversion.
-  setObject(null) as batch  OK Invalid data conversion: Parameter object type is invalid for requested conversion.
+  setObject(null)  OK Type is not supported.
+  setObject(null) as batch  OK Type is not supported.
   setObject(java.lang.String) getString=46 was null false JDBC MATCH(OK)
   setObject(java.lang.String) as batch getString=46 was null false JDBC MATCH(OK)
   setObject(java.math.BigDecimal) getString=72 was null false JDBC MATCH(OK)
@@ -1888,8 +1888,8 @@
   setBlob(null) as batch getBytes=null was null true CLOUD EXT (OK)
   setUnicodeStream()  (XCL12):An attempt was made to put a data value of type 'java.lang.String' into a data value of type 'VARCHAR () FOR BIT DATA'. JDBC FAIL VARCHAR(60) FOR BIT DATA
   setUnicodeStream(null) getBytes=null was null true JDBC MATCH(OK)
-  setObject(null)  OK Invalid data conversion: Parameter object type is invalid for requested conversion.
-  setObject(null) as batch  OK Invalid data conversion: Parameter object type is invalid for requested conversion.
+  setObject(null)  OK Type is not supported.
+  setObject(null) as batch  OK Type is not supported.
   setObject(java.lang.String)  (XCL12):An attempt was made to put a data value of type 'java.lang.String' into a data value of type 'VARCHAR () FOR BIT DATA'. JDBC FAIL VARCHAR(60) FOR BIT DATA
   setObject(java.lang.String) as batch  (?????):Non-atomic batch failure.  The batch was submitted, but at least one exception occurred on an individual member of the batch. Use getNextException() to retrieve the exceptions for specific batched elements. (XCL12):Error for batch element #0: An attempt was made to put a data value of type 'java.lang.String' into a data value of type 'VARCHAR () FOR BIT DATA'. JDBC FAIL VARCHAR(60) FOR BIT DATA
   setObject(java.math.BigDecimal) IC JDBC MATCH (INVALID)
@@ -2063,8 +2063,8 @@
   setBlob(null) as batch getDate=null was null true CLOUD EXT (OK)
   setUnicodeStream()  (22007):The syntax of the string representation of a datetime value is incorrect. JDBC MATCH (INVALID)
   setUnicodeStream(null) getDate=null was null true CLOUD EXT (OK)
-  setObject(null)  OK Invalid data conversion: Parameter object type is invalid for requested conversion.
-  setObject(null) as batch  OK Invalid data conversion: Parameter object type is invalid for requested conversion.
+  setObject(null)  OK Type is not supported.
+  setObject(null) as batch  OK Type is not supported.
   setObject(java.lang.String)  (22007):The syntax of the string representation of a datetime value is incorrect. JDBC FAIL DATE
   setObject(java.lang.String) as batch  (?????):Non-atomic batch failure.  The batch was submitted, but at least one exception occurred on an individual member of the batch. Use getNextException() to retrieve the exceptions for specific batched elements. (22007):Error for batch element #0: The syntax of the string representation of a datetime value is incorrect. JDBC FAIL DATE
   setObject(java.math.BigDecimal) IC JDBC MATCH (INVALID)
@@ -2236,8 +2236,8 @@
   setBlob(null) as batch getTime=null was null true CLOUD EXT (OK)
   setUnicodeStream()  (22007):The syntax of the string representation of a datetime value is incorrect. JDBC MATCH (INVALID)
   setUnicodeStream(null) getTime=null was null true CLOUD EXT (OK)
-  setObject(null)  OK Invalid data conversion: Parameter object type is invalid for requested conversion.
-  setObject(null) as batch  OK Invalid data conversion: Parameter object type is invalid for requested conversion.
+  setObject(null)  OK Type is not supported.
+  setObject(null) as batch  OK Type is not supported.
   setObject(java.lang.String)  (22007):The syntax of the string representation of a datetime value is incorrect. JDBC FAIL TIME
   setObject(java.lang.String) as batch  (?????):Non-atomic batch failure.  The batch was submitted, but at least one exception occurred on an individual member of the batch. Use getNextException() to retrieve the exceptions for specific batched elements. (22007):Error for batch element #0: The syntax of the string representation of a datetime value is incorrect. JDBC FAIL TIME
   setObject(java.math.BigDecimal) IC JDBC MATCH (INVALID)
@@ -2409,8 +2409,8 @@
   setBlob(null) as batch getTimestamp=null was null true CLOUD EXT (OK)
   setUnicodeStream()  (22007):The syntax of the string representation of a datetime value is incorrect. JDBC MATCH (INVALID)
   setUnicodeStream(null) getTimestamp=null was null true CLOUD EXT (OK)
-  setObject(null)  OK Invalid data conversion: Parameter object type is invalid for requested conversion.
-  setObject(null) as batch  OK Invalid data conversion: Parameter object type is invalid for requested conversion.
+  setObject(null)  OK Type is not supported.
+  setObject(null) as batch  OK Type is not supported.
   setObject(java.lang.String)  (22007):The syntax of the string representation of a datetime value is incorrect. JDBC FAIL TIMESTAMP
   setObject(java.lang.String) as batch  (?????):Non-atomic batch failure.  The batch was submitted, but at least one exception occurred on an individual member of the batch. Use getNextException() to retrieve the exceptions for specific batched elements. (22007):Error for batch element #0: The syntax of the string representation of a datetime value is incorrect. JDBC FAIL TIMESTAMP
   setObject(java.math.BigDecimal) IC JDBC MATCH (INVALID)
@@ -2581,8 +2581,8 @@
   setBlob(null) as batch getClob=null was null true CLOUD EXT (OK)
   setUnicodeStream() getClob=0x8243,0xcafe was null false CLOUD EXT (OK)
   setUnicodeStream(null) getClob=null was null true CLOUD EXT (OK)
-  setObject(null)  OK Invalid data conversion: Parameter object type is invalid for requested conversion.
-  setObject(null) as batch  OK Invalid data conversion: Parameter object type is invalid for requested conversion.
+  setObject(null)  OK Type is not supported.
+  setObject(null) as batch  OK Type is not supported.
   setObject(java.lang.String) getClob=0x34,0x36 was null false CLOUD EXT (OK)
   setObject(java.lang.String) as batch getClob=0x34,0x36 was null false CLOUD EXT (OK)
   setObject(java.math.BigDecimal) IC JDBC MATCH (INVALID)
@@ -2754,8 +2754,8 @@
   setBlob(null) as batch getBlob=null was null true JDBC MATCH(OK)
   setUnicodeStream()  (XCL12):An attempt was made to put a data value of type 'java.lang.String' into a data value of type 'BLOB'. JDBC FAIL BLOB(1k)
   setUnicodeStream(null) getBlob=null was null true JDBC MATCH(OK)
-  setObject(null)  OK Invalid data conversion: Parameter object type is invalid for requested conversion.
-  setObject(null) as batch  OK Invalid data conversion: Parameter object type is invalid for requested conversion.
+  setObject(null)  OK Type is not supported.
+  setObject(null) as batch  OK Type is not supported.
   setObject(java.lang.String) IC JDBC MATCH (INVALID)
   setObject(java.lang.String) as batch IC JDBC MATCH (INVALID)
   setObject(java.math.BigDecimal) IC JDBC MATCH (INVALID)