db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From kmars...@apache.org
Subject svn commit: r157136 - in incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests: master/DerbyNetClient/LOBTest.out master/DerbyNetClient/parameterMapping.out master/DerbyNetClient/procedure.out tests/derbynet/csPrepStmt.java tests/lang/procedure.java
Date Fri, 11 Mar 2005 19:45:04 GMT
Author: kmarsden
Date: Fri Mar 11 11:45:01 2005
New Revision: 157136

URL: http://svn.apache.org/viewcvs?view=rev&rev=157136
Log:
 Update masters for client


Modified:
    incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/LOBTest.out
    incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/parameterMapping.out
    incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/procedure.out
    incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/derbynet/csPrepStmt.java
    incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/procedure.java

Modified: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/LOBTest.out
URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/LOBTest.out?view=diff&r1=157135&r2=157136
==============================================================================
--- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/LOBTest.out (original)
+++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/LOBTest.out Fri Mar 11 11:45:01 2005
@@ -68,7 +68,7 @@
 	2 getBytes             ->		EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
 	2 getCharacterStream   ->Object'   	: java.io.Reader
 	2 getClob              ->		EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
-	2 getDate              ->		EXCEPTION (String index out of range: 3)
+	2 getDate              ->		EXCEPTION (Invalid data conversion: Parameter instance 102 is invalid for requested conversion to java.sql.Date.)
 	2 getDouble            ->'102.0'    	: java.lang.Double
 	2 getFloat             ->'102.0'    	: java.lang.Float
 	2 getInt               ->'102'    	: java.lang.Integer
@@ -77,7 +77,7 @@
 	2 getShort             ->'102'    	: java.lang.Short
 	2 getString            ->'102'    	: java.lang.String
 	2 getTime              ->		EXCEPTION (Invalid data conversion: Parameter instance 102 is invalid for requested conversion to java.sql.Time.)
-	2 getTimeStamp         ->		EXCEPTION (String index out of range: 3)
+	2 getTimeStamp         ->		EXCEPTION (Invalid data conversion: Parameter instance 102 is invalid for requested conversion to java.sql.Timestamp.)
 === Columntype long varchar
 select col_3 from bit_table
 	3 getObject            ->'103'    	: java.lang.String
@@ -91,7 +91,7 @@
 	3 getBytes             ->		EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
 	3 getCharacterStream   ->Object'   	: java.io.Reader
 	3 getClob              ->		EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
-	3 getDate              ->		EXCEPTION (String index out of range: 3)
+	3 getDate              ->		EXCEPTION (Invalid data conversion: Parameter instance 103 is invalid for requested conversion to java.sql.Date.)
 	3 getDouble            ->'103.0'    	: java.lang.Double
 	3 getFloat             ->'103.0'    	: java.lang.Float
 	3 getInt               ->'103'    	: java.lang.Integer
@@ -100,7 +100,7 @@
 	3 getShort             ->'103'    	: java.lang.Short
 	3 getString            ->'103'    	: java.lang.String
 	3 getTime              ->		EXCEPTION (Invalid data conversion: Parameter instance 103 is invalid for requested conversion to java.sql.Time.)
-	3 getTimeStamp         ->		EXCEPTION (String index out of range: 3)
+	3 getTimeStamp         ->		EXCEPTION (Invalid data conversion: Parameter instance 103 is invalid for requested conversion to java.sql.Timestamp.)
 === Columntype char(10) for bit data
 select col_4 from bit_table
 	4 getObject            ->Object'   	: byte[]
@@ -630,7 +630,7 @@
 	2 getBytes             ->		EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
 	2 getCharacterStream   ->Object'   	: java.io.Reader
 	2 getClob              ->		EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
-	2 getDate              ->		EXCEPTION (String index out of range: 3)
+	2 getDate              ->		EXCEPTION (Invalid data conversion: Parameter instance 102 is invalid for requested conversion to java.sql.Date.)
 	2 getDouble            ->'102.0'    	: java.lang.Double
 	2 getFloat             ->'102.0'    	: java.lang.Float
 	2 getInt               ->'102'    	: java.lang.Integer
@@ -639,7 +639,7 @@
 	2 getShort             ->'102'    	: java.lang.Short
 	2 getString            ->'102'    	: java.lang.String
 	2 getTime              ->		EXCEPTION (Invalid data conversion: Parameter instance 102 is invalid for requested conversion to java.sql.Time.)
-	2 getTimeStamp         ->		EXCEPTION (String index out of range: 3)
+	2 getTimeStamp         ->		EXCEPTION (Invalid data conversion: Parameter instance 102 is invalid for requested conversion to java.sql.Timestamp.)
 === Columntype long varchar
 select col_3 from bit_table
 	3 getObject            ->'103'    	: java.lang.String
@@ -653,7 +653,7 @@
 	3 getBytes             ->		EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
 	3 getCharacterStream   ->Object'   	: java.io.Reader
 	3 getClob              ->		EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
-	3 getDate              ->		EXCEPTION (String index out of range: 3)
+	3 getDate              ->		EXCEPTION (Invalid data conversion: Parameter instance 103 is invalid for requested conversion to java.sql.Date.)
 	3 getDouble            ->'103.0'    	: java.lang.Double
 	3 getFloat             ->'103.0'    	: java.lang.Float
 	3 getInt               ->'103'    	: java.lang.Integer
@@ -662,7 +662,7 @@
 	3 getShort             ->'103'    	: java.lang.Short
 	3 getString            ->'103'    	: java.lang.String
 	3 getTime              ->		EXCEPTION (Invalid data conversion: Parameter instance 103 is invalid for requested conversion to java.sql.Time.)
-	3 getTimeStamp         ->		EXCEPTION (String index out of range: 3)
+	3 getTimeStamp         ->		EXCEPTION (Invalid data conversion: Parameter instance 103 is invalid for requested conversion to java.sql.Timestamp.)
 === Columntype char(10) for bit data
 select col_4 from bit_table
 	4 getObject            ->Object'   	: byte[]
@@ -1192,7 +1192,7 @@
 	2 getBytes             ->		EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
 	2 getCharacterStream   ->Object'   	: java.io.Reader
 	2 getClob              ->		EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
-	2 getDate              ->		EXCEPTION (String index out of range: 3)
+	2 getDate              ->		EXCEPTION (Invalid data conversion: Parameter instance 102 is invalid for requested conversion to java.sql.Date.)
 	2 getDouble            ->'102.0'    	: java.lang.Double
 	2 getFloat             ->'102.0'    	: java.lang.Float
 	2 getInt               ->'102'    	: java.lang.Integer
@@ -1201,7 +1201,7 @@
 	2 getShort             ->'102'    	: java.lang.Short
 	2 getString            ->'102'    	: java.lang.String
 	2 getTime              ->		EXCEPTION (Invalid data conversion: Parameter instance 102 is invalid for requested conversion to java.sql.Time.)
-	2 getTimeStamp         ->		EXCEPTION (String index out of range: 3)
+	2 getTimeStamp         ->		EXCEPTION (Invalid data conversion: Parameter instance 102 is invalid for requested conversion to java.sql.Timestamp.)
 === Columntype long varchar
 select col_3 from blob_table
 	3 getObject            ->'103'    	: java.lang.String
@@ -1215,7 +1215,7 @@
 	3 getBytes             ->		EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
 	3 getCharacterStream   ->Object'   	: java.io.Reader
 	3 getClob              ->		EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
-	3 getDate              ->		EXCEPTION (String index out of range: 3)
+	3 getDate              ->		EXCEPTION (Invalid data conversion: Parameter instance 103 is invalid for requested conversion to java.sql.Date.)
 	3 getDouble            ->'103.0'    	: java.lang.Double
 	3 getFloat             ->'103.0'    	: java.lang.Float
 	3 getInt               ->'103'    	: java.lang.Integer
