db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From fuzzylo...@apache.org
Subject svn commit: r160466 [1/2] - in incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests: master/ master/DerbyNet/ master/DerbyNetClient/ master/jdk14/ tests/jdbcapi/ tests/lang/
Date Thu, 07 Apr 2005 20:39:23 GMT
Author: fuzzylogic
Date: Thu Apr  7 13:39:20 2005
New Revision: 160466

URL: http://svn.apache.org/viewcvs?view=rev&rev=160466
Log:
Modify 3 tests and their expected output files - jdbcapi/LOBTest, jdbcapi/odbc_metadata, and 
lang/updatableResultSet.java - to overcome some false failures when running with newer versions of 
the IBM Universal Driver.

Committed for Myrna Van Lunteran <myrna@golux.com>

Added:
    incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/odbc_metadata_sed.properties   (with props)
Modified:
    incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/LOBTest.out
    incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/odbc_metadata.out
    incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/updatableResultSet.out
    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/updatableResultSet.out
    incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/LOBTest.out
    incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/jdk14/updatableResultSet.out
    incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/updatableResultSet.out
    incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/LOBTest.java
    incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/copyfiles.ant
    incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/updatableResultSet.java

Modified: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/LOBTest.out
URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/LOBTest.out?view=diff&r1=160465&r2=160466
==============================================================================
--- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/LOBTest.out (original)
+++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/LOBTest.out Thu Apr  7 13:39:20 2005
@@ -1,7 +1,7 @@
 create table bit_table ( dummy int , col_0 int, col_1 char(10), col_2 varchar(80), col_3 long varchar, col_4 char(10) for bit data, col_5 long varchar for bit data, col_6 blob(80), typecol char (8 ) for bit data )
 insert into bit_table values ( 45 ,100,'101','102','103',X'003100300034',X'003100300035',CAST (X'003100300036' AS blob(80)),CAST (X'003100300037' AS char (8 ) for bit data) )
 insert into bit_table ( col_0 ) values ( 'true' )
-	com.ibm.db2.jcc.c.SqlException: Columns of type 'INTEGER' cannot hold values of type 'CHAR'. 
+	ERROR 42821: Columns of type 'INTEGER' cannot hold values of type 'CHAR'. 
 insert into bit_table ( col_1 ) values ( 'true' )
 insert into bit_table ( col_2 ) values ( 'true' )
 insert into bit_table ( col_3 ) values ( 'true' )
@@ -380,13 +380,13 @@
 	OUT = Object : byte[]
 -----< columns CAST TO type: METADATA TESTS
 select cast( col_0 as char (8) for bit data ) from bit_table
-	com.ibm.db2.jcc.c.SqlException: Cannot convert types 'INTEGER' to 'CHAR () FOR BIT DATA'.
+	ERROR 42846: Cannot convert types 'INTEGER' to 'CHAR () FOR BIT DATA'.
 select cast( col_1 as char (8) for bit data ) from bit_table
-	com.ibm.db2.jcc.c.SqlException: Cannot convert types 'CHAR' to 'CHAR () FOR BIT DATA'.
+	ERROR 42846: Cannot convert types 'CHAR' to 'CHAR () FOR BIT DATA'.
 select cast( col_2 as char (8) for bit data ) from bit_table
-	com.ibm.db2.jcc.c.SqlException: Cannot convert types 'VARCHAR' to 'CHAR () FOR BIT DATA'.
+	ERROR 42846: Cannot convert types 'VARCHAR' to 'CHAR () FOR BIT DATA'.
 select cast( col_3 as char (8) for bit data ) from bit_table
-	com.ibm.db2.jcc.c.SqlException: Cannot convert types 'LONG VARCHAR' to 'CHAR () FOR BIT DATA'.
+	ERROR 42846: Cannot convert types 'LONG VARCHAR' to 'CHAR () FOR BIT DATA'.
 select cast( col_4 as char (8) for bit data ) from bit_table
 	---- 1
 	Column    : 1
@@ -434,7 +434,7 @@
 	OUT = NULL
 	OUT = NULL
 select cast( col_6 as char (8) for bit data ) from bit_table
-	com.ibm.db2.jcc.c.SqlException: Cannot convert types 'BLOB' to 'CHAR () FOR BIT DATA'.
+	ERROR 42846: Cannot convert types 'BLOB' to 'CHAR () FOR BIT DATA'.
 select cast( typecol as char (8) for bit data ) from bit_table
 	---- 1
 	Column    : 1
@@ -460,13 +460,13 @@
 	OUT = Object : byte[]
 -----< type CAST TO types: METADATA TESTS
 select cast( typecol as int ) from bit_table
-	com.ibm.db2.jcc.c.SqlException: Cannot convert types 'CHAR () FOR BIT DATA' to 'INTEGER'.
+	ERROR 42846: Cannot convert types 'CHAR () FOR BIT DATA' to 'INTEGER'.
 select cast( typecol as char(10) ) from bit_table
-	com.ibm.db2.jcc.c.SqlException: Cannot convert types 'CHAR () FOR BIT DATA' to 'CHAR'.
+	ERROR 42846: Cannot convert types 'CHAR () FOR BIT DATA' to 'CHAR'.
 select cast( typecol as varchar(80) ) from bit_table
-	com.ibm.db2.jcc.c.SqlException: Cannot convert types 'CHAR () FOR BIT DATA' to 'VARCHAR'.
+	ERROR 42846: Cannot convert types 'CHAR () FOR BIT DATA' to 'VARCHAR'.
 select cast( typecol as long varchar ) from bit_table
-	com.ibm.db2.jcc.c.SqlException: Cannot convert types 'CHAR () FOR BIT DATA' to 'LONG VARCHAR'.
+	ERROR 42846: Cannot convert types 'CHAR () FOR BIT DATA' to 'LONG VARCHAR'.
 select cast( typecol as char(10) for bit data ) from bit_table
 	---- 1
 	Column    : 1
@@ -563,7 +563,7 @@
 create table bit_table ( dummy int , col_0 int, col_1 char(10), col_2 varchar(80), col_3 long varchar, col_4 char(10) for bit data, col_5 long varchar for bit data, col_6 blob(80), typecol char (8 ) for bit data )
 insert into bit_table values ( 45 ,100,'101','102','103',X'003100300034',X'003100300035',CAST (X'003100300036' AS blob(80)),CAST (X'003100300037' AS char (8 ) for bit data) )
 insert into bit_table ( col_0 ) values ( 'true' )
-	com.ibm.db2.jcc.c.SqlException: Columns of type 'INTEGER' cannot hold values of type 'CHAR'. 
+	ERROR 42821: Columns of type 'INTEGER' cannot hold values of type 'CHAR'. 
 insert into bit_table ( col_1 ) values ( 'true' )
 insert into bit_table ( col_2 ) values ( 'true' )
 insert into bit_table ( col_3 ) values ( 'true' )
@@ -942,13 +942,13 @@
 	OUT = Object : byte[]
 -----< columns CAST TO type: METADATA TESTS
 select cast( col_0 as char (8) for bit data ) from bit_table
-	com.ibm.db2.jcc.c.SqlException: Cannot convert types 'INTEGER' to 'CHAR () FOR BIT DATA'.
+	ERROR 42846: Cannot convert types 'INTEGER' to 'CHAR () FOR BIT DATA'.
 select cast( col_1 as char (8) for bit data ) from bit_table
-	com.ibm.db2.jcc.c.SqlException: Cannot convert types 'CHAR' to 'CHAR () FOR BIT DATA'.
+	ERROR 42846: Cannot convert types 'CHAR' to 'CHAR () FOR BIT DATA'.
 select cast( col_2 as char (8) for bit data ) from bit_table
-	com.ibm.db2.jcc.c.SqlException: Cannot convert types 'VARCHAR' to 'CHAR () FOR BIT DATA'.
+	ERROR 42846: Cannot convert types 'VARCHAR' to 'CHAR () FOR BIT DATA'.
 select cast( col_3 as char (8) for bit data ) from bit_table
-	com.ibm.db2.jcc.c.SqlException: Cannot convert types 'LONG VARCHAR' to 'CHAR () FOR BIT DATA'.
+	ERROR 42846: Cannot convert types 'LONG VARCHAR' to 'CHAR () FOR BIT DATA'.
 select cast( col_4 as char (8) for bit data ) from bit_table
 	---- 1
 	Column    : 1
@@ -996,7 +996,7 @@
 	OUT = NULL
 	OUT = NULL
 select cast( col_6 as char (8) for bit data ) from bit_table
-	com.ibm.db2.jcc.c.SqlException: Cannot convert types 'BLOB' to 'CHAR () FOR BIT DATA'.
+	ERROR 42846: Cannot convert types 'BLOB' to 'CHAR () FOR BIT DATA'.
 select cast( typecol as char (8) for bit data ) from bit_table
 	---- 1
 	Column    : 1
@@ -1022,13 +1022,13 @@
 	OUT = Object : byte[]
 -----< type CAST TO types: METADATA TESTS
 select cast( typecol as int ) from bit_table
-	com.ibm.db2.jcc.c.SqlException: Cannot convert types 'CHAR () FOR BIT DATA' to 'INTEGER'.
+	ERROR 42846: Cannot convert types 'CHAR () FOR BIT DATA' to 'INTEGER'.
 select cast( typecol as char(10) ) from bit_table
-	com.ibm.db2.jcc.c.SqlException: Cannot convert types 'CHAR () FOR BIT DATA' to 'CHAR'.
+	ERROR 42846: Cannot convert types 'CHAR () FOR BIT DATA' to 'CHAR'.
 select cast( typecol as varchar(80) ) from bit_table
-	com.ibm.db2.jcc.c.SqlException: Cannot convert types 'CHAR () FOR BIT DATA' to 'VARCHAR'.
+	ERROR 42846: Cannot convert types 'CHAR () FOR BIT DATA' to 'VARCHAR'.
 select cast( typecol as long varchar ) from bit_table
-	com.ibm.db2.jcc.c.SqlException: Cannot convert types 'CHAR () FOR BIT DATA' to 'LONG VARCHAR'.
+	ERROR 42846: Cannot convert types 'CHAR () FOR BIT DATA' to 'LONG VARCHAR'.
 select cast( typecol as char(10) for bit data ) from bit_table
 	---- 1
 	Column    : 1
@@ -1125,7 +1125,7 @@
 create table blob_table ( dummy int , col_0 int, col_1 char(10), col_2 varchar(80), col_3 long varchar, col_4 char(10) for bit data, col_5 long varchar for bit data, col_6 blob(80), typecol blob (2 M) )
 insert into blob_table values ( 45 ,100,'101','102','103',X'003100300034',X'003100300035',CAST (X'003100300036' AS blob(80)),CAST (X'003100300037' AS blob (2 M)) )
 insert into blob_table ( col_0 ) values ( 'true' )
-	com.ibm.db2.jcc.c.SqlException: Columns of type 'INTEGER' cannot hold values of type 'CHAR'. 
+	ERROR 42821: Columns of type 'INTEGER' cannot hold values of type 'CHAR'. 
 insert into blob_table ( col_1 ) values ( 'true' )
 insert into blob_table ( col_2 ) values ( 'true' )
 insert into blob_table ( col_3 ) values ( 'true' )
@@ -1504,13 +1504,13 @@
 	OUT = Object : java.sql.Blob
 -----< columns CAST TO type: METADATA TESTS
 select cast( col_0 as blob(2 M) ) from blob_table
-	com.ibm.db2.jcc.c.SqlException: Cannot convert types 'INTEGER' to 'BLOB'.
+	ERROR 42846: Cannot convert types 'INTEGER' to 'BLOB'.
 select cast( col_1 as blob(2 M) ) from blob_table
-	com.ibm.db2.jcc.c.SqlException: Cannot convert types 'CHAR' to 'BLOB'.
+	ERROR 42846: Cannot convert types 'CHAR' to 'BLOB'.
 select cast( col_2 as blob(2 M) ) from blob_table
-	com.ibm.db2.jcc.c.SqlException: Cannot convert types 'VARCHAR' to 'BLOB'.
+	ERROR 42846: Cannot convert types 'VARCHAR' to 'BLOB'.
 select cast( col_3 as blob(2 M) ) from blob_table
-	com.ibm.db2.jcc.c.SqlException: Cannot convert types 'LONG VARCHAR' to 'BLOB'.
+	ERROR 42846: Cannot convert types 'LONG VARCHAR' to 'BLOB'.
 select cast( col_4 as blob(2 M) ) from blob_table
 	---- 1
 	Column    : 1
@@ -1605,17 +1605,17 @@
 	OUT = Object : java.sql.Blob
 -----< type CAST TO types: METADATA TESTS
 select cast( typecol as int ) from blob_table
-	com.ibm.db2.jcc.c.SqlException: Cannot convert types 'BLOB' to 'INTEGER'.
+	ERROR 42846: Cannot convert types 'BLOB' to 'INTEGER'.
 select cast( typecol as char(10) ) from blob_table
-	com.ibm.db2.jcc.c.SqlException: Cannot convert types 'BLOB' to 'CHAR'.
+	ERROR 42846: Cannot convert types 'BLOB' to 'CHAR'.
 select cast( typecol as varchar(80) ) from blob_table
-	com.ibm.db2.jcc.c.SqlException: Cannot convert types 'BLOB' to 'VARCHAR'.
+	ERROR 42846: Cannot convert types 'BLOB' to 'VARCHAR'.
 select cast( typecol as long varchar ) from blob_table