@@ -1224,7 +1224,7 @@
 	3 getShort             ->'103'    	: java.lang.Short
 	3 getString            ->'103'    	: java.lang.String
 	3 getTime              ->		EXCEPTION (Invalid data conversion: Parameter instance 103 is invalid for requested conversion to java.sql.Time.)
-	3 getTimeStamp         ->		EXCEPTION (String index out of range: 3)
+	3 getTimeStamp         ->		EXCEPTION (Invalid data conversion: Parameter instance 103 is invalid for requested conversion to java.sql.Timestamp.)
 === Columntype char(10) for bit data
 select col_4 from blob_table
 	4 getObject            ->Object'   	: byte[]
@@ -1733,7 +1733,7 @@
 	2 getBytes             ->		EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
 	2 getCharacterStream   ->Object'   	: java.io.Reader
 	2 getClob              ->		EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
-	2 getDate              ->		EXCEPTION (String index out of range: 3)
+	2 getDate              ->		EXCEPTION (Invalid data conversion: Parameter instance 102 is invalid for requested conversion to java.sql.Date.)
 	2 getDouble            ->'102.0'    	: java.lang.Double
 	2 getFloat             ->'102.0'    	: java.lang.Float
 	2 getInt               ->'102'    	: java.lang.Integer
@@ -1742,7 +1742,7 @@
 	2 getShort             ->'102'    	: java.lang.Short
 	2 getString            ->'102'    	: java.lang.String
 	2 getTime              ->		EXCEPTION (Invalid data conversion: Parameter instance 102 is invalid for requested conversion to java.sql.Time.)
-	2 getTimeStamp         ->		EXCEPTION (String index out of range: 3)
+	2 getTimeStamp         ->		EXCEPTION (Invalid data conversion: Parameter instance 102 is invalid for requested conversion to java.sql.Timestamp.)
 === Columntype long varchar
 select col_3 from blob_table
 	3 getObject            ->'103'    	: java.lang.String
@@ -1756,7 +1756,7 @@
 	3 getBytes             ->		EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
 	3 getCharacterStream   ->Object'   	: java.io.Reader
 	3 getClob              ->		EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
-	3 getDate              ->		EXCEPTION (String index out of range: 3)
+	3 getDate              ->		EXCEPTION (Invalid data conversion: Parameter instance 103 is invalid for requested conversion to java.sql.Date.)
 	3 getDouble            ->'103.0'    	: java.lang.Double
 	3 getFloat             ->'103.0'    	: java.lang.Float
 	3 getInt               ->'103'    	: java.lang.Integer
@@ -1765,7 +1765,7 @@
 	3 getShort             ->'103'    	: java.lang.Short
 	3 getString            ->'103'    	: java.lang.String
 	3 getTime              ->		EXCEPTION (Invalid data conversion: Parameter instance 103 is invalid for requested conversion to java.sql.Time.)
-	3 getTimeStamp         ->		EXCEPTION (String index out of range: 3)
+	3 getTimeStamp         ->		EXCEPTION (Invalid data conversion: Parameter instance 103 is invalid for requested conversion to java.sql.Timestamp.)
 === Columntype char(10) for bit data
 select col_4 from blob_table
 	4 getObject            ->Object'   	: byte[]
@@ -2274,7 +2274,7 @@
 	2 getBytes             ->		EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
 	2 getCharacterStream   ->Object'   	: java.io.Reader
 	2 getClob              ->		EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
-	2 getDate              ->		EXCEPTION (String index out of range: 3)
+	2 getDate              ->		EXCEPTION (Invalid data conversion: Parameter instance 102 is invalid for requested conversion to java.sql.Date.)
 	2 getDouble            ->'102.0'    	: java.lang.Double
 	2 getFloat             ->'102.0'    	: java.lang.Float
 	2 getInt               ->'102'    	: java.lang.Integer
@@ -2283,7 +2283,7 @@
 	2 getShort             ->'102'    	: java.lang.Short
 	2 getString            ->'102'    	: java.lang.String
 	2 getTime              ->		EXCEPTION (Invalid data conversion: Parameter instance 102 is invalid for requested conversion to java.sql.Time.)
-	2 getTimeStamp         ->		EXCEPTION (String index out of range: 3)
+	2 getTimeStamp         ->		EXCEPTION (Invalid data conversion: Parameter instance 102 is invalid for requested conversion to java.sql.Timestamp.)
 === Columntype long varchar
 select col_3 from blob_table
 	3 getObject            ->'103'    	: java.lang.String
@@ -2297,7 +2297,7 @@
 	3 getBytes             ->		EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
 	3 getCharacterStream   ->Object'   	: java.io.Reader
 	3 getClob              ->		EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
-	3 getDate              ->		EXCEPTION (String index out of range: 3)
+	3 getDate              ->		EXCEPTION (Invalid data conversion: Parameter instance 103 is invalid for requested conversion to java.sql.Date.)
 	3 getDouble            ->'103.0'    	: java.lang.Double
 	3 getFloat             ->'103.0'    	: java.lang.Float
 	3 getInt               ->'103'    	: java.lang.Integer
@@ -2306,7 +2306,7 @@
 	3 getShort             ->'103'    	: java.lang.Short
 	3 getString            ->'103'    	: java.lang.String
 	3 getTime              ->		EXCEPTION (Invalid data conversion: Parameter instance 103 is invalid for requested conversion to java.sql.Time.)
-	3 getTimeStamp         ->		EXCEPTION (String index out of range: 3)
+	3 getTimeStamp         ->		EXCEPTION (Invalid data conversion: Parameter instance 103 is invalid for requested conversion to java.sql.Timestamp.)
 === Columntype char(10) for bit data
 select col_4 from blob_table
 	4 getObject            ->Object'   	: byte[]

Modified: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/parameterMapping.out
URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/parameterMapping.out?view=diff&r1=157135&r2=157136
==============================================================================
--- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/parameterMapping.out (original)
+++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/parameterMapping.out Fri Mar 11 11:45:01 2005
@@ -67,7 +67,7 @@
   setNull(CLOB) getShort=0 was null true
   setNull(BLOB) getShort=0 was null true
   setNull(Types.NULL) getShort=0 was null true
-  setNull(235350345) getShort=0 was null true
+  setNull(235350345) SQLSTATE(null): org.apache.derby.client.am.SqlException: unrecognized sql type
 setXXX() with all JDBC Types on SMALLINT
 For setXXX() methods that pass an object, a null and valid values are checked
   setByte() getShort=98 was null false JDBC MATCH(OK)
@@ -89,17 +89,17 @@
   setTime(null) getShort=0 was null true CLOUD EXT (OK)
   setTimestamp() IC JDBC MATCH (INVALID)
   setTimestamp(null) getShort=0 was null true CLOUD EXT (OK)
-  setAsciiStream() IC JDBC MATCH (INVALID)
+  setAsciiStream()  (22018):Invalid character string format for type SMALLINT. JDBC MATCH (INVALID)
   setAsciiStream(null) getShort=0 was null true CLOUD EXT (OK)
   setBinaryStream() IC JDBC MATCH (INVALID)
   setBinaryStream(null) getShort=0 was null true CLOUD EXT (OK)
-  setCharacterStream() IC JDBC MATCH (INVALID)
+  setCharacterStream() getShort=89 was null false CLOUD EXT (OK)
   setCharacterStream(null) getShort=0 was null true CLOUD EXT (OK)
-  setClob() IC JDBC MATCH (INVALID)
+  setClob() getShort=72 was null false CLOUD EXT (OK)
   setClob(null) getShort=0 was null true CLOUD EXT (OK)
   setBlob() IC JDBC MATCH (INVALID)
   setBlob(null) getShort=0 was null true CLOUD EXT (OK)
-  setUnicodeStream() IC JDBC MATCH (INVALID)
+  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(java.lang.String) getShort=46 was null false JDBC MATCH(OK)
@@ -177,7 +177,7 @@
   setNull(CLOB) getInt=0 was null true
   setNull(BLOB) getInt=0 was null true
   setNull(Types.NULL) getInt=0 was null true