-	com.ibm.db2.jcc.c.SqlException: Cannot convert types 'BLOB' to 'LONG VARCHAR'.
+	ERROR 42846: Cannot convert types 'BLOB' to 'LONG VARCHAR'.
 select cast( typecol as char(10) for bit data ) from blob_table
-	com.ibm.db2.jcc.c.SqlException: Cannot convert types 'BLOB' to 'CHAR () FOR BIT DATA'.
+	ERROR 42846: Cannot convert types 'BLOB' to 'CHAR () FOR BIT DATA'.
 select cast( typecol as long varchar for bit data ) from blob_table
-	com.ibm.db2.jcc.c.SqlException: Cannot convert types 'BLOB' to 'LONG VARCHAR FOR BIT DATA'.
+	ERROR 42846: Cannot convert types 'BLOB' to 'LONG VARCHAR FOR BIT DATA'.
 select cast( typecol as blob(80) ) from blob_table
 	---- 1
 	Column    : 1
@@ -1666,7 +1666,7 @@
 create table blob_table ( dummy int , col_0 int, col_1 char(10), col_2 varchar(80), col_3 long varchar, col_4 char(10) for bit data, col_5 long varchar for bit data, col_6 blob(80), typecol blob (2 K) )
 insert into blob_table values ( 45 ,100,'101','102','103',X'003100300034',X'003100300035',CAST (X'003100300036' AS blob(80)),CAST (X'003100300037' AS blob (2 K)) )
 insert into blob_table ( col_0 ) values ( 'true' )
-	com.ibm.db2.jcc.c.SqlException: Columns of type 'INTEGER' cannot hold values of type 'CHAR'. 
+	ERROR 42821: Columns of type 'INTEGER' cannot hold values of type 'CHAR'. 
 insert into blob_table ( col_1 ) values ( 'true' )
 insert into blob_table ( col_2 ) values ( 'true' )
 insert into blob_table ( col_3 ) values ( 'true' )
@@ -2045,13 +2045,13 @@
 	OUT = Object : java.sql.Blob
 -----< columns CAST TO type: METADATA TESTS
 select cast( col_0 as blob(2 K) ) from blob_table
-	com.ibm.db2.jcc.c.SqlException: Cannot convert types 'INTEGER' to 'BLOB'.
+	ERROR 42846: Cannot convert types 'INTEGER' to 'BLOB'.
 select cast( col_1 as blob(2 K) ) from blob_table
-	com.ibm.db2.jcc.c.SqlException: Cannot convert types 'CHAR' to 'BLOB'.
+	ERROR 42846: Cannot convert types 'CHAR' to 'BLOB'.
 select cast( col_2 as blob(2 K) ) from blob_table
-	com.ibm.db2.jcc.c.SqlException: Cannot convert types 'VARCHAR' to 'BLOB'.
+	ERROR 42846: Cannot convert types 'VARCHAR' to 'BLOB'.
 select cast( col_3 as blob(2 K) ) from blob_table
-	com.ibm.db2.jcc.c.SqlException: Cannot convert types 'LONG VARCHAR' to 'BLOB'.
+	ERROR 42846: Cannot convert types 'LONG VARCHAR' to 'BLOB'.
 select cast( col_4 as blob(2 K) ) from blob_table
 	---- 1
 	Column    : 1
@@ -2146,17 +2146,17 @@
 	OUT = Object : java.sql.Blob
 -----< type CAST TO types: METADATA TESTS
 select cast( typecol as int ) from blob_table
-	com.ibm.db2.jcc.c.SqlException: Cannot convert types 'BLOB' to 'INTEGER'.
+	ERROR 42846: Cannot convert types 'BLOB' to 'INTEGER'.
 select cast( typecol as char(10) ) from blob_table
-	com.ibm.db2.jcc.c.SqlException: Cannot convert types 'BLOB' to 'CHAR'.
+	ERROR 42846: Cannot convert types 'BLOB' to 'CHAR'.
 select cast( typecol as varchar(80) ) from blob_table
-	com.ibm.db2.jcc.c.SqlException: Cannot convert types 'BLOB' to 'VARCHAR'.
+	ERROR 42846: Cannot convert types 'BLOB' to 'VARCHAR'.
 select cast( typecol as long varchar ) from blob_table
-	com.ibm.db2.jcc.c.SqlException: Cannot convert types 'BLOB' to 'LONG VARCHAR'.
+	ERROR 42846: Cannot convert types 'BLOB' to 'LONG VARCHAR'.
 select cast( typecol as char(10) for bit data ) from blob_table
-	com.ibm.db2.jcc.c.SqlException: Cannot convert types 'BLOB' to 'CHAR () FOR BIT DATA'.
+	ERROR 42846: Cannot convert types 'BLOB' to 'CHAR () FOR BIT DATA'.
 select cast( typecol as long varchar for bit data ) from blob_table
-	com.ibm.db2.jcc.c.SqlException: Cannot convert types 'BLOB' to 'LONG VARCHAR FOR BIT DATA'.
+	ERROR 42846: Cannot convert types 'BLOB' to 'LONG VARCHAR FOR BIT DATA'.
 select cast( typecol as blob(80) ) from blob_table
 	---- 1
 	Column    : 1
@@ -2207,7 +2207,7 @@
 create table blob_table ( dummy int , col_0 int, col_1 char(10), col_2 varchar(80), col_3 long varchar, col_4 char(10) for bit data, col_5 long varchar for bit data, col_6 blob(80), typecol blob (64  ) )
 insert into blob_table values ( 45 ,100,'101','102','103',X'003100300034',X'003100300035',CAST (X'003100300036' AS blob(80)),CAST (X'003100300037' AS blob (64  )) )
 insert into blob_table ( col_0 ) values ( 'true' )
-	com.ibm.db2.jcc.c.SqlException: Columns of type 'INTEGER' cannot hold values of type 'CHAR'. 
+	ERROR 42821: Columns of type 'INTEGER' cannot hold values of type 'CHAR'. 
 insert into blob_table ( col_1 ) values ( 'true' )
 insert into blob_table ( col_2 ) values ( 'true' )
 insert into blob_table ( col_3 ) values ( 'true' )
@@ -2586,13 +2586,13 @@
 	OUT = Object : java.sql.Blob
 -----< columns CAST TO type: METADATA TESTS
 select cast( col_0 as blob(64  ) ) from blob_table
-	com.ibm.db2.jcc.c.SqlException: Cannot convert types 'INTEGER' to 'BLOB'.
+	ERROR 42846: Cannot convert types 'INTEGER' to 'BLOB'.
 select cast( col_1 as blob(64  ) ) from blob_table
-	com.ibm.db2.jcc.c.SqlException: Cannot convert types 'CHAR' to 'BLOB'.
+	ERROR 42846: Cannot convert types 'CHAR' to 'BLOB'.
 select cast( col_2 as blob(64  ) ) from blob_table
-	com.ibm.db2.jcc.c.SqlException: Cannot convert types 'VARCHAR' to 'BLOB'.
+	ERROR 42846: Cannot convert types 'VARCHAR' to 'BLOB'.
 select cast( col_3 as blob(64  ) ) from blob_table
-	com.ibm.db2.jcc.c.SqlException: Cannot convert types 'LONG VARCHAR' to 'BLOB'.
+	ERROR 42846: Cannot convert types 'LONG VARCHAR' to 'BLOB'.
 select cast( col_4 as blob(64  ) ) from blob_table
 	---- 1
 	Column    : 1
@@ -2687,17 +2687,17 @@
 	OUT = Object : java.sql.Blob
 -----< type CAST TO types: METADATA TESTS
 select cast( typecol as int ) from blob_table
-	com.ibm.db2.jcc.c.SqlException: Cannot convert types 'BLOB' to 'INTEGER'.
+	ERROR 42846: Cannot convert types 'BLOB' to 'INTEGER'.
 select cast( typecol as char(10) ) from blob_table
-	com.ibm.db2.jcc.c.SqlException: Cannot convert types 'BLOB' to 'CHAR'.
+	ERROR 42846: Cannot convert types 'BLOB' to 'CHAR'.
 select cast( typecol as varchar(80) ) from blob_table
-	com.ibm.db2.jcc.c.SqlException: Cannot convert types 'BLOB' to 'VARCHAR'.
+	ERROR 42846: Cannot convert types 'BLOB' to 'VARCHAR'.
 select cast( typecol as long varchar ) from blob_table
-	com.ibm.db2.jcc.c.SqlException: Cannot convert types 'BLOB' to 'LONG VARCHAR'.
+	ERROR 42846: Cannot convert types 'BLOB' to 'LONG VARCHAR'.
 select cast( typecol as char(10) for bit data ) from blob_table
-	com.ibm.db2.jcc.c.SqlException: Cannot convert types 'BLOB' to 'CHAR () FOR BIT DATA'.
+	ERROR 42846: Cannot convert types 'BLOB' to 'CHAR () FOR BIT DATA'.
 select cast( typecol as long varchar for bit data ) from blob_table
-	com.ibm.db2.jcc.c.SqlException: Cannot convert types 'BLOB' to 'LONG VARCHAR FOR BIT DATA'.
+	ERROR 42846: Cannot convert types 'BLOB' to 'LONG VARCHAR FOR BIT DATA'.
 select cast( typecol as blob(80) ) from blob_table
 	---- 1
 	Column    : 1
@@ -2747,9 +2747,9 @@
 drop table blob_table
 create table clob_table ( dummy int , col_0 int, col_1 char(10), col_2 varchar(80), col_3 long varchar, col_4 char(10) for bit data, col_5 long varchar for bit data, col_6 blob(80), typecol clob (2 K) )
 insert into clob_table values ( 45 ,100,'101','102','103',X'003100300034',X'003100300035',CAST (X'003100300036' AS blob(80)),CAST (X'003100300037' AS clob (2 K)) )
-	com.ibm.db2.jcc.c.SqlException: Cannot convert types 'CHAR () FOR BIT DATA' to 'CLOB'.
+	ERROR 42846: Cannot convert types 'CHAR () FOR BIT DATA' to 'CLOB'.
 insert into clob_table ( col_0 ) values ( 'true' )
-	com.ibm.db2.jcc.c.SqlException: Columns of type 'INTEGER' cannot hold values of type 'CHAR'. 
+	ERROR 42821: Columns of type 'INTEGER' cannot hold values of type 'CHAR'. 
 insert into clob_table ( col_1 ) values ( 'true' )
 insert into clob_table ( col_2 ) values ( 'true' )
 insert into clob_table ( col_3 ) values ( 'true' )
@@ -2757,7 +2757,7 @@
 insert into clob_table ( col_5 ) values cast ( X'0074007200750065'  AS long varchar for bit data)
 insert into clob_table ( col_6 ) values cast ( X'0074007200750065'  AS blob(80))
 insert into clob_table ( typecol ) values cast ( X'0074007200750065'  AS clob (2 K))
-	com.ibm.db2.jcc.c.SqlException: Cannot convert types 'CHAR () FOR BIT DATA' to 'CLOB'.
+	ERROR 42846: Cannot convert types 'CHAR () FOR BIT DATA' to 'CLOB'.
 === Columntype int
 select col_0 from clob_table
 	0 getObject            ->		EXCEPTION (null)
@@ -3113,7 +3113,7 @@
 	OUT = NULL
 -----< columns CAST TO type: METADATA TESTS
 select cast( col_0 as clob(2 K) ) from clob_table
-	com.ibm.db2.jcc.c.SqlException: Cannot convert types 'INTEGER' to 'CLOB'.
+	ERROR 42846: Cannot convert types 'INTEGER' to 'CLOB'.
 select cast( col_1 as clob(2 K) ) from clob_table
 	---- 1
 	Column    : 1
@@ -3178,11 +3178,11 @@
 	OUT = NULL
 	OUT = NULL
 select cast( col_4 as clob(2 K) ) from clob_table
-	com.ibm.db2.jcc.c.SqlException: Cannot convert types 'CHAR () FOR BIT DATA' to 'CLOB'.
+	ERROR 42846: Cannot convert types 'CHAR () FOR BIT DATA' to 'CLOB'.
 select cast( col_5 as clob(2 K) ) from clob_table
-	com.ibm.db2.jcc.c.SqlException: Cannot convert types 'LONG VARCHAR FOR BIT DATA' to 'CLOB'.
+	ERROR 42846: Cannot convert types 'LONG VARCHAR FOR BIT DATA' to 'CLOB'.
 select cast( col_6 as clob(2 K) ) from clob_table
-	com.ibm.db2.jcc.c.SqlException: Cannot convert types 'BLOB' to 'CLOB'.
+	ERROR 42846: Cannot convert types 'BLOB' to 'CLOB'.
 select cast( typecol as clob(2 K) ) from clob_table
 	---- 1
 	Column    : 1
@@ -3206,7 +3206,7 @@
 	OUT = NULL
 -----< type CAST TO types: METADATA TESTS
 select cast( typecol as int ) from clob_table
-	com.ibm.db2.jcc.c.SqlException: Cannot convert types 'CLOB' to 'INTEGER'.
+	ERROR 42846: Cannot convert types 'CLOB' to 'INTEGER'.
 select cast( typecol as char(10) ) from clob_table
 	---- 1
 	Column    : 1
@@ -3271,11 +3271,11 @@
 	OUT = NULL
 	OUT = NULL
 select cast( typecol as char(10) for bit data ) from clob_table