-  setNull(235350345) getInt=0 was null true
+  setNull(235350345) SQLSTATE(null): org.apache.derby.client.am.SqlException: unrecognized sql type
 setXXX() with all JDBC Types on INTEGER
 For setXXX() methods that pass an object, a null and valid values are checked
   setByte() getInt=98 was null false JDBC MATCH(OK)
@@ -199,17 +199,17 @@
   setTime(null) getInt=0 was null true CLOUD EXT (OK)
   setTimestamp() IC JDBC MATCH (INVALID)
   setTimestamp(null) getInt=0 was null true CLOUD EXT (OK)
-  setAsciiStream() IC JDBC MATCH (INVALID)
+  setAsciiStream()  (22018):Invalid character string format for type INTEGER. JDBC MATCH (INVALID)
   setAsciiStream(null) getInt=0 was null true CLOUD EXT (OK)
   setBinaryStream() IC JDBC MATCH (INVALID)
   setBinaryStream(null) getInt=0 was null true CLOUD EXT (OK)
-  setCharacterStream() IC JDBC MATCH (INVALID)
+  setCharacterStream() getInt=89 was null false CLOUD EXT (OK)
   setCharacterStream(null) getInt=0 was null true CLOUD EXT (OK)
-  setClob() IC JDBC MATCH (INVALID)
+  setClob() getInt=72 was null false CLOUD EXT (OK)
   setClob(null) getInt=0 was null true CLOUD EXT (OK)
   setBlob() IC JDBC MATCH (INVALID)
   setBlob(null) getInt=0 was null true CLOUD EXT (OK)
-  setUnicodeStream() IC JDBC MATCH (INVALID)
+  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(java.lang.String) getInt=46 was null false JDBC MATCH(OK)
@@ -287,7 +287,7 @@
   setNull(CLOB) getLong=0 was null true
   setNull(BLOB) getLong=0 was null true
   setNull(Types.NULL) getLong=0 was null true
-  setNull(235350345) getLong=0 was null true
+  setNull(235350345) SQLSTATE(null): org.apache.derby.client.am.SqlException: unrecognized sql type
 setXXX() with all JDBC Types on BIGINT
 For setXXX() methods that pass an object, a null and valid values are checked
   setByte() getLong=98 was null false JDBC MATCH(OK)
@@ -309,17 +309,17 @@
   setTime(null) getLong=0 was null true CLOUD EXT (OK)
   setTimestamp() IC JDBC MATCH (INVALID)
   setTimestamp(null) getLong=0 was null true CLOUD EXT (OK)
-  setAsciiStream() IC JDBC MATCH (INVALID)
+  setAsciiStream()  (22018):Invalid character string format for type BIGINT. JDBC MATCH (INVALID)
   setAsciiStream(null) getLong=0 was null true CLOUD EXT (OK)
   setBinaryStream() IC JDBC MATCH (INVALID)
   setBinaryStream(null) getLong=0 was null true CLOUD EXT (OK)
-  setCharacterStream() IC JDBC MATCH (INVALID)
+  setCharacterStream() getLong=89 was null false CLOUD EXT (OK)
   setCharacterStream(null) getLong=0 was null true CLOUD EXT (OK)
-  setClob() IC JDBC MATCH (INVALID)
+  setClob() getLong=72 was null false CLOUD EXT (OK)
   setClob(null) getLong=0 was null true CLOUD EXT (OK)
   setBlob() IC JDBC MATCH (INVALID)
   setBlob(null) getLong=0 was null true CLOUD EXT (OK)
-  setUnicodeStream() IC JDBC MATCH (INVALID)
+  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(java.lang.String) getLong=46 was null false JDBC MATCH(OK)
@@ -397,7 +397,7 @@
   setNull(CLOB) getFloat=0.0 was null true
   setNull(BLOB) getFloat=0.0 was null true
   setNull(Types.NULL) getFloat=0.0 was null true
-  setNull(235350345) getFloat=0.0 was null true
+  setNull(235350345) SQLSTATE(null): org.apache.derby.client.am.SqlException: unrecognized sql type
 setXXX() with all JDBC Types on REAL
 For setXXX() methods that pass an object, a null and valid values are checked
   setByte() getFloat=98.0 was null false JDBC MATCH(OK)
@@ -419,17 +419,17 @@
   setTime(null) getFloat=0.0 was null true CLOUD EXT (OK)
   setTimestamp() IC JDBC MATCH (INVALID)
   setTimestamp(null) getFloat=0.0 was null true CLOUD EXT (OK)
-  setAsciiStream() IC JDBC MATCH (INVALID)
+  setAsciiStream()  (22018):Invalid character string format for type REAL. JDBC MATCH (INVALID)
   setAsciiStream(null) getFloat=0.0 was null true CLOUD EXT (OK)
   setBinaryStream() IC JDBC MATCH (INVALID)
   setBinaryStream(null) getFloat=0.0 was null true CLOUD EXT (OK)
-  setCharacterStream() IC JDBC MATCH (INVALID)
+  setCharacterStream() getFloat=89.0 was null false CLOUD EXT (OK)
   setCharacterStream(null) getFloat=0.0 was null true CLOUD EXT (OK)
-  setClob() IC JDBC MATCH (INVALID)
+  setClob() getFloat=72.0 was null false CLOUD EXT (OK)
   setClob(null) getFloat=0.0 was null true CLOUD EXT (OK)
   setBlob() IC JDBC MATCH (INVALID)
   setBlob(null) getFloat=0.0 was null true CLOUD EXT (OK)
-  setUnicodeStream() IC JDBC MATCH (INVALID)
+  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(java.lang.String) getFloat=46.0 was null false JDBC MATCH(OK)
@@ -508,14 +508,14 @@
   setNull(CLOB) getDouble=0.0 was null true
   setNull(BLOB) getDouble=0.0 was null true
   setNull(Types.NULL) getDouble=0.0 was null true
-  setNull(235350345) getDouble=0.0 was null true
+  setNull(235350345) SQLSTATE(null): org.apache.derby.client.am.SqlException: unrecognized sql type
 setXXX() with all JDBC Types on FLOAT
 For setXXX() methods that pass an object, a null and valid values are checked
   setByte() getDouble=98.0 was null false JDBC MATCH(OK)
   setShort() getDouble=98.0 was null false JDBC MATCH(OK)
   setInt() getDouble=98.0 was null false JDBC MATCH(OK)
   setLong() getDouble=98.0 was null false JDBC MATCH(OK)
-  setFloat() getDouble=98.4 was null false JDBC MATCH(OK)
+  setFloat() getDouble=98.4000015258789 was null false JDBC MATCH(OK)
   setDouble() getDouble=98.5 was null false JDBC MATCH(OK)
   setBigDecimal() getDouble=99.0 was null false JDBC MATCH(OK)
   setBigDecimal(null) getDouble=0.0 was null true JDBC MATCH(OK)
@@ -530,17 +530,17 @@
   setTime(null) getDouble=0.0 was null true CLOUD EXT (OK)
   setTimestamp() IC JDBC MATCH (INVALID)
   setTimestamp(null) getDouble=0.0 was null true CLOUD EXT (OK)
-  setAsciiStream() IC JDBC MATCH (INVALID)
+  setAsciiStream()  (22018):Invalid character string format for type DOUBLE. JDBC MATCH (INVALID)
   setAsciiStream(null) getDouble=0.0 was null true CLOUD EXT (OK)
   setBinaryStream() IC JDBC MATCH (INVALID)
   setBinaryStream(null) getDouble=0.0 was null true CLOUD EXT (OK)
-  setCharacterStream() IC JDBC MATCH (INVALID)
+  setCharacterStream() getDouble=89.0 was null false CLOUD EXT (OK)
   setCharacterStream(null) getDouble=0.0 was null true CLOUD EXT (OK)
-  setClob() IC JDBC MATCH (INVALID)
+  setClob() getDouble=72.0 was null false CLOUD EXT (OK)
   setClob(null) getDouble=0.0 was null true CLOUD EXT (OK)
   setBlob() IC JDBC MATCH (INVALID)
   setBlob(null) getDouble=0.0 was null true CLOUD EXT (OK)