-	com.ibm.db2.jcc.c.SqlException: Cannot convert types 'CLOB' to 'CHAR () FOR BIT DATA'.
+	ERROR 42846: Cannot convert types 'CLOB' to 'CHAR () FOR BIT DATA'.
 select cast( typecol as long varchar for bit data ) from clob_table
-	com.ibm.db2.jcc.c.SqlException: Cannot convert types 'CLOB' to 'LONG VARCHAR FOR BIT DATA'.
+	ERROR 42846: Cannot convert types 'CLOB' to 'LONG VARCHAR FOR BIT DATA'.
 select cast( typecol as blob(80) ) from clob_table
-	com.ibm.db2.jcc.c.SqlException: Cannot convert types 'CLOB' to 'BLOB'.
+	ERROR 42846: Cannot convert types 'CLOB' to 'BLOB'.
 select cast( typecol as clob (2 K) ) from clob_table
 	---- 1
 	Column    : 1
@@ -3300,9 +3300,9 @@
 drop table clob_table
 create table clob_table ( dummy int , col_0 int, col_1 char(10), col_2 varchar(80), col_3 long varchar, col_4 char(10) for bit data, col_5 long varchar for bit data, col_6 blob(80), typecol clob (64  ) )
 insert into clob_table values ( 45 ,100,'101','102','103',X'003100300034',X'003100300035',CAST (X'003100300036' AS blob(80)),CAST (X'003100300037' AS clob (64  )) )
-	com.ibm.db2.jcc.c.SqlException: Cannot convert types 'CHAR () FOR BIT DATA' to 'CLOB'.
+	ERROR 42846: Cannot convert types 'CHAR () FOR BIT DATA' to 'CLOB'.
 insert into clob_table ( col_0 ) values ( 'true' )
-	com.ibm.db2.jcc.c.SqlException: Columns of type 'INTEGER' cannot hold values of type 'CHAR'. 
+	ERROR 42821: Columns of type 'INTEGER' cannot hold values of type 'CHAR'. 
 insert into clob_table ( col_1 ) values ( 'true' )
 insert into clob_table ( col_2 ) values ( 'true' )
 insert into clob_table ( col_3 ) values ( 'true' )
@@ -3310,7 +3310,7 @@
 insert into clob_table ( col_5 ) values cast ( X'0074007200750065'  AS long varchar for bit data)
 insert into clob_table ( col_6 ) values cast ( X'0074007200750065'  AS blob(80))
 insert into clob_table ( typecol ) values cast ( X'0074007200750065'  AS clob (64  ))
-	com.ibm.db2.jcc.c.SqlException: Cannot convert types 'CHAR () FOR BIT DATA' to 'CLOB'.
+	ERROR 42846: Cannot convert types 'CHAR () FOR BIT DATA' to 'CLOB'.
 === Columntype int
 select col_0 from clob_table
 	0 getObject            ->		EXCEPTION (null)
@@ -3666,7 +3666,7 @@
 	OUT = NULL
 -----< columns CAST TO type: METADATA TESTS
 select cast( col_0 as clob(64  ) ) from clob_table
-	com.ibm.db2.jcc.c.SqlException: Cannot convert types 'INTEGER' to 'CLOB'.
+	ERROR 42846: Cannot convert types 'INTEGER' to 'CLOB'.
 select cast( col_1 as clob(64  ) ) from clob_table
 	---- 1
 	Column    : 1
@@ -3731,11 +3731,11 @@
 	OUT = NULL
 	OUT = NULL
 select cast( col_4 as clob(64  ) ) from clob_table
-	com.ibm.db2.jcc.c.SqlException: Cannot convert types 'CHAR () FOR BIT DATA' to 'CLOB'.
+	ERROR 42846: Cannot convert types 'CHAR () FOR BIT DATA' to 'CLOB'.
 select cast( col_5 as clob(64  ) ) from clob_table
-	com.ibm.db2.jcc.c.SqlException: Cannot convert types 'LONG VARCHAR FOR BIT DATA' to 'CLOB'.
+	ERROR 42846: Cannot convert types 'LONG VARCHAR FOR BIT DATA' to 'CLOB'.
 select cast( col_6 as clob(64  ) ) from clob_table
-	com.ibm.db2.jcc.c.SqlException: Cannot convert types 'BLOB' to 'CLOB'.
+	ERROR 42846: Cannot convert types 'BLOB' to 'CLOB'.
 select cast( typecol as clob(64  ) ) from clob_table
 	---- 1
 	Column    : 1
@@ -3759,7 +3759,7 @@
 	OUT = NULL
 -----< type CAST TO types: METADATA TESTS
 select cast( typecol as int ) from clob_table
-	com.ibm.db2.jcc.c.SqlException: Cannot convert types 'CLOB' to 'INTEGER'.
+	ERROR 42846: Cannot convert types 'CLOB' to 'INTEGER'.
 select cast( typecol as char(10) ) from clob_table
 	---- 1
 	Column    : 1
@@ -3824,11 +3824,11 @@
 	OUT = NULL
 	OUT = NULL
 select cast( typecol as char(10) for bit data ) from clob_table
-	com.ibm.db2.jcc.c.SqlException: Cannot convert types 'CLOB' to 'CHAR () FOR BIT DATA'.
+	ERROR 42846: Cannot convert types 'CLOB' to 'CHAR () FOR BIT DATA'.
 select cast( typecol as long varchar for bit data ) from clob_table
-	com.ibm.db2.jcc.c.SqlException: Cannot convert types 'CLOB' to 'LONG VARCHAR FOR BIT DATA'.
+	ERROR 42846: Cannot convert types 'CLOB' to 'LONG VARCHAR FOR BIT DATA'.
 select cast( typecol as blob(80) ) from clob_table
-	com.ibm.db2.jcc.c.SqlException: Cannot convert types 'CLOB' to 'BLOB'.
+	ERROR 42846: Cannot convert types 'CLOB' to 'BLOB'.
 select cast( typecol as clob (64  ) ) from clob_table
 	---- 1
 	Column    : 1
@@ -3854,20 +3854,20 @@
 -----< BLOB Insertion Tests
 create table blobCheck (bl blob(80)) 
 insert into blobCheck (bl ) values ('string' )
-	com.ibm.db2.jcc.c.SqlException: Columns of type 'BLOB' cannot hold values of type 'CHAR'. 
+	ERROR 42821: Columns of type 'BLOB' cannot hold values of type 'CHAR'. 
 insert into blobCheck (bl ) values (cast (X'0073007400720069006e0067' as blob(80)) )
 insert into blobCheck (bl ) values (X'48' )
-	com.ibm.db2.jcc.c.SqlException: Columns of type 'BLOB' cannot hold values of type 'CHAR () FOR BIT DATA'. 
+	ERROR 42821: Columns of type 'BLOB' cannot hold values of type 'CHAR () FOR BIT DATA'. 
 insert into blobCheck (bl ) values (cast (X'C8' as blob(80)) )
 insert into blobCheck (bl ) values ( X'a78a' )
-	com.ibm.db2.jcc.c.SqlException: Columns of type 'BLOB' cannot hold values of type 'CHAR () FOR BIT DATA'. 
+	ERROR 42821: Columns of type 'BLOB' cannot hold values of type 'CHAR () FOR BIT DATA'. 
 insert into blobCheck (bl ) values (cast (X'a78a' as blob(80)) )
 insert into blobCheck (bl ) values ('string' )
-	com.ibm.db2.jcc.c.SqlException: Columns of type 'BLOB' cannot hold values of type 'CHAR'. 
+	ERROR 42821: Columns of type 'BLOB' cannot hold values of type 'CHAR'. 
 insert into blobCheck (bl ) values (cast (X'0073007400720069006e0067' as blob(80)) )
 insert into blobCheck (bl ) values (X'48' )
-	com.ibm.db2.jcc.c.SqlException: Columns of type 'BLOB' cannot hold values of type 'CHAR () FOR BIT DATA'. 
+	ERROR 42821: Columns of type 'BLOB' cannot hold values of type 'CHAR () FOR BIT DATA'. 
 insert into blobCheck (bl ) values (cast (X'C8' as blob(80)) )
 insert into blobCheck (bl ) values ( X'a78a' )
-	com.ibm.db2.jcc.c.SqlException: Columns of type 'BLOB' cannot hold values of type 'CHAR () FOR BIT DATA'. 
+	ERROR 42821: Columns of type 'BLOB' cannot hold values of type 'CHAR () FOR BIT DATA'. 
 insert into blobCheck (bl ) values (cast (X'a78a' as blob(80)) )

Modified: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/odbc_metadata.out
URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/odbc_metadata.out?view=diff&r1=160465&r2=160466
==============================================================================
--- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/odbc_metadata.out (original)
+++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/odbc_metadata.out Thu Apr  7 13:39:20 2005
@@ -39,7 +39,7 @@
 Column result scale after division is: 23
 dc / 2 = 5.55000000000000000000000
 dc / 2 = 5.55500000000000000000000
-JDBC Driver 'IBM DB2 JDBC Universal Driver Architecture', version 2.4 (2.4.17)
+JDBC Driver 'IBM DB2 JDBC Universal Driver Architecture', version (EXPECTED VERSION)
 The URL is: jdbc:derby:net://localhost:1527/wombat;create=true
 allTablesAreSelectable(): true
 maxColumnNameLength(): 30
@@ -79,7 +79,7 @@
 nullsAreSortedAtEnd(): false
 getDatabaseProductName(): Apache Derby
 getDatabaseProductVersion(): 10.1.0.0 alpha
-getDriverVersion(): 2.4.17
+getDriverVersion(): EXPECTED VERSION
 usesLocalFiles(): true
 usesLocalFilePerTable(): true
 supportsMixedCaseIdentifiers(): false

Modified: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/updatableResultSet.out
URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/updatableResultSet.out?view=diff&r1=160465&r2=160466
==============================================================================
--- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/updatableResultSet.out (original)
+++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/updatableResultSet.out Thu Apr  7 13:39:20 2005
@@ -1,6 +1,6 @@
 Start testing delete and update using JDBC2.0 updateable resultset apis
 Negative Testl - request for scroll insensitive updatable resultset will give a read only scroll insensitive resultset
-warnings on connection = com.ibm.db2.jcc.c.SqlWarning: Insensitive updatable result sets are not supported by server; remapping to insensitive read-only cursor
+WARNING (no SQLState): Insensitive updatable result sets are not supported by server; remapping to insensitive read-only cursor
 requested TYPE_SCROLL_INSENSITIVE, CONCUR_UPDATABLE but that is not supported
 Make sure that we got TYPE_SCROLL_INSENSITIVE? true
 Make sure that we got CONCUR_READ_ONLY? true

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=160465&r2=160466
==============================================================================
--- 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 Thu Apr  7 13:39:20 2005
@@ -1,7 +1,7 @@
 create table bit_table ( dummy int , col_0 int, col_1 char(10), col_2 varchar(80), col_3 long varchar, col_4 char(10) for bit data, col_5 long varchar for bit data, col_6 blob(80), typecol char (8 ) for bit data )
 insert into bit_table values ( 45 ,100,'101','102','103',X'003100300034',X'003100300035',CAST (X'003100300036' AS blob(80)),CAST (X'003100300037' AS char (8 ) for bit data) )
 insert into bit_table ( col_0 ) values ( 'true' )
-	org.apache.derby.client.am.SqlException: Columns of type 'INTEGER' cannot hold values of type 'CHAR'. 
+	ERROR 42821: Columns of type 'INTEGER' cannot hold values of type 'CHAR'. 
 insert into bit_table ( col_1 ) values ( 'true' )
 insert into bit_table ( col_2 ) values ( 'true' )
 insert into bit_table ( col_3 ) values ( 'true' )
@@ -380,13 +380,13 @@
 	OUT = Object : byte[]
 -----< columns CAST TO type: METADATA TESTS
 select cast( col_0 as char (8) for bit data ) from bit_table
-	org.apache.derby.client.am.SqlException: Cannot convert types 'INTEGER' to 'CHAR () FOR BIT DATA'.
+	ERROR 42846: Cannot convert types 'INTEGER' to 'CHAR () FOR BIT DATA'.
 select cast( col_1 as char (8) for bit data ) from bit_table
-	org.apache.derby.client.am.SqlException: Cannot convert types 'CHAR' to 'CHAR () FOR BIT DATA'.
+	ERROR 42846: Cannot convert types 'CHAR' to 'CHAR () FOR BIT DATA'.
 select cast( col_2 as char (8) for bit data ) from bit_table
-	org.apache.derby.client.am.SqlException: Cannot convert types 'VARCHAR' to 'CHAR () FOR BIT DATA'.
+	ERROR 42846: Cannot convert types 'VARCHAR' to 'CHAR () FOR BIT DATA'.
 select cast( col_3 as char (8) for bit data ) from bit_table
-	org.apache.derby.client.am.SqlException: Cannot convert types 'LONG VARCHAR' to 'CHAR () FOR BIT DATA'.
+	ERROR 42846: Cannot convert types 'LONG VARCHAR' to 'CHAR () FOR BIT DATA'.
 select cast( col_4 as char (8) for bit data ) from bit_table
 	---- 1
 	Column    : 1
@@ -434,7 +434,7 @@
 	OUT = NULL
 	OUT = NULL
 select cast( col_6 as char (8) for bit data ) from bit_table
-	org.apache.derby.client.am.SqlException: Cannot convert types 'BLOB' to 'CHAR () FOR BIT DATA'.
+	ERROR 42846: Cannot convert types 'BLOB' to 'CHAR () FOR BIT DATA'.
 select cast( typecol as char (8) for bit data ) from bit_table
 	---- 1
 	Column    : 1
@@ -460,13 +460,13 @@
 	OUT = Object : byte[]
 -----< type CAST TO types: METADATA TESTS
 select cast( typecol as int ) from bit_table
-	org.apache.derby.client.am.SqlException: Cannot convert types 'CHAR () FOR BIT DATA' to 'INTEGER'.
+	ERROR 42846: Cannot convert types 'CHAR () FOR BIT DATA' to 'INTEGER'.
 select cast( typecol as char(10) ) from bit_table
-	org.apache.derby.client.am.SqlException: Cannot convert types 'CHAR () FOR BIT DATA' to 'CHAR'.
+	ERROR 42846: Cannot convert types 'CHAR () FOR BIT DATA' to 'CHAR'.
 select cast( typecol as varchar(80) ) from bit_table
-	org.apache.derby.client.am.SqlException: Cannot convert types 'CHAR () FOR BIT DATA' to 'VARCHAR'.
+	ERROR 42846: Cannot convert types 'CHAR () FOR BIT DATA' to 'VARCHAR'.
 select cast( typecol as long varchar ) from bit_table
-	org.apache.derby.client.am.SqlException: Cannot convert types 'CHAR () FOR BIT DATA' to 'LONG VARCHAR'.
+	ERROR 42846: Cannot convert types 'CHAR () FOR BIT DATA' to 'LONG VARCHAR'.
 select cast( typecol as char(10) for bit data ) from bit_table
 	---- 1
 	Column    : 1
@@ -563,7 +563,7 @@
 create table bit_table ( dummy int , col_0 int, col_1 char(10), col_2 varchar(80), col_3 long varchar, col_4 char(10) for bit data, col_5 long varchar for bit data, col_6 blob(80), typecol char (8 ) for bit data )
 insert into bit_table values ( 45 ,100,'101','102','103',X'003100300034',X'003100300035',CAST (X'003100300036' AS blob(80)),CAST (X'003100300037' AS char (8 ) for bit data) )
 insert into bit_table ( col_0 ) values ( 'true' )
-	org.apache.derby.client.am.SqlException: Columns of type 'INTEGER' cannot hold values of type 'CHAR'. 
+	ERROR 42821: Columns of type 'INTEGER' cannot hold values of type 'CHAR'. 
 insert into bit_table ( col_1 ) values ( 'true' )
 insert into bit_table ( col_2 ) values ( 'true' )
 insert into bit_table ( col_3 ) values ( 'true' )
@@ -942,13 +942,13 @@
 	OUT = Object : byte[]
 -----< columns CAST TO type: METADATA TESTS
 select cast( col_0 as char (8) for bit data ) from bit_table
-	org.apache.derby.client.am.SqlException: Cannot convert types 'INTEGER' to 'CHAR () FOR BIT DATA'.
+	ERROR 42846: Cannot convert types 'INTEGER' to 'CHAR () FOR BIT DATA'.
 select cast( col_1 as char (8) for bit data ) from bit_table
-	org.apache.derby.client.am.SqlException: Cannot convert types 'CHAR' to 'CHAR () FOR BIT DATA'.
+	ERROR 42846: Cannot convert types 'CHAR' to 'CHAR () FOR BIT DATA'.
 select cast( col_2 as char (8) for bit data ) from bit_table
-	org.apache.derby.client.am.SqlException: Cannot convert types 'VARCHAR' to 'CHAR () FOR BIT DATA'.
+	ERROR 42846: Cannot convert types 'VARCHAR' to 'CHAR () FOR BIT DATA'.
 select cast( col_3 as char (8) for bit data ) from bit_table
-	org.apache.derby.client.am.SqlException: Cannot convert types 'LONG VARCHAR' to 'CHAR () FOR BIT DATA'.
+	ERROR 42846: Cannot convert types 'LONG VARCHAR' to 'CHAR () FOR BIT DATA'.
 select cast( col_4 as char (8) for bit data ) from bit_table
 	---- 1
 	Column    : 1
@@ -996,7 +996,7 @@
 	OUT = NULL
 	OUT = NULL
 select cast( col_6 as char (8) for bit data ) from bit_table
-	org.apache.derby.client.am.SqlException: Cannot convert types 'BLOB' to 'CHAR () FOR BIT DATA'.
+	ERROR 42846: Cannot convert types 'BLOB' to 'CHAR () FOR BIT DATA'.
 select cast( typecol as char (8) for bit data ) from bit_table
 	---- 1
 	Column    : 1
@@ -1022,13 +1022,13 @@
 	OUT = Object : byte[]
 -----< type CAST TO types: METADATA TESTS
 select cast( typecol as int ) from bit_table
-	org.apache.derby.client.am.SqlException: Cannot convert types 'CHAR () FOR BIT DATA' to 'INTEGER'.
+	ERROR 42846: Cannot convert types 'CHAR () FOR BIT DATA' to 'INTEGER'.
 select cast( typecol as char(10) ) from bit_table
-	org.apache.derby.client.am.SqlException: Cannot convert types 'CHAR () FOR BIT DATA' to 'CHAR'.
+	ERROR 42846: Cannot convert types 'CHAR () FOR BIT DATA' to 'CHAR'.
 select cast( typecol as varchar(80) ) from bit_table
-	org.apache.derby.client.am.SqlException: Cannot convert types 'CHAR () FOR BIT DATA' to 'VARCHAR'.
+	ERROR 42846: Cannot convert types 'CHAR () FOR BIT DATA' to 'VARCHAR'.
 select cast( typecol as long varchar ) from bit_table
-	org.apache.derby.client.am.SqlException: Cannot convert types 'CHAR () FOR BIT DATA' to 'LONG VARCHAR'.
+	ERROR 42846: Cannot convert types 'CHAR () FOR BIT DATA' to 'LONG VARCHAR'.
 select cast( typecol as char(10) for bit data ) from bit_table
 	---- 1
 	Column    : 1
@@ -1125,7 +1125,7 @@
 create table blob_table ( dummy int , col_0 int, col_1 char(10), col_2 varchar(80), col_3 long varchar, col_4 char(10) for bit data, col_5 long varchar for bit data, col_6 blob(80), typecol blob (2 M) )
 insert into blob_table values ( 45 ,100,'101','102','103',X'003100300034',X'003100300035',CAST (X'003100300036' AS blob(80)),CAST (X'003100300037' AS blob (2 M)) )
 insert into blob_table ( col_0 ) values ( 'true' )
-	org.apache.derby.client.am.SqlException: Columns of type 'INTEGER' cannot hold values of type 'CHAR'. 
+	ERROR 42821: Columns of type 'INTEGER' cannot hold values of type 'CHAR'. 
 insert into blob_table ( col_1 ) values ( 'true' )
 insert into blob_table ( col_2 ) values ( 'true' )
 insert into blob_table ( col_3 ) values ( 'true' )
@@ -1504,13 +1504,13 @@
 	OUT = Object : java.sql.Blob
 -----< columns CAST TO type: METADATA TESTS
 select cast( col_0 as blob(2 M) ) from blob_table
-	org.apache.derby.client.am.SqlException: Cannot convert types 'INTEGER' to 'BLOB'.
+	ERROR 42846: Cannot convert types 'INTEGER' to 'BLOB'.
 select cast( col_1 as blob(2 M) ) from blob_table
-	org.apache.derby.client.am.SqlException: Cannot convert types 'CHAR' to 'BLOB'.
+	ERROR 42846: Cannot convert types 'CHAR' to 'BLOB'.
 select cast( col_2 as blob(2 M) ) from blob_table
-	org.apache.derby.client.am.SqlException: Cannot convert types 'VARCHAR' to 'BLOB'.
+	ERROR 42846: Cannot convert types 'VARCHAR' to 'BLOB'.
 select cast( col_3 as blob(2 M) ) from blob_table
-	org.apache.derby.client.am.SqlException: Cannot convert types 'LONG VARCHAR' to 'BLOB'.
+	ERROR 42846: Cannot convert types 'LONG VARCHAR' to 'BLOB'.
 select cast( col_4 as blob(2 M) ) from blob_table
 	---- 1
 	Column    : 1
@@ -1605,17 +1605,17 @@
 	OUT = Object : java.sql.Blob
 -----< type CAST TO types: METADATA TESTS
 select cast( typecol as int ) from blob_table
-	org.apache.derby.client.am.SqlException: Cannot convert types 'BLOB' to 'INTEGER'.
+	ERROR 42846: Cannot convert types 'BLOB' to 'INTEGER'.
 select cast( typecol as char(10) ) from blob_table
-	org.apache.derby.client.am.SqlException: Cannot convert types 'BLOB' to 'CHAR'.
+	ERROR 42846: Cannot convert types 'BLOB' to 'CHAR'.
 select cast( typecol as varchar(80) ) from blob_table
-	org.apache.derby.client.am.SqlException: Cannot convert types 'BLOB' to 'VARCHAR'.
+	ERROR 42846: Cannot convert types 'BLOB' to 'VARCHAR'.
 select cast( typecol as long varchar ) from blob_table
-	org.apache.derby.client.am.SqlException: Cannot convert types 'BLOB' to 'LONG VARCHAR'.
+	ERROR 42846: Cannot convert types 'BLOB' to 'LONG VARCHAR'.
 select cast( typecol as char(10) for bit data ) from blob_table
-	org.apache.derby.client.am.SqlException: Cannot convert types 'BLOB' to 'CHAR () FOR BIT DATA'.
+	ERROR 42846: Cannot convert types 'BLOB' to 'CHAR () FOR BIT DATA'.
 select cast( typecol as long varchar for bit data ) from blob_table
-	org.apache.derby.client.am.SqlException: Cannot convert types 'BLOB' to 'LONG VARCHAR FOR BIT DATA'.
+	ERROR 42846: Cannot convert types 'BLOB' to 'LONG VARCHAR FOR BIT DATA'.
 select cast( typecol as blob(80) ) from blob_table
 	---- 1
 	Column    : 1
@@ -1666,7 +1666,7 @@
 create table blob_table ( dummy int , col_0 int, col_1 char(10), col_2 varchar(80), col_3 long varchar, col_4 char(10) for bit data, col_5 long varchar for bit data, col_6 blob(80), typecol blob (2 K) )
 insert into blob_table values ( 45 ,100,'101','102','103',X'003100300034',X'003100300035',CAST (X'003100300036' AS blob(80)),CAST (X'003100300037' AS blob (2 K)) )
 insert into blob_table ( col_0 ) values ( 'true' )
-	org.apache.derby.client.am.SqlException: Columns of type 'INTEGER' cannot hold values of type 'CHAR'. 
+	ERROR 42821: Columns of type 'INTEGER' cannot hold values of type 'CHAR'. 
 insert into blob_table ( col_1 ) values ( 'true' )
 insert into blob_table ( col_2 ) values ( 'true' )
 insert into blob_table ( col_3 ) values ( 'true' )
@@ -2045,13 +2045,13 @@
 	OUT = Object : java.sql.Blob
 -----< columns CAST TO type: METADATA TESTS
 select cast( col_0 as blob(2 K) ) from blob_table
-	org.apache.derby.client.am.SqlException: Cannot convert types 'INTEGER' to 'BLOB'.
+	ERROR 42846: Cannot convert types 'INTEGER' to 'BLOB'.
 select cast( col_1 as blob(2 K) ) from blob_table
-	org.apache.derby.client.am.SqlException: Cannot convert types 'CHAR' to 'BLOB'.
+	ERROR 42846: Cannot convert types 'CHAR' to 'BLOB'.
 select cast( col_2 as blob(2 K) ) from blob_table
-	org.apache.derby.client.am.SqlException: Cannot convert types 'VARCHAR' to 'BLOB'.
+	ERROR 42846: Cannot convert types 'VARCHAR' to 'BLOB'.
 select cast( col_3 as blob(2 K) ) from blob_table
-	org.apache.derby.client.am.SqlException: Cannot convert types 'LONG VARCHAR' to 'BLOB'.
+	ERROR 42846: Cannot convert types 'LONG VARCHAR' to 'BLOB'.
 select cast( col_4 as blob(2 K) ) from blob_table
 	---- 1
 	Column    : 1
@@ -2146,17 +2146,17 @@
 	OUT = Object : java.sql.Blob
 -----< type CAST TO types: METADATA TESTS
 select cast( typecol as int ) from blob_table
-	org.apache.derby.client.am.SqlException: Cannot convert types 'BLOB' to 'INTEGER'.
+	ERROR 42846: Cannot convert types 'BLOB' to 'INTEGER'.
 select cast( typecol as char(10) ) from blob_table
-	org.apache.derby.client.am.SqlException: Cannot convert types 'BLOB' to 'CHAR'.
+	ERROR 42846: Cannot convert types 'BLOB' to 'CHAR'.
 select cast( typecol as varchar(80) ) from blob_table
-	org.apache.derby.client.am.SqlException: Cannot convert types 'BLOB' to 'VARCHAR'.
+	ERROR 42846: Cannot convert types 'BLOB' to 'VARCHAR'.
 select cast( typecol as long varchar ) from blob_table