-  setUnicodeStream() IC JDBC MATCH (INVALID)
+  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(java.lang.String) getDouble=46.0 was null false JDBC MATCH(OK)
@@ -548,7 +548,7 @@
   setObject(java.lang.Boolean) getDouble=1.0 was null false JDBC MATCH(OK)
   setObject(java.lang.Integer) getDouble=74.0 was null false JDBC MATCH(OK)
   setObject(java.lang.Long) getDouble=79.0 was null false JDBC MATCH(OK)
-  setObject(java.lang.Float) getDouble=76.3 was null false JDBC MATCH(OK)
+  setObject(java.lang.Float) getDouble=76.30000305175781 was null false JDBC MATCH(OK)
   setObject(java.lang.Double) getDouble=12.33 was null false JDBC MATCH(OK)
   setObject(byte[]) IC JDBC MATCH (INVALID)
   setObject(java.sql.Date) IC JDBC MATCH (INVALID)
@@ -618,14 +618,14 @@
   setNull(CLOB) getDouble=0.0 was null true
   setNull(BLOB) getDouble=0.0 was null true
   setNull(Types.NULL) getDouble=0.0 was null true
-  setNull(235350345) getDouble=0.0 was null true
+  setNull(235350345) SQLSTATE(null): org.apache.derby.client.am.SqlException: unrecognized sql type
 setXXX() with all JDBC Types on DOUBLE
 For setXXX() methods that pass an object, a null and valid values are checked
   setByte() getDouble=98.0 was null false JDBC MATCH(OK)
   setShort() getDouble=98.0 was null false JDBC MATCH(OK)
   setInt() getDouble=98.0 was null false JDBC MATCH(OK)
   setLong() getDouble=98.0 was null false JDBC MATCH(OK)
-  setFloat() getDouble=98.4 was null false JDBC MATCH(OK)
+  setFloat() getDouble=98.4000015258789 was null false JDBC MATCH(OK)
   setDouble() getDouble=98.5 was null false JDBC MATCH(OK)
   setBigDecimal() getDouble=99.0 was null false JDBC MATCH(OK)
   setBigDecimal(null) getDouble=0.0 was null true JDBC MATCH(OK)
@@ -640,17 +640,17 @@
   setTime(null) getDouble=0.0 was null true CLOUD EXT (OK)
   setTimestamp() IC JDBC MATCH (INVALID)
   setTimestamp(null) getDouble=0.0 was null true CLOUD EXT (OK)
-  setAsciiStream() IC JDBC MATCH (INVALID)
+  setAsciiStream()  (22018):Invalid character string format for type DOUBLE. JDBC MATCH (INVALID)
   setAsciiStream(null) getDouble=0.0 was null true CLOUD EXT (OK)
   setBinaryStream() IC JDBC MATCH (INVALID)
   setBinaryStream(null) getDouble=0.0 was null true CLOUD EXT (OK)
-  setCharacterStream() IC JDBC MATCH (INVALID)
+  setCharacterStream() getDouble=89.0 was null false CLOUD EXT (OK)
   setCharacterStream(null) getDouble=0.0 was null true CLOUD EXT (OK)
-  setClob() IC JDBC MATCH (INVALID)
+  setClob() getDouble=72.0 was null false CLOUD EXT (OK)
   setClob(null) getDouble=0.0 was null true CLOUD EXT (OK)
   setBlob() IC JDBC MATCH (INVALID)
   setBlob(null) getDouble=0.0 was null true CLOUD EXT (OK)
-  setUnicodeStream() IC JDBC MATCH (INVALID)
+  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(java.lang.String) getDouble=46.0 was null false JDBC MATCH(OK)
@@ -658,7 +658,7 @@
   setObject(java.lang.Boolean) getDouble=1.0 was null false JDBC MATCH(OK)
   setObject(java.lang.Integer) getDouble=74.0 was null false JDBC MATCH(OK)
   setObject(java.lang.Long) getDouble=79.0 was null false JDBC MATCH(OK)
-  setObject(java.lang.Float) getDouble=76.3 was null false JDBC MATCH(OK)
+  setObject(java.lang.Float) getDouble=76.30000305175781 was null false JDBC MATCH(OK)
   setObject(java.lang.Double) getDouble=12.33 was null false JDBC MATCH(OK)
   setObject(byte[]) IC JDBC MATCH (INVALID)
   setObject(java.sql.Date) IC JDBC MATCH (INVALID)
@@ -728,7 +728,7 @@
   setNull(CLOB) getBigDecimal=null was null true
   setNull(BLOB) getBigDecimal=null was null true
   setNull(Types.NULL) getBigDecimal=null was null true
-  setNull(235350345) getBigDecimal=null was null true
+  setNull(235350345) SQLSTATE(null): org.apache.derby.client.am.SqlException: unrecognized sql type
 setXXX() with all JDBC Types on DECIMAL(10,5)
 For setXXX() methods that pass an object, a null and valid values are checked
   setByte() getBigDecimal=98.00000 was null false JDBC MATCH(OK)
@@ -750,17 +750,17 @@
   setTime(null) getBigDecimal=null was null true CLOUD EXT (OK)
   setTimestamp() IC JDBC MATCH (INVALID)
   setTimestamp(null) getBigDecimal=null was null true CLOUD EXT (OK)
-  setAsciiStream() IC JDBC MATCH (INVALID)
+  setAsciiStream()  (22018):Invalid character string format for type DECIMAL. JDBC MATCH (INVALID)
   setAsciiStream(null) getBigDecimal=null was null true CLOUD EXT (OK)
   setBinaryStream() IC JDBC MATCH (INVALID)
   setBinaryStream(null) getBigDecimal=null was null true CLOUD EXT (OK)
-  setCharacterStream() IC JDBC MATCH (INVALID)
+  setCharacterStream() getBigDecimal=89.00000 was null false CLOUD EXT (OK)
   setCharacterStream(null) getBigDecimal=null was null true CLOUD EXT (OK)
-  setClob() IC JDBC MATCH (INVALID)
+  setClob() getBigDecimal=72.00000 was null false CLOUD EXT (OK)
   setClob(null) getBigDecimal=null was null true CLOUD EXT (OK)
   setBlob() IC JDBC MATCH (INVALID)
   setBlob(null) getBigDecimal=null was null true CLOUD EXT (OK)
-  setUnicodeStream() IC JDBC MATCH (INVALID)
+  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(java.lang.String) getBigDecimal=46.00000 was null false JDBC MATCH(OK)
@@ -844,7 +844,7 @@
   setNull(CLOB) getString=null was null true
   setNull(BLOB) getString=null was null true
   setNull(Types.NULL) getString=null was null true
-  setNull(235350345) getString=null was null true
+  setNull(235350345) SQLSTATE(null): org.apache.derby.client.am.SqlException: unrecognized sql type
 setXXX() with all JDBC Types on CHAR(60)
 For setXXX() methods that pass an object, a null and valid values are checked
   setByte() getString=98                                                           was null false JDBC MATCH(OK)
@@ -858,7 +858,7 @@
   setBoolean() getString=1                                                            was null false JDBC MATCH(OK)
   setString() getString=97                                                           was null false JDBC MATCH(OK)
   setString(null) getString=null was null true JDBC MATCH(OK)
-  setBytes() IC JDBC MATCH (INVALID)
+  setBytes() getString=EncodedString: > 1027 64963 29440 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)
   setBytes(null) getString=null was null true CLOUD EXT (OK)
   setDate() getString=2004-02-14                                                   was null false JDBC MATCH(OK)
   setDate(null) getString=null was null true JDBC MATCH(OK)
@@ -868,13 +868,13 @@
   setTimestamp(null) getString=null was null true JDBC MATCH(OK)
   setAsciiStream() getString=eg012d                                                       was null false JDBC MATCH(OK)
   setAsciiStream(null) getString=null was null true JDBC MATCH(OK)
-  setBinaryStream() IC JDBC MATCH (INVALID)
+  setBinaryStream() 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)
   setBinaryStream(null) getString=null was null true CLOUD EXT (OK)
   setCharacterStream() getString=89                                                           was null false JDBC MATCH(OK)
   setCharacterStream(null) getString=null was null true JDBC MATCH(OK)
-  setClob() getString=<OBJECT.toString()> was null false CLOUD EXT (OK)
+  setClob() getString=72                                                           was null false CLOUD EXT (OK)
   setClob(null) getString=null was null true CLOUD EXT (OK)
-  setBlob() IC JDBC MATCH (INVALID)
+  setBlob() getString=EncodedString: > 12867 29251 55 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)
   setBlob(null) 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)
@@ -886,7 +886,7 @@
   setObject(java.lang.Long) getString=79                                                           was null false JDBC MATCH(OK)
   setObject(java.lang.Float) getString=76.3                                                         was null false JDBC MATCH(OK)
   setObject(java.lang.Double) getString=12.33                                                        was null false JDBC MATCH(OK)
-  setObject(byte[]) IC JDBC MATCH (INVALID)
+  setObject(byte[]) getString=EncodedString: > 12857 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 32 32 < was null false CLOUD EXT (OK)
   setObject(java.sql.Date) getString=2004-02-14                                                   was null false JDBC MATCH(OK)
   setObject(java.sql.Time) getString=13:26:42                                                     was null false JDBC MATCH(OK)
   setObject(java.sql.Timestamp) getString=xxxxxxFILTERED-TIMESTAMPxxxxxwas null false JDBC MATCH(OK)
@@ -923,9 +923,9 @@
   getBoolean=true was null false JDBC MATCH(OK)
   getString=32 was null false JDBC MATCH(OK)
   getBytes=IC JDBC MATCH (INVALID)
-  getDate=java.lang.StringIndexOutOfBoundsException: String index out of range: 2 JDBC FAIL VARCHAR(60)
-  getTime=java.lang.StringIndexOutOfBoundsException: String index out of range: 2 JDBC FAIL VARCHAR(60)
-  getTimestamp=java.lang.StringIndexOutOfBoundsException: String index out of range: 2 JDBC FAIL VARCHAR(60)
+  getDate= (?????):Invalid data conversion: Parameter instance 32 is invalid for requested conversion to java.sql.Date. JDBC FAIL VARCHAR(60)
+  getTime= (?????):Invalid data conversion: Parameter instance 32 is invalid for requested conversion to java.sql.Time. JDBC FAIL VARCHAR(60)
+  getTimestamp= (?????):Invalid data conversion: Parameter instance 32 is invalid for requested conversion to java.sql.Timestamp. JDBC FAIL VARCHAR(60)
   getAsciiStream=0x33,0x32 was null false JDBC MATCH(OK)
   getBinaryStream=IC JDBC MATCH (INVALID)
   getCharacterStream=0x33,0x32 was null false JDBC MATCH(OK)
@@ -954,7 +954,7 @@
   setNull(CLOB) getString=null was null true
   setNull(BLOB) getString=null was null true
   setNull(Types.NULL) getString=null was null true
-  setNull(235350345) getString=null was null true
+  setNull(235350345) SQLSTATE(null): org.apache.derby.client.am.SqlException: unrecognized sql type
 setXXX() with all JDBC Types on VARCHAR(60)
 For setXXX() methods that pass an object, a null and valid values are checked
   setByte() getString=98 was null false JDBC MATCH(OK)
@@ -968,7 +968,7 @@
   setBoolean() getString=1 was null false JDBC MATCH(OK)
   setString() getString=97 was null false JDBC MATCH(OK)
   setString(null) getString=null was null true JDBC MATCH(OK)
-  setBytes() IC JDBC MATCH (INVALID)
+  setBytes() getString=EncodedString: > 1027 64963 29440 < was null false CLOUD EXT (OK)
   setBytes(null) getString=null was null true CLOUD EXT (OK)
   setDate() getString=2004-02-14 was null false JDBC MATCH(OK)
   setDate(null) getString=null was null true JDBC MATCH(OK)
@@ -978,13 +978,13 @@
   setTimestamp(null) getString=null was null true JDBC MATCH(OK)
   setAsciiStream() getString=eg012d was null false JDBC MATCH(OK)
   setAsciiStream(null) getString=null was null true JDBC MATCH(OK)
-  setBinaryStream() IC JDBC MATCH (INVALID)
+  setBinaryStream() getString=EncodedString: > 33347 51966 50 < was null false CLOUD EXT (OK)
   setBinaryStream(null) getString=null was null true CLOUD EXT (OK)
   setCharacterStream() getString=89 was null false JDBC MATCH(OK)
   setCharacterStream(null) getString=null was null true JDBC MATCH(OK)
-  setClob() getString=<OBJECT.toString()> was null false CLOUD EXT (OK)
+  setClob() getString=72 was null false CLOUD EXT (OK)
   setClob(null) getString=null was null true CLOUD EXT (OK)
-  setBlob() IC JDBC MATCH (INVALID)
+  setBlob() getString=EncodedString: > 12867 29251 55 < was null false CLOUD EXT (OK)
   setBlob(null) 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)
@@ -996,7 +996,7 @@
   setObject(java.lang.Long) getString=79 was null false JDBC MATCH(OK)
   setObject(java.lang.Float) getString=76.3 was null false JDBC MATCH(OK)
   setObject(java.lang.Double) getString=12.33 was null false JDBC MATCH(OK)
-  setObject(byte[]) IC JDBC MATCH (INVALID)
+  setObject(byte[]) getString=EncodedString: > 12857 < was null false CLOUD EXT (OK)
   setObject(java.sql.Date) getString=2004-02-14 was null false JDBC MATCH(OK)
   setObject(java.sql.Time) getString=13:26:42 was null false JDBC MATCH(OK)
   setObject(java.sql.Timestamp) getString=xxxxxxFILTERED-TIMESTAMPxxxxxwas null false JDBC MATCH(OK)
@@ -1033,9 +1033,9 @@
   getBoolean=true was null false JDBC MATCH(OK)
   getString=32 was null false JDBC MATCH(OK)
   getBytes=IC JDBC MATCH (INVALID)
-  getDate=java.lang.StringIndexOutOfBoundsException: String index out of range: 2 JDBC FAIL LONG VARCHAR
-  getTime=java.lang.StringIndexOutOfBoundsException: String index out of range: 2 JDBC FAIL LONG VARCHAR
-  getTimestamp=java.lang.StringIndexOutOfBoundsException: String index out of range: 2 JDBC FAIL LONG VARCHAR
+  getDate= (?????):Invalid data conversion: Parameter instance 32 is invalid for requested conversion to java.sql.Date. JDBC FAIL LONG VARCHAR
+  getTime= (?????):Invalid data conversion: Parameter instance 32 is invalid for requested conversion to java.sql.Time. JDBC FAIL LONG VARCHAR
+  getTimestamp= (?????):Invalid data conversion: Parameter instance 32 is invalid for requested conversion to java.sql.Timestamp. JDBC FAIL LONG VARCHAR
   getAsciiStream=0x33,0x32 was null false JDBC MATCH(OK)
   getBinaryStream=IC JDBC MATCH (INVALID)
   getCharacterStream=0x33,0x32 was null false JDBC MATCH(OK)
@@ -1064,7 +1064,7 @@
   setNull(CLOB) getString=null was null true
   setNull(BLOB) getString=null was null true
   setNull(Types.NULL) getString=null was null true
-  setNull(235350345) getString=null was null true
+  setNull(235350345) SQLSTATE(null): org.apache.derby.client.am.SqlException: unrecognized sql type
 setXXX() with all JDBC Types on LONG VARCHAR
 For setXXX() methods that pass an object, a null and valid values are checked
   setByte() getString=98 was null false JDBC MATCH(OK)