-	org.apache.derby.client.am.SqlException: Cannot convert types 'BLOB' to 'LONG VARCHAR'.
+	ERROR 42846: Cannot convert types 'BLOB' to 'LONG VARCHAR'.
 select cast( typecol as char(10) for bit data ) from blob_table
-	org.apache.derby.client.am.SqlException: Cannot convert types 'BLOB' to 'CHAR () FOR BIT DATA'.
+	ERROR 42846: Cannot convert types 'BLOB' to 'CHAR () FOR BIT DATA'.
 select cast( typecol as long varchar for bit data ) from blob_table
-	org.apache.derby.client.am.SqlException: Cannot convert types 'BLOB' to 'LONG VARCHAR FOR BIT DATA'.
+	ERROR 42846: Cannot convert types 'BLOB' to 'LONG VARCHAR FOR BIT DATA'.
 select cast( typecol as blob(80) ) from blob_table
 	---- 1
 	Column    : 1
@@ -2207,7 +2207,7 @@
 create table blob_table ( dummy int , col_0 int, col_1 char(10), col_2 varchar(80), col_3 long varchar, col_4 char(10) for bit data, col_5 long varchar for bit data, col_6 blob(80), typecol blob (64  ) )
 insert into blob_table values ( 45 ,100,'101','102','103',X'003100300034',X'003100300035',CAST (X'003100300036' AS blob(80)),CAST (X'003100300037' AS blob (64  )) )
 insert into blob_table ( col_0 ) values ( 'true' )
-	org.apache.derby.client.am.SqlException: Columns of type 'INTEGER' cannot hold values of type 'CHAR'. 
+	ERROR 42821: Columns of type 'INTEGER' cannot hold values of type 'CHAR'. 
 insert into blob_table ( col_1 ) values ( 'true' )
 insert into blob_table ( col_2 ) values ( 'true' )
 insert into blob_table ( col_3 ) values ( 'true' )
@@ -2586,13 +2586,13 @@
 	OUT = Object : java.sql.Blob
 -----< columns CAST TO type: METADATA TESTS
 select cast( col_0 as blob(64  ) ) from blob_table
-	org.apache.derby.client.am.SqlException: Cannot convert types 'INTEGER' to 'BLOB'.
+	ERROR 42846: Cannot convert types 'INTEGER' to 'BLOB'.
 select cast( col_1 as blob(64  ) ) from blob_table
-	org.apache.derby.client.am.SqlException: Cannot convert types 'CHAR' to 'BLOB'.
+	ERROR 42846: Cannot convert types 'CHAR' to 'BLOB'.
 select cast( col_2 as blob(64  ) ) from blob_table
-	org.apache.derby.client.am.SqlException: Cannot convert types 'VARCHAR' to 'BLOB'.
+	ERROR 42846: Cannot convert types 'VARCHAR' to 'BLOB'.
 select cast( col_3 as blob(64  ) ) from blob_table
-	org.apache.derby.client.am.SqlException: Cannot convert types 'LONG VARCHAR' to 'BLOB'.
+	ERROR 42846: Cannot convert types 'LONG VARCHAR' to 'BLOB'.
 select cast( col_4 as blob(64  ) ) from blob_table
 	---- 1
 	Column    : 1
@@ -2687,17 +2687,17 @@
 	OUT = Object : java.sql.Blob
 -----< type CAST TO types: METADATA TESTS
 select cast( typecol as int ) from blob_table
-	org.apache.derby.client.am.SqlException: Cannot convert types 'BLOB' to 'INTEGER'.
+	ERROR 42846: Cannot convert types 'BLOB' to 'INTEGER'.
 select cast( typecol as char(10) ) from blob_table
-	org.apache.derby.client.am.SqlException: Cannot convert types 'BLOB' to 'CHAR'.
+	ERROR 42846: Cannot convert types 'BLOB' to 'CHAR'.
 select cast( typecol as varchar(80) ) from blob_table
-	org.apache.derby.client.am.SqlException: Cannot convert types 'BLOB' to 'VARCHAR'.
+	ERROR 42846: Cannot convert types 'BLOB' to 'VARCHAR'.
 select cast( typecol as long varchar ) from blob_table
-	org.apache.derby.client.am.SqlException: Cannot convert types 'BLOB' to 'LONG VARCHAR'.
+	ERROR 42846: Cannot convert types 'BLOB' to 'LONG VARCHAR'.
 select cast( typecol as char(10) for bit data ) from blob_table
-	org.apache.derby.client.am.SqlException: Cannot convert types 'BLOB' to 'CHAR () FOR BIT DATA'.
+	ERROR 42846: Cannot convert types 'BLOB' to 'CHAR () FOR BIT DATA'.
 select cast( typecol as long varchar for bit data ) from blob_table
-	org.apache.derby.client.am.SqlException: Cannot convert types 'BLOB' to 'LONG VARCHAR FOR BIT DATA'.
+	ERROR 42846: Cannot convert types 'BLOB' to 'LONG VARCHAR FOR BIT DATA'.
 select cast( typecol as blob(80) ) from blob_table
 	---- 1
 	Column    : 1
@@ -2747,9 +2747,9 @@
 drop table blob_table
 create table clob_table ( dummy int , col_0 int, col_1 char(10), col_2 varchar(80), col_3 long varchar, col_4 char(10) for bit data, col_5 long varchar for bit data, col_6 blob(80), typecol clob (2 K) )
 insert into clob_table values ( 45 ,100,'101','102','103',X'003100300034',X'003100300035',CAST (X'003100300036' AS blob(80)),CAST (X'003100300037' AS clob (2 K)) )
-	org.apache.derby.client.am.SqlException: Cannot convert types 'CHAR () FOR BIT DATA' to 'CLOB'.
+	ERROR 42846: Cannot convert types 'CHAR () FOR BIT DATA' to 'CLOB'.
 insert into clob_table ( col_0 ) values ( 'true' )
-	org.apache.derby.client.am.SqlException: Columns of type 'INTEGER' cannot hold values of type 'CHAR'. 
+	ERROR 42821: Columns of type 'INTEGER' cannot hold values of type 'CHAR'. 
 insert into clob_table ( col_1 ) values ( 'true' )
 insert into clob_table ( col_2 ) values ( 'true' )
 insert into clob_table ( col_3 ) values ( 'true' )
@@ -2757,7 +2757,7 @@
 insert into clob_table ( col_5 ) values cast ( X'0074007200750065'  AS long varchar for bit data)
 insert into clob_table ( col_6 ) values cast ( X'0074007200750065'  AS blob(80))
 insert into clob_table ( typecol ) values cast ( X'0074007200750065'  AS clob (2 K))
-	org.apache.derby.client.am.SqlException: Cannot convert types 'CHAR () FOR BIT DATA' to 'CLOB'.
+	ERROR 42846: Cannot convert types 'CHAR () FOR BIT DATA' to 'CLOB'.
 === Columntype int
 select col_0 from clob_table
 	0 getObject            ->		EXCEPTION (null)
@@ -3113,7 +3113,7 @@
 	OUT = NULL
 -----< columns CAST TO type: METADATA TESTS
 select cast( col_0 as clob(2 K) ) from clob_table
-	org.apache.derby.client.am.SqlException: Cannot convert types 'INTEGER' to 'CLOB'.
+	ERROR 42846: Cannot convert types 'INTEGER' to 'CLOB'.
 select cast( col_1 as clob(2 K) ) from clob_table
 	---- 1
 	Column    : 1
@@ -3178,11 +3178,11 @@
 	OUT = NULL
 	OUT = NULL
 select cast( col_4 as clob(2 K) ) from clob_table
-	org.apache.derby.client.am.SqlException: Cannot convert types 'CHAR () FOR BIT DATA' to 'CLOB'.
+	ERROR 42846: Cannot convert types 'CHAR () FOR BIT DATA' to 'CLOB'.
 select cast( col_5 as clob(2 K) ) from clob_table
-	org.apache.derby.client.am.SqlException: Cannot convert types 'LONG VARCHAR FOR BIT DATA' to 'CLOB'.
+	ERROR 42846: Cannot convert types 'LONG VARCHAR FOR BIT DATA' to 'CLOB'.
 select cast( col_6 as clob(2 K) ) from clob_table
-	org.apache.derby.client.am.SqlException: Cannot convert types 'BLOB' to 'CLOB'.
+	ERROR 42846: Cannot convert types 'BLOB' to 'CLOB'.
 select cast( typecol as clob(2 K) ) from clob_table
 	---- 1
 	Column    : 1
@@ -3206,7 +3206,7 @@
 	OUT = NULL
 -----< type CAST TO types: METADATA TESTS
 select cast( typecol as int ) from clob_table
-	org.apache.derby.client.am.SqlException: Cannot convert types 'CLOB' to 'INTEGER'.
+	ERROR 42846: Cannot convert types 'CLOB' to 'INTEGER'.
 select cast( typecol as char(10) ) from clob_table
 	---- 1
 	Column    : 1
@@ -3271,11 +3271,11 @@
 	OUT = NULL
 	OUT = NULL
 select cast( typecol as char(10) for bit data ) from clob_table
-	org.apache.derby.client.am.SqlException: Cannot convert types 'CLOB' to 'CHAR () FOR BIT DATA'.
+	ERROR 42846: Cannot convert types 'CLOB' to 'CHAR () FOR BIT DATA'.
 select cast( typecol as long varchar for bit data ) from clob_table
-	org.apache.derby.client.am.SqlException: Cannot convert types 'CLOB' to 'LONG VARCHAR FOR BIT DATA'.
+	ERROR 42846: Cannot convert types 'CLOB' to 'LONG VARCHAR FOR BIT DATA'.
 select cast( typecol as blob(80) ) from clob_table
-	org.apache.derby.client.am.SqlException: Cannot convert types 'CLOB' to 'BLOB'.
+	ERROR 42846: Cannot convert types 'CLOB' to 'BLOB'.
 select cast( typecol as clob (2 K) ) from clob_table
 	---- 1
 	Column    : 1
@@ -3300,9 +3300,9 @@
 drop table clob_table
 create table clob_table ( dummy int , col_0 int, col_1 char(10), col_2 varchar(80), col_3 long varchar, col_4 char(10) for bit data, col_5 long varchar for bit data, col_6 blob(80), typecol clob (64  ) )
 insert into clob_table values ( 45 ,100,'101','102','103',X'003100300034',X'003100300035',CAST (X'003100300036' AS blob(80)),CAST (X'003100300037' AS clob (64  )) )
-	org.apache.derby.client.am.SqlException: Cannot convert types 'CHAR () FOR BIT DATA' to 'CLOB'.
+	ERROR 42846: Cannot convert types 'CHAR () FOR BIT DATA' to 'CLOB'.
 insert into clob_table ( col_0 ) values ( 'true' )
-	org.apache.derby.client.am.SqlException: Columns of type 'INTEGER' cannot hold values of type 'CHAR'. 
+	ERROR 42821: Columns of type 'INTEGER' cannot hold values of type 'CHAR'. 
 insert into clob_table ( col_1 ) values ( 'true' )
 insert into clob_table ( col_2 ) values ( 'true' )
 insert into clob_table ( col_3 ) values ( 'true' )
@@ -3310,7 +3310,7 @@
 insert into clob_table ( col_5 ) values cast ( X'0074007200750065'  AS long varchar for bit data)
 insert into clob_table ( col_6 ) values cast ( X'0074007200750065'  AS blob(80))
 insert into clob_table ( typecol ) values cast ( X'0074007200750065'  AS clob (64  ))
-	org.apache.derby.client.am.SqlException: Cannot convert types 'CHAR () FOR BIT DATA' to 'CLOB'.
+	ERROR 42846: Cannot convert types 'CHAR () FOR BIT DATA' to 'CLOB'.
 === Columntype int
 select col_0 from clob_table
 	0 getObject            ->		EXCEPTION (null)
@@ -3666,7 +3666,7 @@
 	OUT = NULL
 -----< columns CAST TO type: METADATA TESTS
 select cast( col_0 as clob(64  ) ) from clob_table
-	org.apache.derby.client.am.SqlException: Cannot convert types 'INTEGER' to 'CLOB'.
+	ERROR 42846: Cannot convert types 'INTEGER' to 'CLOB'.
 select cast( col_1 as clob(64  ) ) from clob_table
 	---- 1
 	Column    : 1
@@ -3731,11 +3731,11 @@
 	OUT = NULL
 	OUT = NULL
 select cast( col_4 as clob(64  ) ) from clob_table
-	org.apache.derby.client.am.SqlException: Cannot convert types 'CHAR () FOR BIT DATA' to 'CLOB'.
+	ERROR 42846: Cannot convert types 'CHAR () FOR BIT DATA' to 'CLOB'.
 select cast( col_5 as clob(64  ) ) from clob_table
-	org.apache.derby.client.am.SqlException: Cannot convert types 'LONG VARCHAR FOR BIT DATA' to 'CLOB'.
+	ERROR 42846: Cannot convert types 'LONG VARCHAR FOR BIT DATA' to 'CLOB'.
 select cast( col_6 as clob(64  ) ) from clob_table
-	org.apache.derby.client.am.SqlException: Cannot convert types 'BLOB' to 'CLOB'.
+	ERROR 42846: Cannot convert types 'BLOB' to 'CLOB'.
 select cast( typecol as clob(64  ) ) from clob_table
 	---- 1
 	Column    : 1
@@ -3759,7 +3759,7 @@
 	OUT = NULL
 -----< type CAST TO types: METADATA TESTS
 select cast( typecol as int ) from clob_table
-	org.apache.derby.client.am.SqlException: Cannot convert types 'CLOB' to 'INTEGER'.
+	ERROR 42846: Cannot convert types 'CLOB' to 'INTEGER'.
 select cast( typecol as char(10) ) from clob_table
 	---- 1
 	Column    : 1
@@ -3824,11 +3824,11 @@
 	OUT = NULL
 	OUT = NULL
 select cast( typecol as char(10) for bit data ) from clob_table
-	org.apache.derby.client.am.SqlException: Cannot convert types 'CLOB' to 'CHAR () FOR BIT DATA'.
+	ERROR 42846: Cannot convert types 'CLOB' to 'CHAR () FOR BIT DATA'.
 select cast( typecol as long varchar for bit data ) from clob_table
-	org.apache.derby.client.am.SqlException: Cannot convert types 'CLOB' to 'LONG VARCHAR FOR BIT DATA'.
+	ERROR 42846: Cannot convert types 'CLOB' to 'LONG VARCHAR FOR BIT DATA'.
 select cast( typecol as blob(80) ) from clob_table
-	org.apache.derby.client.am.SqlException: Cannot convert types 'CLOB' to 'BLOB'.
+	ERROR 42846: Cannot convert types 'CLOB' to 'BLOB'.
 select cast( typecol as clob (64  ) ) from clob_table
 	---- 1
 	Column    : 1
@@ -3854,20 +3854,20 @@
 -----< BLOB Insertion Tests
 create table blobCheck (bl blob(80)) 
 insert into blobCheck (bl ) values ('string' )
-	org.apache.derby.client.am.SqlException: Columns of type 'BLOB' cannot hold values of type 'CHAR'. 
+	ERROR 42821: Columns of type 'BLOB' cannot hold values of type 'CHAR'. 
 insert into blobCheck (bl ) values (cast (X'0073007400720069006e0067' as blob(80)) )
 insert into blobCheck (bl ) values (X'48' )
-	org.apache.derby.client.am.SqlException: Columns of type 'BLOB' cannot hold values of type 'CHAR () FOR BIT DATA'. 
+	ERROR 42821: Columns of type 'BLOB' cannot hold values of type 'CHAR () FOR BIT DATA'. 
 insert into blobCheck (bl ) values (cast (X'C8' as blob(80)) )
 insert into blobCheck (bl ) values ( X'a78a' )
-	org.apache.derby.client.am.SqlException: Columns of type 'BLOB' cannot hold values of type 'CHAR () FOR BIT DATA'. 
+	ERROR 42821: Columns of type 'BLOB' cannot hold values of type 'CHAR () FOR BIT DATA'. 
 insert into blobCheck (bl ) values (cast (X'a78a' as blob(80)) )
 insert into blobCheck (bl ) values ('string' )
-	org.apache.derby.client.am.SqlException: Columns of type 'BLOB' cannot hold values of type 'CHAR'. 
+	ERROR 42821: Columns of type 'BLOB' cannot hold values of type 'CHAR'. 
 insert into blobCheck (bl ) values (cast (X'0073007400720069006e0067' as blob(80)) )
 insert into blobCheck (bl ) values (X'48' )
-	org.apache.derby.client.am.SqlException: Columns of type 'BLOB' cannot hold values of type 'CHAR () FOR BIT DATA'. 
+	ERROR 42821: Columns of type 'BLOB' cannot hold values of type 'CHAR () FOR BIT DATA'. 
 insert into blobCheck (bl ) values (cast (X'C8' as blob(80)) )
 insert into blobCheck (bl ) values ( X'a78a' )
-	org.apache.derby.client.am.SqlException: Columns of type 'BLOB' cannot hold values of type 'CHAR () FOR BIT DATA'. 
+	ERROR 42821: Columns of type 'BLOB' cannot hold values of type 'CHAR () FOR BIT DATA'. 
 insert into blobCheck (bl ) values (cast (X'a78a' as blob(80)) )

Modified: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/updatableResultSet.out
URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/updatableResultSet.out?view=diff&r1=160465&r2=160466
==============================================================================
--- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/updatableResultSet.out (original)
+++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/updatableResultSet.out Thu Apr  7 13:39:20 2005
@@ -1,6 +1,6 @@
 Start testing delete and update using JDBC2.0 updateable resultset apis
 Negative Testl - request for scroll insensitive updatable resultset will give a read only scroll insensitive resultset
-warnings on connection = org.apache.derby.client.am.SqlWarning: Insensitive updatable result sets are not supported by server; remapping to insensitive read-only cursor
+WARNING (no SQLState): Insensitive updatable result sets are not supported by server; remapping to insensitive read-only cursor
 requested TYPE_SCROLL_INSENSITIVE, CONCUR_UPDATABLE but that is not supported
 Make sure that we got TYPE_SCROLL_INSENSITIVE? true
 Make sure that we got CONCUR_READ_ONLY? true

Modified: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/LOBTest.out
URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/LOBTest.out?view=diff&r1=160465&r2=160466
==============================================================================
--- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/LOBTest.out (original)
+++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/LOBTest.out Thu Apr  7 13:39:20 2005
@@ -1,7 +1,7 @@
 create table bit_table ( dummy int , col_0 int, col_1 char(10), col_2 varchar(80), col_3 long varchar, col_4 char(10) for bit data, col_5 long varchar for bit data, col_6 blob(80), typecol char (8 ) for bit data )
 insert into bit_table values ( 45 ,100,'101','102','103',X'003100300034',X'003100300035',CAST (X'003100300036' AS blob(80)),CAST (X'003100300037' AS char (8 ) for bit data) )
 insert into bit_table ( col_0 ) values ( 'true' )
-	SQL Exception: Columns of type 'INTEGER' cannot hold values of type 'CHAR'. 
+	ERROR 42821: Columns of type 'INTEGER' cannot hold values of type 'CHAR'. 
 insert into bit_table ( col_1 ) values ( 'true' )
 insert into bit_table ( col_2 ) values ( 'true' )
 insert into bit_table ( col_3 ) values ( 'true' )
@@ -380,13 +380,13 @@
 	OUT = Object : byte[]
 ---< columns CAST TO type: METADATA TESTS
 select cast( col_0 as char (8) for bit data ) from bit_table
-	SQL Exception: Cannot convert types 'INTEGER' to 'CHAR () FOR BIT DATA'.
+	ERROR 42846: Cannot convert types 'INTEGER' to 'CHAR () FOR BIT DATA'.
 select cast( col_1 as char (8) for bit data ) from bit_table
-	SQL Exception: Cannot convert types 'CHAR' to 'CHAR () FOR BIT DATA'.
+	ERROR 42846: Cannot convert types 'CHAR' to 'CHAR () FOR BIT DATA'.
 select cast( col_2 as char (8) for bit data ) from bit_table
-	SQL Exception: Cannot convert types 'VARCHAR' to 'CHAR () FOR BIT DATA'.
+	ERROR 42846: Cannot convert types 'VARCHAR' to 'CHAR () FOR BIT DATA'.
 select cast( col_3 as char (8) for bit data ) from bit_table
-	SQL Exception: Cannot convert types 'LONG VARCHAR' to 'CHAR () FOR BIT DATA'.
+	ERROR 42846: Cannot convert types 'LONG VARCHAR' to 'CHAR () FOR BIT DATA'.
 select cast( col_4 as char (8) for bit data ) from bit_table
 	---- 1
 	Column    : 1
@@ -434,7 +434,7 @@
 	OUT = NULL
 	OUT = NULL
 select cast( col_6 as char (8) for bit data ) from bit_table
-	SQL Exception: Cannot convert types 'BLOB' to 'CHAR () FOR BIT DATA'.
+	ERROR 42846: Cannot convert types 'BLOB' to 'CHAR () FOR BIT DATA'.
 select cast( typecol as char (8) for bit data ) from bit_table
 	---- 1
 	Column    : 1
@@ -460,13 +460,13 @@
 	OUT = Object : byte[]
 ---< type CAST TO types: METADATA TESTS
 select cast( typecol as int ) from bit_table
-	SQL Exception: Cannot convert types 'CHAR () FOR BIT DATA' to 'INTEGER'.
+	ERROR 42846: Cannot convert types 'CHAR () FOR BIT DATA' to 'INTEGER'.
 select cast( typecol as char(10) ) from bit_table
-	SQL Exception: Cannot convert types 'CHAR () FOR BIT DATA' to 'CHAR'.
+	ERROR 42846: Cannot convert types 'CHAR () FOR BIT DATA' to 'CHAR'.
 select cast( typecol as varchar(80) ) from bit_table
-	SQL Exception: Cannot convert types 'CHAR () FOR BIT DATA' to 'VARCHAR'.
+	ERROR 42846: Cannot convert types 'CHAR () FOR BIT DATA' to 'VARCHAR'.
 select cast( typecol as long varchar ) from bit_table
-	SQL Exception: Cannot convert types 'CHAR () FOR BIT DATA' to 'LONG VARCHAR'.
+	ERROR 42846: Cannot convert types 'CHAR () FOR BIT DATA' to 'LONG VARCHAR'.
 select cast( typecol as char(10) for bit data ) from bit_table
 	---- 1
 	Column    : 1
@@ -563,7 +563,7 @@
 create table bit_table ( dummy int , col_0 int, col_1 char(10), col_2 varchar(80), col_3 long varchar, col_4 char(10) for bit data, col_5 long varchar for bit data, col_6 blob(80), typecol char (8 ) for bit data )
 insert into bit_table values ( 45 ,100,'101','102','103',X'003100300034',X'003100300035',CAST (X'003100300036' AS blob(80)),CAST (X'003100300037' AS char (8 ) for bit data) )
 insert into bit_table ( col_0 ) values ( 'true' )
-	SQL Exception: Columns of type 'INTEGER' cannot hold values of type 'CHAR'. 
+	ERROR 42821: Columns of type 'INTEGER' cannot hold values of type 'CHAR'. 
 insert into bit_table ( col_1 ) values ( 'true' )
 insert into bit_table ( col_2 ) values ( 'true' )
 insert into bit_table ( col_3 ) values ( 'true' )
@@ -942,13 +942,13 @@
 	OUT = Object : byte[]
 ---< columns CAST TO type: METADATA TESTS
 select cast( col_0 as char (8) for bit data ) from bit_table
-	SQL Exception: Cannot convert types 'INTEGER' to 'CHAR () FOR BIT DATA'.
+	ERROR 42846: Cannot convert types 'INTEGER' to 'CHAR () FOR BIT DATA'.
 select cast( col_1 as char (8) for bit data ) from bit_table
-	SQL Exception: Cannot convert types 'CHAR' to 'CHAR () FOR BIT DATA'.
+	ERROR 42846: Cannot convert types 'CHAR' to 'CHAR () FOR BIT DATA'.
 select cast( col_2 as char (8) for bit data ) from bit_table
-	SQL Exception: Cannot convert types 'VARCHAR' to 'CHAR () FOR BIT DATA'.
+	ERROR 42846: Cannot convert types 'VARCHAR' to 'CHAR () FOR BIT DATA'.
 select cast( col_3 as char (8) for bit data ) from bit_table
-	SQL Exception: Cannot convert types 'LONG VARCHAR' to 'CHAR () FOR BIT DATA'.
+	ERROR 42846: Cannot convert types 'LONG VARCHAR' to 'CHAR () FOR BIT DATA'.
 select cast( col_4 as char (8) for bit data ) from bit_table
 	---- 1
 	Column    : 1
@@ -996,7 +996,7 @@
 	OUT = NULL
 	OUT = NULL
 select cast( col_6 as char (8) for bit data ) from bit_table
-	SQL Exception: Cannot convert types 'BLOB' to 'CHAR () FOR BIT DATA'.
+	ERROR 42846: Cannot convert types 'BLOB' to 'CHAR () FOR BIT DATA'.
 select cast( typecol as char (8) for bit data ) from bit_table
 	---- 1
 	Column    : 1
@@ -1022,13 +1022,13 @@
 	OUT = Object : byte[]
 ---< type CAST TO types: METADATA TESTS
 select cast( typecol as int ) from bit_table
-	SQL Exception: Cannot convert types 'CHAR () FOR BIT DATA' to 'INTEGER'.
+	ERROR 42846: Cannot convert types 'CHAR () FOR BIT DATA' to 'INTEGER'.
 select cast( typecol as char(10) ) from bit_table
-	SQL Exception: Cannot convert types 'CHAR () FOR BIT DATA' to 'CHAR'.
+	ERROR 42846: Cannot convert types 'CHAR () FOR BIT DATA' to 'CHAR'.
 select cast( typecol as varchar(80) ) from bit_table
-	SQL Exception: Cannot convert types 'CHAR () FOR BIT DATA' to 'VARCHAR'.
+	ERROR 42846: Cannot convert types 'CHAR () FOR BIT DATA' to 'VARCHAR'.
 select cast( typecol as long varchar ) from bit_table
-	SQL Exception: Cannot convert types 'CHAR () FOR BIT DATA' to 'LONG VARCHAR'.
+	ERROR 42846: Cannot convert types 'CHAR () FOR BIT DATA' to 'LONG VARCHAR'.
 select cast( typecol as char(10) for bit data ) from bit_table
 	---- 1
 	Column    : 1