@@ -1078,7 +1078,7 @@
   setBoolean() getString=1 was null false JDBC MATCH(OK)
   setString() getString=97 was null false JDBC MATCH(OK)
   setString(null) getString=null was null true JDBC MATCH(OK)
-  setBytes() IC JDBC MATCH (INVALID)
+  setBytes() getString=EncodedString: > 1027 64963 29440 < was null false CLOUD EXT (OK)
   setBytes(null) getString=null was null true CLOUD EXT (OK)
   setDate() getString=2004-02-14 was null false JDBC MATCH(OK)
   setDate(null) getString=null was null true JDBC MATCH(OK)
@@ -1088,13 +1088,13 @@
   setTimestamp(null) getString=null was null true JDBC MATCH(OK)
   setAsciiStream() getString=eg012d was null false JDBC MATCH(OK)
   setAsciiStream(null) getString=null was null true JDBC MATCH(OK)
-  setBinaryStream() IC JDBC MATCH (INVALID)
+  setBinaryStream() getString=EncodedString: > 33347 51966 50 < was null false CLOUD EXT (OK)
   setBinaryStream(null) getString=null was null true CLOUD EXT (OK)
   setCharacterStream() getString=89 was null false JDBC MATCH(OK)
   setCharacterStream(null) getString=null was null true JDBC MATCH(OK)
-  setClob() getString=<OBJECT.toString()> was null false CLOUD EXT (OK)
+  setClob() getString=72 was null false CLOUD EXT (OK)
   setClob(null) getString=null was null true CLOUD EXT (OK)
-  setBlob() IC JDBC MATCH (INVALID)
+  setBlob() getString=EncodedString: > 12867 29251 55 < was null false CLOUD EXT (OK)
   setBlob(null) 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)
@@ -1106,7 +1106,7 @@
   setObject(java.lang.Long) getString=79 was null false JDBC MATCH(OK)
   setObject(java.lang.Float) getString=76.3 was null false JDBC MATCH(OK)
   setObject(java.lang.Double) getString=12.33 was null false JDBC MATCH(OK)
-  setObject(byte[]) IC JDBC MATCH (INVALID)
+  setObject(byte[]) getString=EncodedString: > 12857 < was null false CLOUD EXT (OK)
   setObject(java.sql.Date) getString=2004-02-14 was null false JDBC MATCH(OK)
   setObject(java.sql.Time) getString=13:26:42 was null false JDBC MATCH(OK)
   setObject(java.sql.Timestamp) getString=xxxxxxFILTERED-TIMESTAMPxxxxxwas null false JDBC MATCH(OK)
@@ -1176,7 +1176,7 @@
   setNull(CLOB) getBytes=null was null true
   setNull(BLOB) getBytes=null was null true
   setNull(Types.NULL) getBytes=null was null true
-  setNull(235350345) getBytes=null was null true
+  setNull(235350345) SQLSTATE(null): org.apache.derby.client.am.SqlException: unrecognized sql type
 setXXX() with all JDBC Types on VARCHAR(60) FOR BIT DATA
 For setXXX() methods that pass an object, a null and valid values are checked
   setByte() IC JDBC MATCH (INVALID)
@@ -1208,10 +1208,10 @@
   setClob(null) getBytes=null was null true CLOUD EXT (OK)
   setBlob() getBytes=0x32,0x43 was null false CLOUD EXT (OK)
   setBlob(null) getBytes=null was null true CLOUD EXT (OK)
-  setUnicodeStream()  (?????):Illegal Conversion JDBC FAIL VARCHAR(60) FOR BIT DATA
+  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(java.lang.String)  (?????):Illegal Conversion JDBC FAIL VARCHAR(60) FOR BIT DATA
+  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.math.BigDecimal) IC JDBC MATCH (INVALID)
   setObject(java.lang.Boolean) IC JDBC MATCH (INVALID)
   setObject(java.lang.Integer) IC JDBC MATCH (INVALID)
@@ -1288,7 +1288,7 @@
   setNull(CLOB) getDate=null was null true
   setNull(BLOB) getDate=null was null true
   setNull(Types.NULL) getDate=null was null true
-  setNull(235350345) getDate=null was null true
+  setNull(235350345) SQLSTATE(null): org.apache.derby.client.am.SqlException: unrecognized sql type
 setXXX() with all JDBC Types on DATE
 For setXXX() methods that pass an object, a null and valid values are checked
   setByte() IC JDBC MATCH (INVALID)
@@ -1300,8 +1300,7 @@
   setBigDecimal() IC JDBC MATCH (INVALID)
   setBigDecimal(null) getDate=null was null true CLOUD EXT (OK)
   setBoolean() IC JDBC MATCH (INVALID)
-  setString() String index out of range: 2
- JDBC FAIL DATE
+  setString()  (22007):The syntax of the string representation of a datetime value is incorrect. JDBC FAIL DATE
   setString(null) getDate=null was null true JDBC MATCH(OK)
   setBytes() IC JDBC MATCH (INVALID)
   setBytes(null) getDate=null was null true CLOUD EXT (OK)
@@ -1311,20 +1310,20 @@
   setTime(null) getDate=null was null true CLOUD EXT (OK)
   setTimestamp() getDate=2004-02-23 was null false JDBC MATCH(OK)
   setTimestamp(null) getDate=null was null true JDBC MATCH(OK)
-  setAsciiStream() IC JDBC MATCH (INVALID)
+  setAsciiStream()  (22007):The syntax of the string representation of a datetime value is incorrect. JDBC MATCH (INVALID)
   setAsciiStream(null) getDate=null was null true CLOUD EXT (OK)
   setBinaryStream() IC JDBC MATCH (INVALID)
   setBinaryStream(null) getDate=null was null true CLOUD EXT (OK)
-  setCharacterStream() IC JDBC MATCH (INVALID)
+  setCharacterStream()  (22007):The syntax of the string representation of a datetime value is incorrect. JDBC MATCH (INVALID)
   setCharacterStream(null) getDate=null was null true CLOUD EXT (OK)
-  setClob() IC JDBC MATCH (INVALID)
+  setClob()  (22007):The syntax of the string representation of a datetime value is incorrect. JDBC MATCH (INVALID)
   setClob(null) getDate=null was null true CLOUD EXT (OK)
   setBlob() IC JDBC MATCH (INVALID)
   setBlob(null) getDate=null was null true CLOUD EXT (OK)
-  setUnicodeStream() IC JDBC MATCH (INVALID)
+  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(java.lang.String) FAIL String index out of range: 2
+  setObject(java.lang.String)  (22007):The syntax of the string representation of a datetime value is incorrect. JDBC FAIL DATE
   setObject(java.math.BigDecimal) IC JDBC MATCH (INVALID)
   setObject(java.lang.Boolean) IC JDBC MATCH (INVALID)
   setObject(java.lang.Integer) IC JDBC MATCH (INVALID)
@@ -1399,7 +1398,7 @@
   setNull(CLOB) getTime=null was null true
   setNull(BLOB) getTime=null was null true
   setNull(Types.NULL) getTime=null was null true
-  setNull(235350345) getTime=null was null true
+  setNull(235350345) SQLSTATE(null): org.apache.derby.client.am.SqlException: unrecognized sql type
 setXXX() with all JDBC Types on TIME
 For setXXX() methods that pass an object, a null and valid values are checked
   setByte() IC JDBC MATCH (INVALID)
@@ -1408,11 +1407,10 @@
   setLong() IC JDBC MATCH (INVALID)
   setFloat() IC JDBC MATCH (INVALID)
   setDouble() IC JDBC MATCH (INVALID)
-  setBigDecimal() IC JDBC MATCH (INVALID)
+  setBigDecimal()  (?????):BigDecimal conversion exception [converters] Overflow occurred during numeric data type conversion of "99".. See attached Throwable. JDBC MATCH (INVALID)
   setBigDecimal(null) getTime=null was null true CLOUD EXT (OK)
   setBoolean() IC JDBC MATCH (INVALID)