@@ -1125,7 +1125,7 @@
 create table blob_table ( dummy int , col_0 int, col_1 char(10), col_2 varchar(80), col_3 long varchar, col_4 char(10) for bit data, col_5 long varchar for bit data, col_6 blob(80), typecol blob (2 M) )
 insert into blob_table values ( 45 ,100,'101','102','103',X'003100300034',X'003100300035',CAST (X'003100300036' AS blob(80)),CAST (X'003100300037' AS blob (2 M)) )
 insert into blob_table ( col_0 ) values ( 'true' )
-	SQL Exception: Columns of type 'INTEGER' cannot hold values of type 'CHAR'. 
+	ERROR 42821: Columns of type 'INTEGER' cannot hold values of type 'CHAR'. 
 insert into blob_table ( col_1 ) values ( 'true' )
 insert into blob_table ( col_2 ) values ( 'true' )
 insert into blob_table ( col_3 ) values ( 'true' )
@@ -1504,13 +1504,13 @@
 	OUT = Object : java.sql.Blob
 ---< columns CAST TO type: METADATA TESTS
 select cast( col_0 as blob(2 M) ) from blob_table
-	SQL Exception: Cannot convert types 'INTEGER' to 'BLOB'.
+	ERROR 42846: Cannot convert types 'INTEGER' to 'BLOB'.
 select cast( col_1 as blob(2 M) ) from blob_table
-	SQL Exception: Cannot convert types 'CHAR' to 'BLOB'.
+	ERROR 42846: Cannot convert types 'CHAR' to 'BLOB'.
 select cast( col_2 as blob(2 M) ) from blob_table
-	SQL Exception: Cannot convert types 'VARCHAR' to 'BLOB'.
+	ERROR 42846: Cannot convert types 'VARCHAR' to 'BLOB'.
 select cast( col_3 as blob(2 M) ) from blob_table
-	SQL Exception: Cannot convert types 'LONG VARCHAR' to 'BLOB'.
+	ERROR 42846: Cannot convert types 'LONG VARCHAR' to 'BLOB'.
 select cast( col_4 as blob(2 M) ) from blob_table
 	---- 1
 	Column    : 1
@@ -1605,17 +1605,17 @@
 	OUT = Object : java.sql.Blob
 ---< type CAST TO types: METADATA TESTS
 select cast( typecol as int ) from blob_table
-	SQL Exception: Cannot convert types 'BLOB' to 'INTEGER'.
+	ERROR 42846: Cannot convert types 'BLOB' to 'INTEGER'.
 select cast( typecol as char(10) ) from blob_table
-	SQL Exception: Cannot convert types 'BLOB' to 'CHAR'.
+	ERROR 42846: Cannot convert types 'BLOB' to 'CHAR'.
 select cast( typecol as varchar(80) ) from blob_table
-	SQL Exception: Cannot convert types 'BLOB' to 'VARCHAR'.
+	ERROR 42846: Cannot convert types 'BLOB' to 'VARCHAR'.
 select cast( typecol as long varchar ) from blob_table
-	SQL Exception: Cannot convert types 'BLOB' to 'LONG VARCHAR'.
+	ERROR 42846: Cannot convert types 'BLOB' to 'LONG VARCHAR'.
 select cast( typecol as char(10) for bit data ) from blob_table
-	SQL Exception: Cannot convert types 'BLOB' to 'CHAR () FOR BIT DATA'.
+	ERROR 42846: Cannot convert types 'BLOB' to 'CHAR () FOR BIT DATA'.
 select cast( typecol as long varchar for bit data ) from blob_table
-	SQL Exception: Cannot convert types 'BLOB' to 'LONG VARCHAR FOR BIT DATA'.
+	ERROR 42846: Cannot convert types 'BLOB' to 'LONG VARCHAR FOR BIT DATA'.
 select cast( typecol as blob(80) ) from blob_table
 	---- 1
 	Column    : 1
@@ -1666,7 +1666,7 @@
 create table blob_table ( dummy int , col_0 int, col_1 char(10), col_2 varchar(80), col_3 long varchar, col_4 char(10) for bit data, col_5 long varchar for bit data, col_6 blob(80), typecol blob (2 K) )
 insert into blob_table values ( 45 ,100,'101','102','103',X'003100300034',X'003100300035',CAST (X'003100300036' AS blob(80)),CAST (X'003100300037' AS blob (2 K)) )
 insert into blob_table ( col_0 ) values ( 'true' )
-	SQL Exception: Columns of type 'INTEGER' cannot hold values of type 'CHAR'. 
+	ERROR 42821: Columns of type 'INTEGER' cannot hold values of type 'CHAR'. 
 insert into blob_table ( col_1 ) values ( 'true' )
 insert into blob_table ( col_2 ) values ( 'true' )
 insert into blob_table ( col_3 ) values ( 'true' )
@@ -2045,13 +2045,13 @@
 	OUT = Object : java.sql.Blob
 ---< columns CAST TO type: METADATA TESTS
 select cast( col_0 as blob(2 K) ) from blob_table
-	SQL Exception: Cannot convert types 'INTEGER' to 'BLOB'.
+	ERROR 42846: Cannot convert types 'INTEGER' to 'BLOB'.
 select cast( col_1 as blob(2 K) ) from blob_table
-	SQL Exception: Cannot convert types 'CHAR' to 'BLOB'.
+	ERROR 42846: Cannot convert types 'CHAR' to 'BLOB'.
 select cast( col_2 as blob(2 K) ) from blob_table
-	SQL Exception: Cannot convert types 'VARCHAR' to 'BLOB'.
+	ERROR 42846: Cannot convert types 'VARCHAR' to 'BLOB'.
 select cast( col_3 as blob(2 K) ) from blob_table
-	SQL Exception: Cannot convert types 'LONG VARCHAR' to 'BLOB'.
+	ERROR 42846: Cannot convert types 'LONG VARCHAR' to 'BLOB'.
 select cast( col_4 as blob(2 K) ) from blob_table
 	---- 1
 	Column    : 1
@@ -2146,17 +2146,17 @@
 	OUT = Object : java.sql.Blob
 ---< type CAST TO types: METADATA TESTS
 select cast( typecol as int ) from blob_table
-	SQL Exception: Cannot convert types 'BLOB' to 'INTEGER'.
+	ERROR 42846: Cannot convert types 'BLOB' to 'INTEGER'.
 select cast( typecol as char(10) ) from blob_table
-	SQL Exception: Cannot convert types 'BLOB' to 'CHAR'.
+	ERROR 42846: Cannot convert types 'BLOB' to 'CHAR'.
 select cast( typecol as varchar(80) ) from blob_table
-	SQL Exception: Cannot convert types 'BLOB' to 'VARCHAR'.
+	ERROR 42846: Cannot convert types 'BLOB' to 'VARCHAR'.
 select cast( typecol as long varchar ) from blob_table
-	SQL Exception: Cannot convert types 'BLOB' to 'LONG VARCHAR'.
+	ERROR 42846: Cannot convert types 'BLOB' to 'LONG VARCHAR'.
 select cast( typecol as char(10) for bit data ) from blob_table
-	SQL Exception: Cannot convert types 'BLOB' to 'CHAR () FOR BIT DATA'.
+	ERROR 42846: Cannot convert types 'BLOB' to 'CHAR () FOR BIT DATA'.
 select cast( typecol as long varchar for bit data ) from blob_table
-	SQL Exception: Cannot convert types 'BLOB' to 'LONG VARCHAR FOR BIT DATA'.
+	ERROR 42846: Cannot convert types 'BLOB' to 'LONG VARCHAR FOR BIT DATA'.
 select cast( typecol as blob(80) ) from blob_table
 	---- 1
 	Column    : 1
@@ -2207,7 +2207,7 @@
 create table blob_table ( dummy int , col_0 int, col_1 char(10), col_2 varchar(80), col_3 long varchar, col_4 char(10) for bit data, col_5 long varchar for bit data, col_6 blob(80), typecol blob (64  ) )
 insert into blob_table values ( 45 ,100,'101','102','103',X'003100300034',X'003100300035',CAST (X'003100300036' AS blob(80)),CAST (X'003100300037' AS blob (64  )) )
 insert into blob_table ( col_0 ) values ( 'true' )
-	SQL Exception: Columns of type 'INTEGER' cannot hold values of type 'CHAR'. 
+	ERROR 42821: Columns of type 'INTEGER' cannot hold values of type 'CHAR'. 
 insert into blob_table ( col_1 ) values ( 'true' )
 insert into blob_table ( col_2 ) values ( 'true' )
 insert into blob_table ( col_3 ) values ( 'true' )
@@ -2586,13 +2586,13 @@
 	OUT = Object : java.sql.Blob
 ---< columns CAST TO type: METADATA TESTS
 select cast( col_0 as blob(64  ) ) from blob_table
-	SQL Exception: Cannot convert types 'INTEGER' to 'BLOB'.
+	ERROR 42846: Cannot convert types 'INTEGER' to 'BLOB'.
 select cast( col_1 as blob(64  ) ) from blob_table
-	SQL Exception: Cannot convert types 'CHAR' to 'BLOB'.
+	ERROR 42846: Cannot convert types 'CHAR' to 'BLOB'.
 select cast( col_2 as blob(64  ) ) from blob_table
-	SQL Exception: Cannot convert types 'VARCHAR' to 'BLOB'.
+	ERROR 42846: Cannot convert types 'VARCHAR' to 'BLOB'.
 select cast( col_3 as blob(64  ) ) from blob_table
-	SQL Exception: Cannot convert types 'LONG VARCHAR' to 'BLOB'.
+	ERROR 42846: Cannot convert types 'LONG VARCHAR' to 'BLOB'.
 select cast( col_4 as blob(64  ) ) from blob_table
 	---- 1
 	Column    : 1
@@ -2687,17 +2687,17 @@
 	OUT = Object : java.sql.Blob
 ---< type CAST TO types: METADATA TESTS
 select cast( typecol as int ) from blob_table
-	SQL Exception: Cannot convert types 'BLOB' to 'INTEGER'.
+	ERROR 42846: Cannot convert types 'BLOB' to 'INTEGER'.
 select cast( typecol as char(10) ) from blob_table
-	SQL Exception: Cannot convert types 'BLOB' to 'CHAR'.
+	ERROR 42846: Cannot convert types 'BLOB' to 'CHAR'.
 select cast( typecol as varchar(80) ) from blob_table
-	SQL Exception: Cannot convert types 'BLOB' to 'VARCHAR'.
+	ERROR 42846: Cannot convert types 'BLOB' to 'VARCHAR'.
 select cast( typecol as long varchar ) from blob_table
-	SQL Exception: Cannot convert types 'BLOB' to 'LONG VARCHAR'.
+	ERROR 42846: Cannot convert types 'BLOB' to 'LONG VARCHAR'.
 select cast( typecol as char(10) for bit data ) from blob_table
-	SQL Exception: Cannot convert types 'BLOB' to 'CHAR () FOR BIT DATA'.
+	ERROR 42846: Cannot convert types 'BLOB' to 'CHAR () FOR BIT DATA'.
 select cast( typecol as long varchar for bit data ) from blob_table
-	SQL Exception: Cannot convert types 'BLOB' to 'LONG VARCHAR FOR BIT DATA'.
+	ERROR 42846: Cannot convert types 'BLOB' to 'LONG VARCHAR FOR BIT DATA'.
 select cast( typecol as blob(80) ) from blob_table
 	---- 1
 	Column    : 1
@@ -2747,9 +2747,9 @@
 drop table blob_table
 create table clob_table ( dummy int , col_0 int, col_1 char(10), col_2 varchar(80), col_3 long varchar, col_4 char(10) for bit data, col_5 long varchar for bit data, col_6 blob(80), typecol clob (2 K) )
 insert into clob_table values ( 45 ,100,'101','102','103',X'003100300034',X'003100300035',CAST (X'003100300036' AS blob(80)),CAST (X'003100300037' AS clob (2 K)) )
-	SQL Exception: Cannot convert types 'CHAR () FOR BIT DATA' to 'CLOB'.
+	ERROR 42846: Cannot convert types 'CHAR () FOR BIT DATA' to 'CLOB'.
 insert into clob_table ( col_0 ) values ( 'true' )
-	SQL Exception: Columns of type 'INTEGER' cannot hold values of type 'CHAR'. 
+	ERROR 42821: Columns of type 'INTEGER' cannot hold values of type 'CHAR'. 
 insert into clob_table ( col_1 ) values ( 'true' )
 insert into clob_table ( col_2 ) values ( 'true' )
 insert into clob_table ( col_3 ) values ( 'true' )
@@ -2757,7 +2757,7 @@
 insert into clob_table ( col_5 ) values cast ( X'0074007200750065'  AS long varchar for bit data)
 insert into clob_table ( col_6 ) values cast ( X'0074007200750065'  AS blob(80))
 insert into clob_table ( typecol ) values cast ( X'0074007200750065'  AS clob (2 K))
-	SQL Exception: Cannot convert types 'CHAR () FOR BIT DATA' to 'CLOB'.
+	ERROR 42846: Cannot convert types 'CHAR () FOR BIT DATA' to 'CLOB'.
 === Columntype int
 select col_0 from clob_table
 	0 getObject            ->		EXCEPTION (null)
@@ -3113,7 +3113,7 @@
 	OUT = NULL
 ---< columns CAST TO type: METADATA TESTS
 select cast( col_0 as clob(2 K) ) from clob_table
-	SQL Exception: Cannot convert types 'INTEGER' to 'CLOB'.
+	ERROR 42846: Cannot convert types 'INTEGER' to 'CLOB'.
 select cast( col_1 as clob(2 K) ) from clob_table
 	---- 1
 	Column    : 1
@@ -3178,11 +3178,11 @@
 	OUT = NULL
 	OUT = NULL
 select cast( col_4 as clob(2 K) ) from clob_table
-	SQL Exception: Cannot convert types 'CHAR () FOR BIT DATA' to 'CLOB'.
+	ERROR 42846: Cannot convert types 'CHAR () FOR BIT DATA' to 'CLOB'.
 select cast( col_5 as clob(2 K) ) from clob_table
-	SQL Exception: Cannot convert types 'LONG VARCHAR FOR BIT DATA' to 'CLOB'.
+	ERROR 42846: Cannot convert types 'LONG VARCHAR FOR BIT DATA' to 'CLOB'.
 select cast( col_6 as clob(2 K) ) from clob_table
-	SQL Exception: Cannot convert types 'BLOB' to 'CLOB'.
+	ERROR 42846: Cannot convert types 'BLOB' to 'CLOB'.
 select cast( typecol as clob(2 K) ) from clob_table
 	---- 1
 	Column    : 1
@@ -3206,7 +3206,7 @@
 	OUT = NULL
 ---< type CAST TO types: METADATA TESTS
 select cast( typecol as int ) from clob_table
-	SQL Exception: Cannot convert types 'CLOB' to 'INTEGER'.
+	ERROR 42846: Cannot convert types 'CLOB' to 'INTEGER'.
 select cast( typecol as char(10) ) from clob_table
 	---- 1
 	Column    : 1
@@ -3271,11 +3271,11 @@
 	OUT = NULL
 	OUT = NULL
 select cast( typecol as char(10) for bit data ) from clob_table
-	SQL Exception: Cannot convert types 'CLOB' to 'CHAR () FOR BIT DATA'.
+	ERROR 42846: Cannot convert types 'CLOB' to 'CHAR () FOR BIT DATA'.
 select cast( typecol as long varchar for bit data ) from clob_table
-	SQL Exception: Cannot convert types 'CLOB' to 'LONG VARCHAR FOR BIT DATA'.
+	ERROR 42846: Cannot convert types 'CLOB' to 'LONG VARCHAR FOR BIT DATA'.
 select cast( typecol as blob(80) ) from clob_table
-	SQL Exception: Cannot convert types 'CLOB' to 'BLOB'.
+	ERROR 42846: Cannot convert types 'CLOB' to 'BLOB'.
 select cast( typecol as clob (2 K) ) from clob_table
 	---- 1
 	Column    : 1
@@ -3300,9 +3300,9 @@
 drop table clob_table
 create table clob_table ( dummy int , col_0 int, col_1 char(10), col_2 varchar(80), col_3 long varchar, col_4 char(10) for bit data, col_5 long varchar for bit data, col_6 blob(80), typecol clob (64  ) )
 insert into clob_table values ( 45 ,100,'101','102','103',X'003100300034',X'003100300035',CAST (X'003100300036' AS blob(80)),CAST (X'003100300037' AS clob (64  )) )
-	SQL Exception: Cannot convert types 'CHAR () FOR BIT DATA' to 'CLOB'.
+	ERROR 42846: Cannot convert types 'CHAR () FOR BIT DATA' to 'CLOB'.
 insert into clob_table ( col_0 ) values ( 'true' )
-	SQL Exception: Columns of type 'INTEGER' cannot hold values of type 'CHAR'. 
+	ERROR 42821: Columns of type 'INTEGER' cannot hold values of type 'CHAR'. 
 insert into clob_table ( col_1 ) values ( 'true' )
 insert into clob_table ( col_2 ) values ( 'true' )
 insert into clob_table ( col_3 ) values ( 'true' )
@@ -3310,7 +3310,7 @@
 insert into clob_table ( col_5 ) values cast ( X'0074007200750065'  AS long varchar for bit data)
 insert into clob_table ( col_6 ) values cast ( X'0074007200750065'  AS blob(80))
 insert into clob_table ( typecol ) values cast ( X'0074007200750065'  AS clob (64  ))
-	SQL Exception: Cannot convert types 'CHAR () FOR BIT DATA' to 'CLOB'.
+	ERROR 42846: Cannot convert types 'CHAR () FOR BIT DATA' to 'CLOB'.
 === Columntype int
 select col_0 from clob_table
 	0 getObject            ->		EXCEPTION (null)
@@ -3666,7 +3666,7 @@
 	OUT = NULL
 ---< columns CAST TO type: METADATA TESTS
 select cast( col_0 as clob(64  ) ) from clob_table
-	SQL Exception: Cannot convert types 'INTEGER' to 'CLOB'.
+	ERROR 42846: Cannot convert types 'INTEGER' to 'CLOB'.
 select cast( col_1 as clob(64  ) ) from clob_table
 	---- 1
 	Column    : 1
@@ -3731,11 +3731,11 @@
 	OUT = NULL
 	OUT = NULL
 select cast( col_4 as clob(64  ) ) from clob_table
-	SQL Exception: Cannot convert types 'CHAR () FOR BIT DATA' to 'CLOB'.
+	ERROR 42846: Cannot convert types 'CHAR () FOR BIT DATA' to 'CLOB'.
 select cast( col_5 as clob(64  ) ) from clob_table
-	SQL Exception: Cannot convert types 'LONG VARCHAR FOR BIT DATA' to 'CLOB'.
+	ERROR 42846: Cannot convert types 'LONG VARCHAR FOR BIT DATA' to 'CLOB'.
 select cast( col_6 as clob(64  ) ) from clob_table
-	SQL Exception: Cannot convert types 'BLOB' to 'CLOB'.
+	ERROR 42846: Cannot convert types 'BLOB' to 'CLOB'.
 select cast( typecol as clob(64  ) ) from clob_table
 	---- 1
 	Column    : 1
@@ -3759,7 +3759,7 @@
 	OUT = NULL
 ---< type CAST TO types: METADATA TESTS
 select cast( typecol as int ) from clob_table
-	SQL Exception: Cannot convert types 'CLOB' to 'INTEGER'.
+	ERROR 42846: Cannot convert types 'CLOB' to 'INTEGER'.
 select cast( typecol as char(10) ) from clob_table
 	---- 1
 	Column    : 1
@@ -3824,11 +3824,11 @@
 	OUT = NULL
 	OUT = NULL
 select cast( typecol as char(10) for bit data ) from clob_table
-	SQL Exception: Cannot convert types 'CLOB' to 'CHAR () FOR BIT DATA'.
+	ERROR 42846: Cannot convert types 'CLOB' to 'CHAR () FOR BIT DATA'.
 select cast( typecol as long varchar for bit data ) from clob_table
-	SQL Exception: Cannot convert types 'CLOB' to 'LONG VARCHAR FOR BIT DATA'.
+	ERROR 42846: Cannot convert types 'CLOB' to 'LONG VARCHAR FOR BIT DATA'.
 select cast( typecol as blob(80) ) from clob_table
-	SQL Exception: Cannot convert types 'CLOB' to 'BLOB'.
+	ERROR 42846: Cannot convert types 'CLOB' to 'BLOB'.
 select cast( typecol as clob (64  ) ) from clob_table
 	---- 1
 	Column    : 1
@@ -3854,20 +3854,20 @@
 ---< BLOB Insertion Tests
 create table blobCheck (bl blob(80)) 
 insert into blobCheck (bl ) values ('string' )
-	SQL Exception: Columns of type 'BLOB' cannot hold values of type 'CHAR'. 
+	ERROR 42821: Columns of type 'BLOB' cannot hold values of type 'CHAR'. 
 insert into blobCheck (bl ) values (cast (X'0073007400720069006e0067' as blob(80)) )
 insert into blobCheck (bl ) values (X'48' )
-	SQL Exception: Columns of type 'BLOB' cannot hold values of type 'CHAR () FOR BIT DATA'. 
+	ERROR 42821: Columns of type 'BLOB' cannot hold values of type 'CHAR () FOR BIT DATA'. 
 insert into blobCheck (bl ) values (cast (X'C8' as blob(80)) )
 insert into blobCheck (bl ) values ( X'a78a' )
-	SQL Exception: Columns of type 'BLOB' cannot hold values of type 'CHAR () FOR BIT DATA'. 
+	ERROR 42821: Columns of type 'BLOB' cannot hold values of type 'CHAR () FOR BIT DATA'. 
 insert into blobCheck (bl ) values (cast (X'a78a' as blob(80)) )
 insert into blobCheck (bl ) values ('string' )
-	SQL Exception: Columns of type 'BLOB' cannot hold values of type 'CHAR'. 
+	ERROR 42821: Columns of type 'BLOB' cannot hold values of type 'CHAR'. 
 insert into blobCheck (bl ) values (cast (X'0073007400720069006e0067' as blob(80)) )
 insert into blobCheck (bl ) values (X'48' )
-	SQL Exception: Columns of type 'BLOB' cannot hold values of type 'CHAR () FOR BIT DATA'. 
+	ERROR 42821: Columns of type 'BLOB' cannot hold values of type 'CHAR () FOR BIT DATA'. 
 insert into blobCheck (bl ) values (cast (X'C8' as blob(80)) )
 insert into blobCheck (bl ) values ( X'a78a' )
-	SQL Exception: Columns of type 'BLOB' cannot hold values of type 'CHAR () FOR BIT DATA'. 
+	ERROR 42821: Columns of type 'BLOB' cannot hold values of type 'CHAR () FOR BIT DATA'. 
 insert into blobCheck (bl ) values (cast (X'a78a' as blob(80)) )

Modified: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/jdk14/updatableResultSet.out
URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/jdk14/updatableResultSet.out?view=diff&r1=160465&r2=160466
==============================================================================
--- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/jdk14/updatableResultSet.out (original)
+++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/jdk14/updatableResultSet.out Thu Apr  7 13:39:20 2005
@@ -1,6 +1,6 @@
 Start testing delete and update using JDBC2.0 updateable resultset apis
 Negative Testl - request for scroll insensitive updatable resultset will give a read only scroll insensitive resultset
-warnings on connection = SQL Warning: Scroll sensitive and scroll insensitive updatable ResultSets are not currently implemented.
+WARNING 01J03: Scroll sensitive and scroll insensitive updatable ResultSets are not currently implemented.
 requested TYPE_SCROLL_INSENSITIVE, CONCUR_UPDATABLE but that is not supported
 Make sure that we got TYPE_SCROLL_INSENSITIVE? true
 Make sure that we got CONCUR_READ_ONLY? true

Modified: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/updatableResultSet.out
URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/updatableResultSet.out?view=diff&r1=160465&r2=160466
==============================================================================
--- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/updatableResultSet.out (original)
+++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/updatableResultSet.out Thu Apr  7 13:39:20 2005
@@ -1,6 +1,6 @@
 Start testing delete and update using JDBC2.0 updateable resultset apis
 Negative Testl - request for scroll insensitive updatable resultset will give a read only scroll insensitive resultset
-warnings on connection = SQL Warning: Scroll sensitive and scroll insensitive updatable ResultSets are not currently implemented.
+WARNING 01J03: Scroll sensitive and scroll insensitive updatable ResultSets are not currently implemented.
 requested TYPE_SCROLL_INSENSITIVE, CONCUR_UPDATABLE but that is not supported
 Make sure that we got TYPE_SCROLL_INSENSITIVE? true
 Make sure that we got CONCUR_READ_ONLY? true

Modified: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/LOBTest.java
URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/LOBTest.java?view=diff&r1=160465&r2=160466
==============================================================================
--- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/LOBTest.java (original)
+++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/LOBTest.java Thu Apr  7 13:39:20 2005
@@ -40,6 +40,7 @@
 import java.sql.PreparedStatement;
 import org.apache.derby.tools.ij;
 import org.apache.derbyTesting.functionTests.util.TestUtil;
+import org.apache.derby.tools.JDBCDisplayUtil;
 
 /**
  * @author Jonas S Karlsson
@@ -66,8 +67,8 @@
 	}
     public static void printSQLError(SQLException e) {
         while (e != null) {
-			System.out.print("\t");
-            System.out.println(e.toString());
+            System.out.print("\t");
+            JDBCDisplayUtil.ShowSQLException(System.out, e);
             e = e.getNextException();
         }
     }
@@ -468,11 +469,14 @@
         {
             for(int i=0; i<columns; i++) {
                 String insert = "insert into "+table+" ( "+colNames[i];
+
 				if (isBitColumn(i))
 				// have to cast for blob columns.
+	{
 					insert += " ) values cast ( " +
 						TestUtil.stringToHexLiteral("true") +
 						"  AS " + colTypes[i] + ")";
+	}
 				else
                     insert += " ) values ( 'true' )";
                 Xprint(insert);

Modified: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/copyfiles.ant
URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/copyfiles.ant?view=diff&r1=160465&r2=160466
==============================================================================
--- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/copyfiles.ant (original)
+++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/copyfiles.ant Thu Apr  7 13:39:20 2005
@@ -18,6 +18,7 @@
 metadataJdbc20_app.properties
 metadataJdbc20_derby.properties
 metadataJdbc20_sed.properties
+odbc_metadata_sed.properties
 resultsetJdbc30_app.properties
 resultsetJdbc30_sed.properties
 resultsetStream.gif



Mime
View raw message