-  setString() String index out of range: 2
- JDBC FAIL TIME
+  setString()  (22007):The syntax of the string representation of a datetime value is incorrect. JDBC FAIL TIME
   setString(null) getTime=null was null true JDBC MATCH(OK)
   setBytes() IC JDBC MATCH (INVALID)
   setBytes(null) getTime=null was null true CLOUD EXT (OK)
@@ -1422,21 +1420,21 @@
   setTime(null) getTime=null was null true JDBC MATCH(OK)
   setTimestamp() getTime=17:14:24 was null false JDBC MATCH(OK)
   setTimestamp(null) getTime=null was null true JDBC MATCH(OK)
-  setAsciiStream() IC JDBC MATCH (INVALID)
+  setAsciiStream()  (22007):The syntax of the string representation of a datetime value is incorrect. JDBC MATCH (INVALID)
   setAsciiStream(null) getTime=null was null true CLOUD EXT (OK)
   setBinaryStream() IC JDBC MATCH (INVALID)
   setBinaryStream(null) getTime=null was null true CLOUD EXT (OK)
-  setCharacterStream() IC JDBC MATCH (INVALID)
+  setCharacterStream()  (22007):The syntax of the string representation of a datetime value is incorrect. JDBC MATCH (INVALID)
   setCharacterStream(null) getTime=null was null true CLOUD EXT (OK)
-  setClob() IC JDBC MATCH (INVALID)
+  setClob()  (22007):The syntax of the string representation of a datetime value is incorrect. JDBC MATCH (INVALID)
   setClob(null) getTime=null was null true CLOUD EXT (OK)
   setBlob() IC JDBC MATCH (INVALID)
   setBlob(null) getTime=null was null true CLOUD EXT (OK)
-  setUnicodeStream() IC JDBC MATCH (INVALID)
+  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(java.lang.String) FAIL String index out of range: 2
-  setObject(java.math.BigDecimal) IC JDBC MATCH (INVALID)
+  setObject(java.lang.String)  (22007):The syntax of the string representation of a datetime value is incorrect. JDBC FAIL TIME
+  setObject(java.math.BigDecimal)  (?????):BigDecimal conversion exception [converters] Overflow occurred during numeric data type conversion of "72".. See attached Throwable. JDBC MATCH (INVALID)
   setObject(java.lang.Boolean) IC JDBC MATCH (INVALID)
   setObject(java.lang.Integer) IC JDBC MATCH (INVALID)
   setObject(java.lang.Long) IC JDBC MATCH (INVALID)
@@ -1510,7 +1508,7 @@
   setNull(CLOB) getTimestamp=null was null true
   setNull(BLOB) getTimestamp=null was null true
   setNull(Types.NULL) getTimestamp=null was null true
-  setNull(235350345) getTimestamp=null was null true
+  setNull(235350345) SQLSTATE(null): org.apache.derby.client.am.SqlException: unrecognized sql type
 setXXX() with all JDBC Types on TIMESTAMP
 For setXXX() methods that pass an object, a null and valid values are checked
   setByte() IC JDBC MATCH (INVALID)
@@ -1519,35 +1517,34 @@
   setLong() IC JDBC MATCH (INVALID)
   setFloat() IC JDBC MATCH (INVALID)
   setDouble() IC JDBC MATCH (INVALID)
-  setBigDecimal() IC JDBC MATCH (INVALID)
+  setBigDecimal()  (?????):BigDecimal conversion exception [converters] Overflow occurred during numeric data type conversion of "99".. See attached Throwable. JDBC MATCH (INVALID)
   setBigDecimal(null) getTimestamp=null was null true CLOUD EXT (OK)
   setBoolean() IC JDBC MATCH (INVALID)
-  setString() String index out of range: 2
- JDBC FAIL TIMESTAMP
+  setString()  (22007):The syntax of the string representation of a datetime value is incorrect. JDBC FAIL TIMESTAMP
   setString(null) getTimestamp=null was null true JDBC MATCH(OK)
   setBytes() IC JDBC MATCH (INVALID)
   setBytes(null) getTimestamp=null was null true CLOUD EXT (OK)
   setDate() getTimestamp=00:00:00 was null false JDBC MATCH(OK)
   setDate(null) getTimestamp=null was null true JDBC MATCH(OK)
-  setTime()  (?????):Illegal Conversion JDBC FAIL TIMESTAMP
+  setTime() getTimestamp=13:26:42 was null false JDBC MATCH(OK)
   setTime(null) getTimestamp=null was null true JDBC MATCH(OK)
   setTimestamp() getTimestamp=17:14:24 was null false JDBC MATCH(OK)
   setTimestamp(null) getTimestamp=null was null true JDBC MATCH(OK)
-  setAsciiStream() IC JDBC MATCH (INVALID)
+  setAsciiStream()  (22007):The syntax of the string representation of a datetime value is incorrect. JDBC MATCH (INVALID)
   setAsciiStream(null) getTimestamp=null was null true CLOUD EXT (OK)
   setBinaryStream() IC JDBC MATCH (INVALID)
   setBinaryStream(null) getTimestamp=null was null true CLOUD EXT (OK)
-  setCharacterStream() IC JDBC MATCH (INVALID)
+  setCharacterStream()  (22007):The syntax of the string representation of a datetime value is incorrect. JDBC MATCH (INVALID)
   setCharacterStream(null) getTimestamp=null was null true CLOUD EXT (OK)
-  setClob() IC JDBC MATCH (INVALID)
+  setClob()  (22007):The syntax of the string representation of a datetime value is incorrect. JDBC MATCH (INVALID)
   setClob(null) getTimestamp=null was null true CLOUD EXT (OK)
   setBlob() IC JDBC MATCH (INVALID)
   setBlob(null) getTimestamp=null was null true CLOUD EXT (OK)
-  setUnicodeStream() IC JDBC MATCH (INVALID)
+  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(java.lang.String) FAIL String index out of range: 2
-  setObject(java.math.BigDecimal) IC JDBC MATCH (INVALID)
+  setObject(java.lang.String)  (22007):The syntax of the string representation of a datetime value is incorrect. JDBC FAIL TIMESTAMP
+  setObject(java.math.BigDecimal)  (?????):BigDecimal conversion exception [converters] Overflow occurred during numeric data type conversion of "72".. See attached Throwable. JDBC MATCH (INVALID)
   setObject(java.lang.Boolean) IC JDBC MATCH (INVALID)
   setObject(java.lang.Integer) IC JDBC MATCH (INVALID)
   setObject(java.lang.Long) IC JDBC MATCH (INVALID)
@@ -1555,7 +1552,7 @@
   setObject(java.lang.Double) IC JDBC MATCH (INVALID)
   setObject(byte[]) IC JDBC MATCH (INVALID)
   setObject(java.sql.Date) getTimestamp=00:00:00 was null false JDBC MATCH(OK)
-  setObject(java.sql.Time) IC JDBC MATCH (INVALID)
+  setObject(java.sql.Time) getTimestamp=13:26:42 was null false CLOUD EXT (OK)
   setObject(java.sql.Timestamp) getTimestamp=17:14:24 was null false JDBC MATCH(OK)
 getXXX on : CLOB(1k)
  NULL VALUE
@@ -1621,7 +1618,7 @@
   setNull(CLOB) getClob=null was null true
   setNull(BLOB) getClob=null was null true
   setNull(Types.NULL) getClob=null was null true
-  setNull(235350345) getClob=null was null true
+  setNull(235350345) SQLSTATE(null): org.apache.derby.client.am.SqlException: unrecognized sql type
 setXXX() with all JDBC Types on CLOB(1k)
 For setXXX() methods that pass an object, a null and valid values are checked
   setByte() IC JDBC MATCH (INVALID)
@@ -1731,7 +1728,7 @@
   setNull(CLOB) getBlob=null was null true
   setNull(BLOB) getBlob=null was null true
   setNull(Types.NULL) getBlob=null was null true
-  setNull(235350345) getBlob=null was null true
+  setNull(235350345) SQLSTATE(null): org.apache.derby.client.am.SqlException: unrecognized sql type
 setXXX() with all JDBC Types on BLOB(1k)
 For setXXX() methods that pass an object, a null and valid values are checked
   setByte() IC JDBC MATCH (INVALID)
@@ -1763,7 +1760,7 @@
   setClob(null) getBlob=null was null true CLOUD EXT (OK)
   setBlob() getBlob=0x32,0x43 was null false JDBC MATCH(OK)
   setBlob(null) getBlob=null was null true JDBC MATCH(OK)
-  setUnicodeStream()  (?????):Illegal Conversion JDBC FAIL BLOB(1k)
+  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(java.lang.String) IC JDBC MATCH (INVALID)

Modified: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/procedure.out
URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/procedure.out?view=diff&r1=157135&r2=157136
==============================================================================
--- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/procedure.out (original)
+++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/procedure.out Fri Mar 11 11:45:01 2005
@@ -89,7 +89,7 @@
 No ResultSet or update count returned
 No ResultSet or update count returned
 No ResultSet or update count returned
-FAIL - prepareStatement call za(?)
+EXPECTED SQL Exception: 'ZA' is not recognized as a function or procedure.
 No ResultSet or update count returned
 No ResultSet or update count returned
 DEFINED PROCEDURES FOR ZA
@@ -264,7 +264,6 @@
 EXPECTED SQL Exception: (39004) A NULL value cannot be passed to a method which takes a parameter of primitive type 'short'.
 p_inout 9 p_out 6
 p_inout 9 null?false p_out 6 null?false
-p_inout 9 null?false p_out 6 null?false
 outparams
 DEFINED PROCEDURES FOR OP1
   APP.OP1 AS org.apache.derbyTesting.functionTests.util.ProcedureTest.outparams1(OUT A INTEGER,IN B INTEGER) LANGUAGE JAVA PARAMETER STYLE JAVA MODIFIES SQL DATA
@@ -312,7 +311,7 @@
 No ResultSet or update count returned
 OP4 49.345 >66.34< null ? false
 EXPECTED SQL Exception: Invalid argument: parameter index 2 is not an OUT or INOUT parameter.
-EXPECTED SQL Exception: (<NULL>) Invalid operation: parameter 1 not set or registered
+EXPECTED SQL Exception: (07000) At least one parameter to the current statement is uninitialized.
 DEFINED PROCEDURES FOR OP4INOUT
   APP.OP4INOUT AS org.apache.derbyTesting.functionTests.util.ProcedureTest.inoutparams4(INOUT A DECIMAL(4,2),IN B VARCHAR(255)) LANGUAGE JAVA PARAMETER STYLE JAVA MODIFIES SQL DATA
 DATABASE METATDATA PROCEDURES FOR OP4INOUT
@@ -330,7 +329,7 @@
 OP4INOUT 9+23.505 >32.50< null ? false
 EXPECTED SQL Exception: The resulting value is outside the range for the data type DECIMAL/NUMERIC(4,2).
 EXPECTED SQL Exception: BigDecimal conversion exception [converters] Overflow occurred during numeric data type conversion of "102.33".. See attached Throwable.
-EXPECTED SQL Exception: (<NULL>) Invalid operation: parameter 1 not set or registered
+EXPECTED SQL Exception: (07000) At least one parameter to the current statement is uninitialized.
 SQL Control
 CREATE PROCEDURE SQLC.SQLCONTROL1_0 (OUT E1 VARCHAR(128), OUT E2 VARCHAR(128), OUT E3 VARCHAR(128), OUT E4 VARCHAR(128), OUT E5 VARCHAR(128), OUT E6 VARCHAR(128), OUT E7 VARCHAR(128))  PARAMETER STYLE JAVA LANGUAGE JAVA EXTERNAL NAME 'org.apache.derbyTesting.functionTests.util.ProcedureTest.sqlControl'
 CREATE PROCEDURE SQLC.SQLCONTROL2_0 (OUT E1 VARCHAR(128), OUT E2 VARCHAR(128), OUT E3 VARCHAR(128), OUT E4 VARCHAR(128), OUT E5 VARCHAR(128), OUT E6 VARCHAR(128), OUT E7 VARCHAR(128))  PARAMETER STYLE JAVA LANGUAGE JAVA EXTERNAL NAME 'org.apache.derbyTesting.functionTests.util.ProcedureTest.sqlControl2'
@@ -835,7 +834,7 @@
          CREATE SCHEMA S-UPDATE 0-EXECUTE OK
          DROP SCHEMA SQL-UPDATE 0-EXECUTE OK
 CALL SQLCONTROL3_0 (?, ?, ?, ?, ?, ?, ?)
-EXPECTED SQL Exception: (07004) Parameter 1 is an OUT procedure parameter and must be registered with CallableStatement.registerOutParameter before execution.
+EXPECTED SQL Exception: (07000) At least one parameter to the current statement is uninitialized.
 literals
 DEFINED PROCEDURES FOR TY_%
   LITT.TY_BIGINT AS org.apache.derbyTesting.functionTests.util.ProcedureTest.literalTest(IN P1 BIGINT,OUT P2 VARCHAR(256)) LANGUAGE JAVA PARAMETER STYLE JAVA NO SQL

Modified: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/derbynet/csPrepStmt.java
URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/derbynet/csPrepStmt.java?view=diff&r1=157135&r2=157136
==============================================================================
--- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/derbynet/csPrepStmt.java (original)
+++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/derbynet/csPrepStmt.java Fri Mar 11 11:45:01 2005
@@ -434,12 +434,12 @@
 		catch(SQLException sqle)
 		{
 			logErr("SQL Exception: " + sqle.getMessage());
-			throw new Exception("Call to setObject is Failed!");
+			throw sqle;
 		}
 		catch(Exception e)
 		{
 			logErr("Unexpected Exception: " + e.getMessage());
-			throw new Exception("Call to setObject is Failed!");
+			throw e;
 		}
 
 		finally
@@ -500,7 +500,7 @@
 
 		try {
 			ps = conn.prepareStatement(insertSql);
-			
+			//System.out.println("Prepared statement" + insertSql);
 			for (i = 1; i <= numCols; i++)
 				ps.setInt(i,i);
 			ps.executeUpdate();
@@ -508,6 +508,7 @@
 		{
 			System.out.println("SQLState: " + e.getSQLState() + 
 							   " message: " + e.getMessage());			
+			//e.printStackTrace();
 		}
 		
 	}

Modified: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/procedure.java
URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/procedure.java?view=diff&r1=157135&r2=157136
==============================================================================
--- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/procedure.java (original)
+++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/procedure.java Fri Mar 11 11:45:01 2005
@@ -829,15 +829,16 @@
 		ptsi.execute();
 		System.out.println("p_inout " + ptsi.getByte(2) + " null?" + ptsi.wasNull() + " p_out " + ptsi.getByte(3) + " null?" + ptsi.wasNull());
 
-		// with setObject . Beetle 5439
-		ptsi.setObject(1, new Integer(6));
-		ptsi.setObject(2, new Integer(3));
-		
-		ptsi.execute();
-		System.out.println("p_inout " + ptsi.getByte(2) + " null?" + ptsi.wasNull() + " p_out " + ptsi.getByte(3) + " null?" + ptsi.wasNull());
-	
+		if (!TestUtil.isDerbyNetClientFramework())
+		{
+			// with setObject . Beetle 5439
+			ptsi.setObject(1, new Integer(6));
+			ptsi.setObject(2, new Integer(3));
+			
+			ptsi.execute();
+			System.out.println("p_inout " + ptsi.getByte(2) + " null?" + ptsi.wasNull() + " p_out " + ptsi.getByte(3) + " null?" + ptsi.wasNull());
+		}
 		ptsi.close();
-
 
 		s.execute("DROP procedure PTSMALLINT2");		
 		s.execute("DROP TABLE PT1");



Mime
View raw message