Hi,
Networkserver testing can/should be augmented by running the jdbc20 & jdbcapi suites. As happens after applying attached patch.
Thx, Myrna
Index: java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/importExport.out =================================================================== --- java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/importExport.out (revision 0) +++ java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/importExport.out (revision 0) @@ -0,0 +1,25 @@ +Test importExport starting +testing non-existing data file +The exception 'SQL Exception: The exception 'java.lang.reflect.InvocationTargetException' was thrown while evaluating an expression.' was thrown while evaluating an expression. SQLSTATE: 38000: The exception 'java.lang.reflect.InvocationTargetException' was thrown while evaluating an expression. SQLSTATE: XJ001: Java exception: ': java.lang.reflect.InvocationTargetException'. SQLSTATE: XIE04: Data file not found: extinout/Z.dat +testing null data file +The exception 'SQL Exception: The exception 'java.lang.reflect.InvocationTargetException' was thrown while evaluating an expression.' was thrown while evaluating an expression. SQLSTATE: 38000: The exception 'java.lang.reflect.InvocationTargetException' was thrown while evaluating an expression. SQLSTATE: XJ001: Java exception: ': java.lang.reflect.InvocationTargetException'. SQLSTATE: XIE05: Data file can not be null. +testing empty table +testing empty table with Delimited format +testing empty table import Field/Char Delimiters +PASS: setup complete +testing import/export with default options +testing IE with code set 8859_1 +testing IE with delimiter and codeset +testing IE with delimiters(%, &) and Cp1252 +testing IE with delimiters(%, &) and UTF-16 +testing IE with delimiters(^, #) and WRONG ENCODEINGH +Got IOException while writing data to the file +testing datatypes that does not have Export Supprt +Column 'C1' in the table is of type BLOB, it is not supported by import/export. +Column 'C1' in the table is of type BLOB, it is not supported by import/export. +The exception 'SQL Exception: Read endOfFile at unexpected place on line 2' was thrown while evaluating an expression. SQLSTATE: XIE0E: Read endOfFile at unexpected place on line 2 +PASS: finished testing import and export +PASS: teardown complete +PASS: finished cleaning up the temporary objects from database +PASS +Test importExport finished
Property changes on:
java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/importExport.out
___________________________________________________________________
Name: svn:eol-style
+ native
Index:
java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/ieptests.out
===================================================================
---
java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/ieptests.out
(revision 0)
+++
java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/ieptests.out
(revision 0)
@@ -0,0 +1,721 @@
+ij> --table used for export
+create table ex_emp(id int , name char(7) , skills varchar(200), salary
decimal(10,2)) ;
+0 rows inserted/updated/deleted
+ij> --table used for import
+create table imp_emp(id int , name char(7), skills varchar(200), salary
decimal(10,2)) ;
+0 rows inserted/updated/deleted
+ij> --After an export from ex_emp and import to imp_emp both tables should
have
+-----same data.
+-----double delimter cases with default character delimter "
+-----field seperator character inside a double delimited string as first line
+insert into ex_emp values(99, 'smith' , 'tennis"p,l,ayer"', 190.55) ;
+1 row inserted/updated/deleted
+ij> -- Perform Export:
+call SYSCS_UTIL.SYSCS_EXPORT_TABLE (null, 'ex_emp' , 'extinout/emp.dat' ,
+ null, null, null) ;
+Statement executed.
+ij> -- Perform Import
+call SYSCS_UTIL.SYSCS_IMPORT_TABLE (null, 'imp_emp' , 'extinout/emp.dat' ,
+ null, null, null, 0) ;
+Statement executed.
+ij> insert into ex_emp values(100, 'smith' , 'tennis"player"', 190.55) ;
+1 row inserted/updated/deleted
+ij> insert into ex_emp values(101, 'smith' , 'tennis"player', 190.55) ;
+1 row inserted/updated/deleted
+ij> insert into ex_emp values(102, 'smith' , '"tennis"player', 190.55) ;
+1 row inserted/updated/deleted
+ij> insert into ex_emp values(103, 'smith' , '"tennis"player"', 190.55) ;
+1 row inserted/updated/deleted
+ij> insert into ex_emp values(104, 'smith' ,
'"tennis"""""""""""""""""""""""""""""""""""""player"', null) ;
+1 row inserted/updated/deleted
+ij> --empty string
+insert into ex_emp values(105, 'smith' , '""', 190.55) ;
+1 row inserted/updated/deleted
+ij> --just delimeter inside
+insert into ex_emp values(106, 'smith' , '"""""""""""""""""""', 190.55);
+1 row inserted/updated/deleted
+ij> --null value
+insert into ex_emp values(107, 'smith"' , null, 190.55) ;
+1 row inserted/updated/deleted
+ij> --all values are nulls
+insert into ex_emp values(108, null , null, null) ;
+1 row inserted/updated/deleted
+ij> -- Perform Export:
+call SYSCS_UTIL.SYSCS_EXPORT_TABLE (null, 'ex_emp' , 'extinout/emp.dat' ,
+ null, null, null) ;
+Statement executed.
+ij> -- Perform Import
+call SYSCS_UTIL.SYSCS_IMPORT_TABLE (null, 'imp_emp' , 'extinout/emp.dat' ,
+ null, null, null, 0) ;
+Statement executed.
+ij> select * from ex_emp;
+ID |NAME |SKILLS |SALARY
+-----
+99 |smith |tennis"p,l,ayer" |190.55
+100 |smith |tennis"player" |190.55
+101 |smith |tennis"player |190.55
+102 |smith |"tennis"player |190.55
+103 |smith |"tennis"player" |190.55
+104 |smith |"tennis"""""""""""""""""""""""""""""""""""""player" |NULL
+105 |smith |"" |190.55
+106 |smith |""""""""""""""""""" |190.55
+107 |smith" |NULL |190.55
+108 |NULL |NULL |NULL
+ij> select * from imp_emp;
+ID |NAME |SKILLS |SALARY
+-----
+99 |smith |tennis"p,l,ayer" |190.55
+99 |smith |tennis"p,l,ayer" |190.55
+100 |smith |tennis"player" |190.55
+101 |smith |tennis"player |190.55
+102 |smith |"tennis"player |190.55
+103 |smith |"tennis"player" |190.55
+104 |smith |"tennis"""""""""""""""""""""""""""""""""""""player" |NULL
+105 |smith |"" |190.55
+106 |smith |""""""""""""""""""" |190.55
+107 |smith" |NULL |190.55
+108 |NULL |NULL |NULL
+ij> --checking query
+select count(*) from imp_emp, ex_emp
+ where ex_emp.id = imp_emp.id and
+ (ex_emp.skills=imp_emp.skills or
+ (ex_emp.skills is NULL and imp_emp.skills is NULL));
+1
+-----
+11
+ij> delete from imp_emp where id < 105;
+7 rows inserted/updated/deleted
+ij> --export from ex_emp using the a query only rows that got deleted in
imp_emp
+call SYSCS_UTIL.SYSCS_EXPORT_QUERY('select * from ex_emp where id < 105',
+ 'extinout/emp.dat' , null, null, null) ;
+Statement executed.
+ij> call SYSCS_UTIL.SYSCS_IMPORT_TABLE (null, 'imp_emp' , 'extinout/emp.dat' ,
+ null, null, null, 0) ;
+Statement executed.
+ij> --checking query
+select count(*) from imp_emp, ex_emp
+ where ex_emp.id = imp_emp.id and
+ (ex_emp.skills=imp_emp.skills or
+ (ex_emp.skills is NULL and imp_emp.skills is NULL));
+1
+-----
+10
+ij> --export the columns in different column order than in the table.
+call SYSCS_UTIL.SYSCS_EXPORT_QUERY('select name , salary , skills, id from
ex_emp where id < 105',
+ 'extinout/emp.dat' , null, null, null) ;
+Statement executed.
+ij> -- import them in to a with order different than in the table;
+call SYSCS_UTIL.SYSCS_IMPORT_DATA(null, 'imp_emp' ,'name, salary, skills, id',
null,
+ 'extinout/emp.dat', null, null, null, 1) ;
+Statement executed.
+ij> --check query
+select count(*) from imp_emp, ex_emp
+ where ex_emp.id = imp_emp.id and
+ (ex_emp.skills=imp_emp.skills or
+ (ex_emp.skills is NULL and imp_emp.skills is NULL));
+1
+-----
+6
+ij> -- do import replace into the table with table order but using column
indexes
+call SYSCS_UTIL.SYSCS_IMPORT_DATA(null, 'imp_emp' ,null, '4, 1, 3, 2',
+ 'extinout/emp.dat', null, null, null, 1) ;
+Statement executed.
+ij> --check query
+select count(*) from imp_emp, ex_emp
+ where ex_emp.id = imp_emp.id and
+ (ex_emp.skills=imp_emp.skills or
+ (ex_emp.skills is NULL and imp_emp.skills is NULL));
+1
+-----
+6
+ij> --replace using insert column names and column indexes
+call SYSCS_UTIL.SYSCS_IMPORT_DATA(null, 'imp_emp' ,'salary, id, skills, name',
'2, 4, 3, 1',
+ 'extinout/emp.dat', null, null, null, 1) ;
+Statement executed.
+ij> --check query
+select count(*) from imp_emp, ex_emp
+ where ex_emp.id = imp_emp.id and
+ (ex_emp.skills=imp_emp.skills or
+ (ex_emp.skills is NULL and imp_emp.skills is NULL));
+1
+-----
+6
+ij> ---testing with different delimiters
+----- single quote(') as character delimiter
+call SYSCS_UTIL.SYSCS_EXPORT_TABLE (null, 'ex_emp' , 'extinout/emp.dat' ,
+ null, '''', null) ;
+Statement executed.
+ij> call SYSCS_UTIL.SYSCS_IMPORT_TABLE (null, 'imp_emp' , 'extinout/emp.dat' ,
+ null, '''', null, 1) ;
+Statement executed.
+ij> select * from imp_emp ;
+ID |NAME |SKILLS |SALARY
+-----
+99 |smith |tennis"p,l,ayer" |190.55
+100 |smith |tennis"player" |190.55
+101 |smith |tennis"player |190.55
+102 |smith |"tennis"player |190.55
+103 |smith |"tennis"player" |190.55
+104 |smith |"tennis"""""""""""""""""""""""""""""""""""""player" |NULL
+105 |smith |"" |190.55
+106 |smith |""""""""""""""""""" |190.55
+107 |smith" |NULL |190.55
+108 |NULL |NULL |NULL
+ij> -- single quote(') as column delimiter
+call SYSCS_UTIL.SYSCS_EXPORT_TABLE (null, 'ex_emp' , 'extinout/emp.dat' ,
+ '''',null, null) ;
+Statement executed.
+ij> delete from imp_emp ;
+10 rows inserted/updated/deleted
+ij> call SYSCS_UTIL.SYSCS_IMPORT_TABLE (null, 'imp_emp' , 'extinout/emp.dat' ,
+ '''', null, null, 0) ;
+Statement executed.
+ij> select * from imp_emp;
+ID |NAME |SKILLS |SALARY
+-----
+99 |smith |tennis"p,l,ayer" |190.55
+100 |smith |tennis"player" |190.55
+101 |smith |tennis"player |190.55
+102 |smith |"tennis"player |190.55
+103 |smith |"tennis"player" |190.55
+104 |smith |"tennis"""""""""""""""""""""""""""""""""""""player" |NULL
+105 |smith |"" |190.55
+106 |smith |""""""""""""""""""" |190.55
+107 |smith" |NULL |190.55
+108 |NULL |NULL |NULL
+ij> call SYSCS_UTIL.SYSCS_EXPORT_TABLE (null, 'ex_emp' , 'extinout/emp.dat' ,
+ '*', '%', null) ;
+Statement executed.
+ij> call SYSCS_UTIL.SYSCS_IMPORT_TABLE (null, 'ex_emp' , 'extinout/emp.dat' ,
+ '*', '%', null, 1) ;
+Statement executed.
+ij> select * from imp_emp ;
+ID |NAME |SKILLS |SALARY
+-----
+99 |smith |tennis"p,l,ayer" |190.55
+100 |smith |tennis"player" |190.55
+101 |smith |tennis"player |190.55
+102 |smith |"tennis"player |190.55
+103 |smith |"tennis"player" |190.55
+104 |smith |"tennis"""""""""""""""""""""""""""""""""""""player" |NULL
+105 |smith |"" |190.55
+106 |smith |""""""""""""""""""" |190.55
+107 |smith" |NULL |190.55
+108 |NULL |NULL |NULL
+ij> --cases for identity columns
+-----create table emp1(id int generated always as identity (start with 100),
name char(7),
+----- skills varchar(200), salary decimal(10,2),skills
varchar(200));
+-----check import export with real and double that can not be explictitly
+-----casted from VARCHAR type .
+create table noncast(c1 double , c2 real ) ;
+0 rows inserted/updated/deleted
+ij> insert into noncast values(1.5 , 6.7 ) ;
+1 row inserted/updated/deleted
+ij> insert into noncast values(2.5 , 8.999) ;
+1 row inserted/updated/deleted
+ij> call SYSCS_UTIL.SYSCS_EXPORT_TABLE ('APP' , 'noncast' ,
'extinout/noncast.dat' , null , null , null) ;
+Statement executed.
+ij> call SYSCS_UTIL.SYSCS_IMPORT_TABLE (null, 'noncast' ,
'extinout/noncast.dat' , null , null , null , 0) ;
+Statement executed.
+ij> call SYSCS_UTIL.SYSCS_IMPORT_DATA(null, 'noncast', 'c2 , c1' , '2, 1' ,
+ 'extinout/noncast.dat' , null , null ,
null , 0) ;
+Statement executed.
+ij> select * from noncast ;
+C1 |C2
+-----
+1.5 |6.7
+2.5 |8.999
+1.5 |6.7
+2.5 |8.999
+1.5 |6.7
+2.5 |8.999
+ij> --check import/export of time types
+CREATE TABLE TTYPES(DATETYPE DATE, TIMETYPE TIME, TSTAMPTYPE TIMESTAMP );
+0 rows inserted/updated/deleted
+ij> insert into ttypes values('1999-09-09' , '12:15:19' ,
'xxxxxxFILTERED-TIMESTAMPxxxxx);
+1 row inserted/updated/deleted
+ij> insert into ttypes values('2999-12-01' , '13:16:10' ,
'xxxxxxFILTERED-TIMESTAMPxxxxx);
+1 row inserted/updated/deleted
+ij> insert into ttypes values('3000-11-02' , '14:17:21' ,
'xxxxxxFILTERED-TIMESTAMPxxxxx);
+1 row inserted/updated/deleted
+ij> insert into ttypes values('2004-04-03' , '15:18:31' ,
'xxxxxxFILTERED-TIMESTAMPxxxxx);
+1 row inserted/updated/deleted
+ij> insert into ttypes values(null , null , null);
+1 row inserted/updated/deleted
+ij> call SYSCS_UTIL.SYSCS_EXPORT_TABLE (null, 'ttypes' , 'extinout/ttypes.del'
,
+ null, null, null) ;
+Statement executed.
+ij> call SYSCS_UTIL.SYSCS_IMPORT_TABLE (null, 'ttypes' , 'extinout/ttypes.del'
,
+ null, null, null, 0) ;
+Statement executed.
+ij> select * from ttypes;
+DATETYPE |TIMETYPE |TSTAMPTYPE
+-----
+1999-09-09 |12:15:19 |xxxxxxFILTERED-TIMESTAMPxxxxx
+2999-12-01 |13:16:10 |xxxxxxFILTERED-TIMESTAMPxxxxx
+3000-11-02 |14:17:21 |xxxxxxFILTERED-TIMESTAMPxxxxx
+2004-04-03 |15:18:31 |xxxxxxFILTERED-TIMESTAMPxxxxx
+NULL |NULL |NULL
+1999-09-09 |12:15:19 |xxxxxxFILTERED-TIMESTAMPxxxxx
+2999-12-01 |13:16:10 |xxxxxxFILTERED-TIMESTAMPxxxxx
+3000-11-02 |14:17:21 |xxxxxxFILTERED-TIMESTAMPxxxxx
+2004-04-03 |15:18:31 |xxxxxxFILTERED-TIMESTAMPxxxxx
+NULL |NULL |NULL
+ij> ---Import should commit on success and rollback on any failures
+autocommit off ;
+ij> create table t1(a int ) ;
+0 rows inserted/updated/deleted
+ij> insert into t1 values(1) ;
+1 row inserted/updated/deleted
+ij> insert into t1 values(2) ;
+1 row inserted/updated/deleted
+ij> call SYSCS_UTIL.SYSCS_EXPORT_TABLE (null, 't1' , 'extinout/t1.del' ,
+ null, null, null) ;
+Statement executed.
+ij> call SYSCS_UTIL.SYSCS_IMPORT_TABLE (null, 't1' , 'extinout/t1.del' ,
+ null, null, null, 0) ;
+Statement executed.
+ij> --above import should have committed , following rollback should be a noop.
+rollback;
+ij> select * from t1;
+A
+-----
+1
+2
+1
+2
+ij> insert into t1 values(3) ;
+1 row inserted/updated/deleted
+ij> insert into t1 values(4) ;
+1 row inserted/updated/deleted
+ij> --file not found error should rollback
+call SYSCS_UTIL.SYSCS_IMPORT_TABLE (null, 't1' , 'extinout/nofile.del' ,
+ null, null, null, 0) ;
+ERROR 38000: The exception 'SQL Exception: The exception
'java.lang.reflect.InvocationTargetException' was thrown while evaluating an
expression.' was thrown while evaluating an expression. SQLSTATE: 38000: The
exception 'java.lang.reflect.InvocationTargetException' was thrown while
evaluating an expression. SQLSTATE: XJ001: Java exception: ':
java.lang.reflect.InvocationTargetException'. SQLSTATE: XIE04: Data file not
found: extinout/nofile.del
+ij> commit;
+ij> select * from t1 ;
+A
+-----
+1
+2
+1
+2
+ij> insert into t1 values(3) ;
+1 row inserted/updated/deleted
+ij> insert into t1 values(4) ;
+1 row inserted/updated/deleted
+ij> --table not found error should issue a implicit rollback
+call SYSCS_UTIL.SYSCS_IMPORT_TABLE (null, 'notable' , 'extinout/t1.del' ,
+ null, null, null, 0) ;
+ERROR XIE0M: Table 'NOTABLE' does not exist.
+ij> commit ;
+ij> select * from t1 ;
+A
+-----
+1
+2
+1
+2
+ij> delete from t1;
+4 rows inserted/updated/deleted
+ij> ---check commit/rollback with replace options using
+insert into t1 values(1) ;
+1 row inserted/updated/deleted
+ij> insert into t1 values(2) ;
+1 row inserted/updated/deleted
+ij> call SYSCS_UTIL.SYSCS_EXPORT_TABLE (null, 't1' , 'extinout/t1.del' ,
+ null, null, null) ;
+Statement executed.
+ij> --above export should have a commit.rollback below should be a noop
+rollback;
+ij> select * from t1;
+A
+-----
+1
+2
+ij> call SYSCS_UTIL.SYSCS_IMPORT_TABLE (null, 't1' , 'extinout/t1.del' ,
+ null, null, null, 1) ;
+Statement executed.
+ij> --above import should have committed , following rollback should be a noop.
+rollback;
+ij> select * from t1;
+A
+-----
+1
+2
+ij> insert into t1 values(3) ;
+1 row inserted/updated/deleted
+ij> insert into t1 values(4) ;
+1 row inserted/updated/deleted
+ij> --file not found error should rollback
+call SYSCS_UTIL.SYSCS_IMPORT_TABLE (null, 't1' , 'extinout/nofile.del' ,
+ null, null, null, 1) ;
+ERROR 38000: The exception 'SQL Exception: The exception
'java.lang.reflect.InvocationTargetException' was thrown while evaluating an
expression.' was thrown while evaluating an expression. SQLSTATE: 38000: The
exception 'java.lang.reflect.InvocationTargetException' was thrown while
evaluating an expression. SQLSTATE: XJ001: Java exception: ':
java.lang.reflect.InvocationTargetException'. SQLSTATE: XIE04: Data file not
found: extinout/nofile.del
+ij> commit;
+ij> select * from t1 ;
+A
+-----
+1
+2
+ij> insert into t1 values(3) ;
+1 row inserted/updated/deleted
+ij> insert into t1 values(4) ;
+1 row inserted/updated/deleted
+ij> --table not found error should issue a implicit rollback
+call SYSCS_UTIL.SYSCS_IMPORT_TABLE (null, 'notable' , 'extinout/t1.del' ,
+ null, null, null, 1) ;
+ERROR XIE0M: Table 'NOTABLE' does not exist.
+ij> commit ;
+ij> ---check IMPORT_DATA calls commit/rollback
+select * from t1 ;
+A
+-----
+1
+2
+ij> delete from t1;
+2 rows inserted/updated/deleted
+ij> ---check commit/rollback with replace options using
+insert into t1 values(1) ;
+1 row inserted/updated/deleted
+ij> insert into t1 values(2) ;
+1 row inserted/updated/deleted
+ij> call SYSCS_UTIL.SYSCS_EXPORT_TABLE (null, 't1' , 'extinout/t1.del' ,
+ null, null, null) ;
+Statement executed.
+ij> call SYSCS_UTIL.SYSCS_IMPORT_DATA(null, 't1' , 'a' , '1' ,
'extinout/t1.del' ,
+ null, null, null, 0) ;
+Statement executed.
+ij> --above import should have committed , following rollback should be a noop.
+rollback;
+ij> select * from t1;
+A
+-----
+1
+2
+1
+2
+ij> insert into t1 values(3) ;
+1 row inserted/updated/deleted
+ij> insert into t1 values(4) ;
+1 row inserted/updated/deleted
+ij> --file not found error should rollback
+call SYSCS_UTIL.SYSCS_IMPORT_DATA(null, 't1', 'a' , '1' ,
'extinout/nofile.del' ,
+ null, null, null, 0) ;
+ERROR 38000: The exception 'SQL Exception: The exception
'java.lang.reflect.InvocationTargetException' was thrown while evaluating an
expression.' was thrown while evaluating an expression. SQLSTATE: 38000: The
exception 'java.lang.reflect.InvocationTargetException' was thrown while
evaluating an expression. SQLSTATE: XJ001: Java exception: ':
java.lang.reflect.InvocationTargetException'. SQLSTATE: XIE04: Data file not
found: extinout/nofile.del
+ij> commit;
+ij> select * from t1 ;
+A
+-----
+1
+2
+1
+2
+ij> insert into t1 values(3) ;
+1 row inserted/updated/deleted
+ij> insert into t1 values(4) ;
+1 row inserted/updated/deleted
+ij> --table not found error should issue a implicit rollback
+call SYSCS_UTIL.SYSCS_IMPORT_DATA(null, 'notable' , 'a' , '1',
'extinout/t1.del' ,
+ null, null, null, 1) ;
+ERROR XIE0M: Table 'NOTABLE' does not exist.
+ij> commit ;
+ij> select * from t1 ;
+A
+-----
+1
+2
+1
+2
+ij> autocommit on ;
+ij> --make sure commit import code is ok in autcommit mode.
+insert into t1 values(3) ;
+1 row inserted/updated/deleted
+ij> insert into t1 values(4) ;
+1 row inserted/updated/deleted
+ij> call SYSCS_UTIL.SYSCS_IMPORT_DATA(null, 't1' , 'a' , '1' ,
'extinout/t1.del' ,
+ null, null, null, 0) ;
+Statement executed.
+ij> select * from t1 ;
+A
+-----
+1
+2
+1
+2
+3
+4
+1
+2
+ij> insert into t1 values(5) ;
+1 row inserted/updated/deleted
+ij> insert into t1 values(6) ;
+1 row inserted/updated/deleted
+ij> --following import will back , but should not have any impact on inserts
+call SYSCS_UTIL.SYSCS_IMPORT_DATA(null, 't1', 'a' , '1' ,
'extinout/nofile.del' ,
+ null, null, null, 0) ;
+ERROR 38000: The exception 'SQL Exception: The exception
'java.lang.reflect.InvocationTargetException' was thrown while evaluating an
expression.' was thrown while evaluating an expression. SQLSTATE: 38000: The
exception 'java.lang.reflect.InvocationTargetException' was thrown while
evaluating an expression. SQLSTATE: XJ001: Java exception: ':
java.lang.reflect.InvocationTargetException'. SQLSTATE: XIE04: Data file not
found: extinout/nofile.del
+ij> select * from t1 ;
+A
+-----
+1
+2
+1
+2
+3
+4
+1
+2
+5
+6
+ij> --END IMPORT COMMIT/ROLLBACK TESTSING
+-----all types supported by DB2 cloudscape import/export
+create table alltypes(chartype char(20) ,
+ biginttype bigint ,
+ datetype date ,
+ decimaltype decimal(10,5) ,
+ doubletype double ,
+ inttype integer ,
+ lvartype long varchar ,
+ realtype real ,
+ sminttype smallint ,
+ timetype time ,
+ tstamptype timestamp ,
+ vartype varchar(50));
+0 rows inserted/updated/deleted
+ij> insert into alltypes values('chartype string' ,
+ 9223372036854775807,
+ '1993-10-29' ,
+ 12345.54321,
+ 10E307,
+ 2147483647,
+ 'long varchar testing',
+ 10E3,
+ 32767,
+ '09.39.43',
+ 'xxxxxxFILTERED-TIMESTAMPxxxxx,
+ 'varchar testing');
+1 row inserted/updated/deleted
+ij> insert into alltypes values('chartype string' ,
+ -9223372036854775808,
+ '1993-10-29' ,
+ 0.0,
+ -10E307,
+ -2147483647,
+ 'long varchar testing',
+ -10E3,
+ 32767,
+ '09.39.43',
+ 'xxxxxxFILTERED-TIMESTAMPxxxxx,
+ 'varchar testing');
+1 row inserted/updated/deleted
+ij> insert into alltypes values('"chartype" string' ,
+ 9223372036854775807,
+ '1993-10-29' ,
+ -12345.54321,
+ 10E307,
+ 2147483647,
+ 'long "varchar" testing',
+ 10E3,
+ 32767,
+ '09.39.43',
+ 'xxxxxxFILTERED-TIMESTAMPxxxxx,
+ '"varchar" testing');
+1 row inserted/updated/deleted
+ij> call SYSCS_UTIL.SYSCS_EXPORT_TABLE (null, 'alltypes' ,
'extinout/alltypes.del' ,
+ null, null, null) ;
+Statement executed.
+ij> call SYSCS_UTIL.SYSCS_IMPORT_TABLE (null, 'alltypes' ,
'extinout/alltypes.del' ,
+ null, null, null, 0) ;
+Statement executed.
+ij> select * from alltypes ;
+CHARTYPE |BIGINTTYPE |DATETYPE |DECIMALTYPE |DOUBLETYPE |INTTYPE |LVARTYPE
|REALTYPE |SMINT& |TIMETYPE |TSTAMPTYPE |VARTYPE
+-----
+chartype string |9223372036854775807 |1993-10-29 |12345.54321 |1.0E308
|2147483647 |long varchar testing |10000.0 |32767 |09:39:43
|xxxxxxFILTERED-TIMESTAMPxxxxx |varchar testing
+chartype string |-9223372036854775808 |1993-10-29 |0.00000 |-1.0E308
|-2147483647 |long varchar testing |-10000.0 |32767 |09:39:43
|xxxxxxFILTERED-TIMESTAMPxxxxx |varchar testing
+"chartype" string |9223372036854775807 |1993-10-29 |-12345.54321 |1.0E308
|2147483647 |long "varchar" testing |10000.0 |32767 |09:39:43
|xxxxxxFILTERED-TIMESTAMPxxxxx |"varchar" testing
+chartype string |9223372036854775807 |1993-10-29 |12345.54321 |1.0E308
|2147483647 |long varchar testing |10000.0 |32767 |09:39:43
|xxxxxxFILTERED-TIMESTAMPxxxxx |varchar testing
+chartype string |-9223372036854775808 |1993-10-29 |0.00000 |-1.0E308
|-2147483647 |long varchar testing |-10000.0 |32767 |09:39:43
|xxxxxxFILTERED-TIMESTAMPxxxxx |varchar testing
+"chartype" string |9223372036854775807 |1993-10-29 |-12345.54321 |1.0E308
|2147483647 |long "varchar" testing |10000.0 |32767 |09:39:43
|xxxxxxFILTERED-TIMESTAMPxxxxx |"varchar" testing
+ij> delete from alltypes;
+6 rows inserted/updated/deleted
+ij> --import should work with trigger enabled on append and should not work on
replace
+create table test1(a char(20)) ;
+0 rows inserted/updated/deleted
+ij> create trigger trig_import after INSERT on alltypes
+referencing new as newrow
+for each row mode db2sql
+insert into test1 values(newrow.chartype);
+0 rows inserted/updated/deleted
+ij> call SYSCS_UTIL.SYSCS_IMPORT_TABLE (null, 'alltypes' ,
'extinout/alltypes.del' ,
+ null, null, null, 0) ;
+Statement executed.
+ij> select count(*) from alltypes ;
+1
+-----
+3
+ij> select * from test1;
+A
+-----
+chartype string
+chartype string
+"chartype" string
+ij> delete from alltypes;
+3 rows inserted/updated/deleted
+ij> call SYSCS_UTIL.SYSCS_IMPORT_TABLE (null, 'alltypes' ,
'extinout/alltypes.del' ,
+ null, null, null, 1) ;
+ERROR 38000: The exception 'SQL Exception: Bulk insert replace is not
permitted on 'APP.ALLTYPES' because it has an enabled trigger (TRIG_IMPORT).'
was thrown while evaluating an expression. SQLSTATE: 42Z08: Bulk insert replace
is not permitted on 'APP.ALLTYPES' because it has an enabled trigger
(TRIG_IMPORT).
+ij> select count(*) from alltypes;
+1
+-----
+0
+ij> drop trigger trig_import;
+0 rows inserted/updated/deleted
+ij> drop table test1;
+0 rows inserted/updated/deleted
+ij> --test importing to identity columns
+create table table1(c1 char(30),
+ c2 int generated always as identity,
+ c3 real,
+ c4 char(1));
+0 rows inserted/updated/deleted
+ij> create table table2(c1 char(30),
+ c2 int,
+ c3 real,
+ c4 char(1));
+0 rows inserted/updated/deleted
+ij> insert into table2 values('Robert',100, 45.2, 'J');
+1 row inserted/updated/deleted
+ij> insert into table2 values('Mike',101, 76.9, 'K');
+1 row inserted/updated/deleted
+ij> insert into table2 values('Leo',102, 23.4, 'I');
+1 row inserted/updated/deleted
+ij> call SYSCS_UTIL.SYSCS_EXPORT_QUERY('select c1,c3,c4 from table2' ,
'extinout/import.del' ,
+ null, null, null) ;
+Statement executed.
+ij> CALL SYSCS_UTIL.SYSCS_IMPORT_DATA(NULL,'table1', 'c1,c3,c4' , null,
'extinout/import.del',null, null,null,0);
+Statement executed.
+ij> select * from table1;
+C1 |C2 |C3 |C4
+-----
+Robert |1 |45.2 |J
+Mike |2 |76.9 |K
+Leo |3 |23.4 |I
+ij> delete from table1;
+3 rows inserted/updated/deleted
+ij> call SYSCS_UTIL.SYSCS_EXPORT_TABLE(null , 'table2' ,
'extinout/import.del', null, null, null) ;
+Statement executed.
+ij> --following import should fail becuase of inserting into identity column.
+CALL SYSCS_UTIL.SYSCS_IMPORT_TABLE(NULL, 'table1', 'extinout/import.del',null,
null, null,1);
+ERROR 38000: The exception 'SQL Exception: Attempt to modify an identity
column 'C2'.' was thrown while evaluating an expression. SQLSTATE: 42Z23:
Attempt to modify an identity column 'C2'.
+ij> --following import should be succesful
+CALL SYSCS_UTIL.SYSCS_IMPORT_DATA(NULL, 'table1', 'c1,c3,c4' , '1,3,4',
'extinout/import.del',null, null, null,1);
+Statement executed.
+ij> select * from table1;
+C1 |C2 |C3 |C4
+-----
+Robert |1 |45.2 |J
+Mike |2 |76.9 |K
+Leo |3 |23.4 |I
+ij> update table2 set c2=null;
+3 rows inserted/updated/deleted
+ij> --check null values import to identity columns should also fail
+call SYSCS_UTIL.SYSCS_EXPORT_TABLE(null , 'table2' , 'extinout/import.del' ,
+ null, null, null) ;
+Statement executed.
+ij> CALL SYSCS_UTIL.SYSCS_IMPORT_TABLE(NULL, 'table1',
'extinout/import.del',null, null, null,1);
+ERROR 38000: The exception 'SQL Exception: Attempt to modify an identity
column 'C2'.' was thrown while evaluating an expression. SQLSTATE: 42Z23:
Attempt to modify an identity column 'C2'.
+ij> select * from table1;
+C1 |C2 |C3 |C4
+-----
+Robert |1 |45.2 |J
+Mike |2 |76.9 |K
+Leo |3 |23.4 |I
+ij> --check that replace fails when there dependents and replaced data
+-----does not violate foreign key constraints.
+create table parent(a int not null primary key);
+0 rows inserted/updated/deleted
+ij> insert into parent values (1) , (2) , (3) , (4) ;
+4 rows inserted/updated/deleted
+ij> create table child(b int references parent(a));
+0 rows inserted/updated/deleted
+ij> insert into child values (1) , (2) , (3) , (4) ;
+4 rows inserted/updated/deleted
+ij> call SYSCS_UTIL.SYSCS_EXPORT_QUERY('select * from parent where a < 3' ,
'extinout/parent.del' ,
+ null, null, null) ;
+Statement executed.
+ij> --replace should fail because of dependent table
+CALL SYSCS_UTIL.SYSCS_IMPORT_TABLE(NULL, 'parent', 'extinout/parent.del',null,
null, null,1);
+ERROR 38000: The exception 'SQL Exception: INSERT on table 'PARENT' caused a
violation of foreign key constraint 'xxxxGENERATED-IDxxxx' for key (3). The
statement has been rolled back.' was thrown while evaluating an expression.
SQLSTATE: 23503: INSERT on table 'PARENT' caused a violation of foreign key
constraint 'xxxxGENERATED-IDxxxx' for key (3). The statement has been rolled
back.
+ij> select * from parent;
+A
+-----
+1
+2
+3
+4
+ij> ---test with a file which has a differen records seperators (\n, \r , \r\n)
+create table nt1( a int , b char(30));
+0 rows inserted/updated/deleted
+ij> CALL SYSCS_UTIL.SYSCS_IMPORT_TABLE(NULL, 'nt1', 'extin/mixednl.del',null,
null, null,0);
+Statement executed.
+ij> select * from nt1;
+A |B
+-----
+0 |XXXXXX0
+1 |XXXXXX1
+2 |XXXXXX2
+3 |XXXXXX3
+4 |XXXXXX4
+5 |YYYYY5
+6 |YYYYY6
+7 |YYYYY7
+8 |YYYYY8
+9 |YYYYY9
+10 |ZZZZZZ10
+11 |ZZZZZZ11
+12 |ZZZZZZ12
+13 |ZZZZZZ13
+14 |ZZZZZZ14
+ij> drop table nt1 ;
+0 rows inserted/updated/deleted
+ij> --test case for bug 5977;(with lot of text data)
+create table position_info
+ (
+ position_code varchar(10) not null ,
+ literal_no int not null ,
+ job_category_code varchar(10),
+ summary_description long varchar,
+ detail_description long varchar,
+ web_flag varchar(1)
+ );
+0 rows inserted/updated/deleted
+ij> CALL SYSCS_UTIL.SYSCS_IMPORT_TABLE ('APP', 'position_info',
'extin/position_info.del',
+ null, null, null, 1);
+Statement executed.
+ij> select count(*) from position_info ;
+1
+-----
+680
+ij> select detail_description from position_info where position_code='AG1000';
+DETAIL_DESCRIPTION
+-----
+Essential Duties and Responsibilities (include but not limited to):
+*Assist the director in his work activities in leading the&
+ij> CALL SYSCS_UTIL.SYSCS_EXPORT_TABLE ('APP', 'position_info',
'extinout/pinfo.del',
+ null, null, null);
+Statement executed.
+ij> delete from position_info;
+680 rows inserted/updated/deleted
+ij> CALL SYSCS_UTIL.SYSCS_IMPORT_TABLE ('APP', 'position_info',
'extinout/pinfo.del',
+ null, null, null, 1);
+Statement executed.
+ij> select count(*) from position_info ;
+1
+-----
+680
+ij> select detail_description from position_info where position_code='AG1000';
+DETAIL_DESCRIPTION
+-----
+Essential Duties and Responsibilities (include but not limited to):
+*Assist the director in his work activities in leading the&
+ij>
Property changes on:
java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/ieptests.out
___________________________________________________________________
Name: svn:eol-style
+ native
Index:
java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/LOBTest.out
===================================================================
---
java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/LOBTest.out
(revision 0)
+++
java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/LOBTest.out
(revision 0)
@@ -0,0 +1,3873 @@
+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'.
+insert into bit_table ( col_1 ) values ( 'true' )
+insert into bit_table ( col_2 ) values ( 'true' )
+insert into bit_table ( col_3 ) values ( 'true' )
+insert into bit_table ( col_4 ) values cast ( X'0074007200750065' AS char(10)
for bit data)
+insert into bit_table ( col_5 ) values cast ( X'0074007200750065' AS long
varchar for bit data)
+insert into bit_table ( col_6 ) values cast ( X'0074007200750065' AS blob(80))
+insert into bit_table ( typecol ) values cast ( X'0074007200750065' AS char
(8 ) for bit data)
+=== Columntype int
+select col_0 from bit_table
+ 0 getObject ->'100' : java.lang.Integer
+ 0 getArray -> EXCEPTION (not yet implemented)
+ 0 getAsciiStream -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 0 getBigDecimal ->'100' : java.math.BigDecimal
+ 0 getBinaryStream -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 0 getBlob -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 0 getBoolean ->'true' : java.lang.Boolean
+ 0 getByte ->'100' : java.lang.Byte
+ 0 getBytes -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 0 getCharacterStream -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 0 getClob -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 0 getDate -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 0 getDouble ->'100.0' : java.lang.Double
+ 0 getFloat ->'100.0' : java.lang.Float
+ 0 getInt ->'100' : java.lang.Integer
+ 0 getLong ->'100' : java.lang.Long
+ 0 getRef -> EXCEPTION (not yet implemented)
+ 0 getShort ->'100' : java.lang.Short
+ 0 getString ->'100' : java.lang.String
+ 0 getTime -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 0 getTimeStamp -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+=== Columntype char(10)
+select col_1 from bit_table
+ 1 getObject ->'101 ' : java.lang.String
+ 1 getArray -> EXCEPTION (not yet implemented)
+ 1 getAsciiStream ->Object' : java.io.InputStream
+ 1 getBigDecimal ->'101' : java.math.BigDecimal
+ 1 getBinaryStream -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 1 getBlob -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 1 getBoolean ->'true' : java.lang.Boolean
+ 1 getByte ->'101' : java.lang.Byte
+ 1 getBytes -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 1 getCharacterStream ->Object' : java.io.Reader
+ 1 getClob -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 1 getDate -> EXCEPTION (Invalid data
conversion: Parameter instance 101 is invalid for requested conversion
to java.sql.Date.)
+ 1 getDouble ->'101.0' : java.lang.Double
+ 1 getFloat ->'101.0' : java.lang.Float
+ 1 getInt ->'101' : java.lang.Integer
+ 1 getLong ->'101' : java.lang.Long
+ 1 getRef -> EXCEPTION (not yet implemented)
+ 1 getShort ->'101' : java.lang.Short
+ 1 getString ->'101 ' : java.lang.String
+ 1 getTime -> EXCEPTION (Invalid data
conversion: Parameter instance 101 is invalid for requested conversion
to java.sql.Time.)
+ 1 getTimeStamp -> EXCEPTION (Invalid data
conversion: Parameter instance 101 is invalid for requested conversion
to java.sql.Timestamp.)
+=== Columntype varchar(80)
+select col_2 from bit_table
+ 2 getObject ->'102' : java.lang.String
+ 2 getArray -> EXCEPTION (not yet implemented)
+ 2 getAsciiStream ->Object' : java.io.InputStream
+ 2 getBigDecimal ->'102' : java.math.BigDecimal
+ 2 getBinaryStream -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 2 getBlob -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 2 getBoolean ->'true' : java.lang.Boolean
+ 2 getByte ->'102' : java.lang.Byte
+ 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 getDouble ->'102.0' : java.lang.Double
+ 2 getFloat ->'102.0' : java.lang.Float
+ 2 getInt ->'102' : java.lang.Integer
+ 2 getLong ->'102' : java.lang.Long
+ 2 getRef -> EXCEPTION (not yet implemented)
+ 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)
+=== Columntype long varchar
+select col_3 from bit_table
+ 3 getObject ->'103' : java.lang.String
+ 3 getArray -> EXCEPTION (not yet implemented)
+ 3 getAsciiStream ->Object' : java.io.InputStream
+ 3 getBigDecimal ->'103' : java.math.BigDecimal
+ 3 getBinaryStream -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 3 getBlob -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 3 getBoolean ->'true' : java.lang.Boolean
+ 3 getByte ->'103' : java.lang.Byte
+ 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 getDouble ->'103.0' : java.lang.Double
+ 3 getFloat ->'103.0' : java.lang.Float
+ 3 getInt ->'103' : java.lang.Integer
+ 3 getLong ->'103' : java.lang.Long
+ 3 getRef -> EXCEPTION (not yet implemented)
+ 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)
+=== Columntype char(10) for bit data
+select col_4 from bit_table
+ 4 getObject ->Object' : byte[]
+ 4 getArray -> EXCEPTION (not yet implemented)
+ 4 getAsciiStream ->Object' : java.io.InputStream
+ 4 getBigDecimal -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 4 getBinaryStream ->Object' : java.io.InputStream
+ 4 getBlob -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 4 getBoolean -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 4 getByte -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 4 getBytes ->Object' : byte[]
+ 4 getCharacterStream ->Object' : java.io.Reader
+ 4 getClob -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 4 getDate -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 4 getDouble -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 4 getFloat -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 4 getInt -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 4 getLong -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 4 getRef -> EXCEPTION (not yet implemented)
+ 4 getShort -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 4 getString ->'00310030003420202020' :
java.lang.String
+ 4 getTime -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 4 getTimeStamp -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+=== Columntype long varchar for bit data
+select col_5 from bit_table
+ 5 getObject ->Object' : byte[]
+ 5 getArray -> EXCEPTION (not yet implemented)
+ 5 getAsciiStream ->Object' : java.io.InputStream
+ 5 getBigDecimal -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 5 getBinaryStream ->Object' : java.io.InputStream
+ 5 getBlob -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 5 getBoolean -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 5 getByte -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 5 getBytes ->Object' : byte[]
+ 5 getCharacterStream ->Object' : java.io.Reader
+ 5 getClob -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 5 getDate -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 5 getDouble -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 5 getFloat -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 5 getInt -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 5 getLong -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 5 getRef -> EXCEPTION (not yet implemented)
+ 5 getShort -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 5 getString ->'003100300035' : java.lang.String
+ 5 getTime -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 5 getTimeStamp -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+=== Columntype blob(80)
+select col_6 from bit_table
+ 6 getObject ->Object' : java.sql.Blob
+ 6 getArray -> EXCEPTION (not yet implemented)
+ 6 getAsciiStream ->Object' : java.io.InputStream
+ 6 getBigDecimal -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 6 getBinaryStream ->Object' : java.io.InputStream
+ 6 getBlob ->Object' : java.sql.Blob
+ 6 getBoolean -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 6 getByte -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 6 getBytes ->Object' : byte[]
+ 6 getCharacterStream ->Object' : java.io.Reader
+ 6 getClob -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 6 getDate -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 6 getDouble -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 6 getFloat -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 6 getInt -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 6 getLong -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 6 getRef -> EXCEPTION (not yet implemented)
+ 6 getShort -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 6 getString ->'003100300036' : java.lang.String
+ 6 getTime -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 6 getTimeStamp -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+=== Columntype char (8 ) for bit data
+select typecol from bit_table
+ 7 getObject ->Object' : byte[]
+ 7 getArray -> EXCEPTION (not yet implemented)
+ 7 getAsciiStream ->Object' : java.io.InputStream
+ 7 getBigDecimal -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 7 getBinaryStream ->Object' : java.io.InputStream
+ 7 getBlob -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 7 getBoolean -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 7 getByte -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 7 getBytes ->Object' : byte[]
+ 7 getCharacterStream ->Object' : java.io.Reader
+ 7 getClob -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 7 getDate -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 7 getDouble -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 7 getFloat -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 7 getInt -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 7 getLong -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 7 getRef -> EXCEPTION (not yet implemented)
+ 7 getShort -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 7 getString ->'0031003000372020' : java.lang.String
+ 7 getTime -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 7 getTimeStamp -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+-----< METADATA TESTS
+select col_0 from bit_table
+ ---- 1
+ Column : COL_0
+ Type : 4
+ TypeName : INTEGER
+ ClassName : java.lang.Integer
+ Label : COL_0
+ DisplaySz : 11
+ Precision : 10
+ Scale : 0
+ isCurrency: false
+ isCaseSens: false
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = '100' : java.lang.Integer
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+select col_1 from bit_table
+ ---- 1
+ Column : COL_1
+ Type : 1
+ TypeName : CHAR
+ ClassName : java.lang.String
+ Label : COL_1
+ DisplaySz : 10
+ Precision : 10
+ Scale : 0
+ isCurrency: false
+ isCaseSens: true
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = '101 ' : java.lang.String
+ OUT = 'true ' : java.lang.String
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+select col_2 from bit_table
+ ---- 1
+ Column : COL_2
+ Type : 12
+ TypeName : VARCHAR
+ ClassName : java.lang.String
+ Label : COL_2
+ DisplaySz : 80
+ Precision : 80
+ Scale : 0
+ isCurrency: false
+ isCaseSens: true
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = '102' : java.lang.String
+ OUT = NULL
+ OUT = 'true' : java.lang.String
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+select col_3 from bit_table
+ ---- 1
+ Column : COL_3
+ Type : -1
+ TypeName : LONG VARCHAR
+ ClassName : java.lang.String
+ Label : COL_3
+ DisplaySz : 32700
+ Precision : 32700
+ Scale : 0
+ isCurrency: false
+ isCaseSens: true
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = '103' : java.lang.String
+ OUT = NULL
+ OUT = NULL
+ OUT = 'true' : java.lang.String
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+select col_4 from bit_table
+ ---- 1
+ Column : COL_4
+ Type : -2
+ TypeName : CHAR FOR BIT DATA
+ ClassName : byte[]
+ Label : COL_4
+ DisplaySz : 20
+ Precision : 10
+ Scale : 0
+ isCurrency: false
+ isCaseSens: false
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = Object : byte[]
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = Object : byte[]
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+select col_5 from bit_table
+ ---- 1
+ Column : COL_5
+ Type : -4
+ TypeName : LONG VARCHAR FOR BIT DATA
+ ClassName : byte[]
+ Label : COL_5
+ DisplaySz : 65400
+ Precision : 32700
+ Scale : 0
+ isCurrency: false
+ isCaseSens: false
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = Object : byte[]
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = Object : byte[]
+ OUT = NULL
+ OUT = NULL
+select col_6 from bit_table
+ ---- 1
+ Column : COL_6
+ Type : 2004
+ TypeName : BLOB
+ ClassName : java.sql.Blob
+ Label : COL_6
+ DisplaySz : 160
+ Precision : 80
+ Scale : 0
+ isCurrency: false
+ isCaseSens: false
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = Object : java.sql.Blob
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = Object : java.sql.Blob
+ OUT = NULL
+select typecol from bit_table
+ ---- 1
+ Column : TYPECOL
+ Type : -2
+ TypeName : CHAR FOR BIT DATA
+ ClassName : byte[]
+ Label : TYPECOL
+ DisplaySz : 16
+ Precision : 8
+ Scale : 0
+ isCurrency: false
+ isCaseSens: false
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = Object : byte[]
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ 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'.
+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'.
+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'.
+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'.
+select cast( col_4 as char (8) for bit data ) from bit_table
+ ---- 1
+ Column : 1
+ Type : -2
+ TypeName : CHAR FOR BIT DATA
+ ClassName : byte[]
+ Label : 1
+ DisplaySz : 16
+ Precision : 8
+ Scale : 0
+ isCurrency: false
+ isCaseSens: false
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = Object : byte[]
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = Object : byte[]
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+select cast( col_5 as char (8) for bit data ) from bit_table
+ ---- 1
+ Column : 1
+ Type : -2
+ TypeName : CHAR FOR BIT DATA
+ ClassName : byte[]
+ Label : 1
+ DisplaySz : 16
+ Precision : 8
+ Scale : 0
+ isCurrency: false
+ isCaseSens: false
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = Object : byte[]
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = Object : byte[]
+ 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'.
+select cast( typecol as char (8) for bit data ) from bit_table
+ ---- 1
+ Column : 1
+ Type : -2
+ TypeName : CHAR FOR BIT DATA
+ ClassName : byte[]
+ Label : 1
+ DisplaySz : 16
+ Precision : 8
+ Scale : 0
+ isCurrency: false
+ isCaseSens: false
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = Object : byte[]
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ 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'.
+select cast( typecol as char(10) ) from bit_table
+ com.ibm.db2.jcc.c.SqlException: 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'.
+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'.
+select cast( typecol as char(10) for bit data ) from bit_table
+ ---- 1
+ Column : 1
+ Type : -2
+ TypeName : CHAR FOR BIT DATA
+ ClassName : byte[]
+ Label : 1
+ DisplaySz : 20
+ Precision : 10
+ Scale : 0
+ isCurrency: false
+ isCaseSens: false
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = Object : byte[]
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = Object : byte[]
+select cast( typecol as long varchar for bit data ) from bit_table
+ ---- 1
+ Column : 1
+ Type : -4
+ TypeName : LONG VARCHAR FOR BIT DATA
+ ClassName : byte[]
+ Label : 1
+ DisplaySz : 65400
+ Precision : 32700
+ Scale : 0
+ isCurrency: false
+ isCaseSens: false
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = Object : byte[]
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = Object : byte[]
+select cast( typecol as blob(80) ) from bit_table
+ ---- 1
+ Column : 1
+ Type : 2004
+ TypeName : BLOB
+ ClassName : java.sql.Blob
+ Label : 1
+ DisplaySz : 160
+ Precision : 80
+ Scale : 0
+ isCurrency: false
+ isCaseSens: false
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = Object : java.sql.Blob
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = Object : java.sql.Blob
+select cast( typecol as char (8 ) for bit data ) from bit_table
+ ---- 1
+ Column : 1
+ Type : -2
+ TypeName : CHAR FOR BIT DATA
+ ClassName : byte[]
+ Label : 1
+ DisplaySz : 16
+ Precision : 8
+ Scale : 0
+ isCurrency: false
+ isCaseSens: false
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = Object : byte[]
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = Object : byte[]
+drop table bit_table
+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'.
+insert into bit_table ( col_1 ) values ( 'true' )
+insert into bit_table ( col_2 ) values ( 'true' )
+insert into bit_table ( col_3 ) values ( 'true' )
+insert into bit_table ( col_4 ) values cast ( X'0074007200750065' AS char(10)
for bit data)
+insert into bit_table ( col_5 ) values cast ( X'0074007200750065' AS long
varchar for bit data)
+insert into bit_table ( col_6 ) values cast ( X'0074007200750065' AS blob(80))
+insert into bit_table ( typecol ) values cast ( X'0074007200750065' AS char
(8 ) for bit data)
+=== Columntype int
+select col_0 from bit_table
+ 0 getObject ->'100' : java.lang.Integer
+ 0 getArray -> EXCEPTION (not yet implemented)
+ 0 getAsciiStream -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 0 getBigDecimal ->'100' : java.math.BigDecimal
+ 0 getBinaryStream -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 0 getBlob -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 0 getBoolean ->'true' : java.lang.Boolean
+ 0 getByte ->'100' : java.lang.Byte
+ 0 getBytes -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 0 getCharacterStream -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 0 getClob -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 0 getDate -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 0 getDouble ->'100.0' : java.lang.Double
+ 0 getFloat ->'100.0' : java.lang.Float
+ 0 getInt ->'100' : java.lang.Integer
+ 0 getLong ->'100' : java.lang.Long
+ 0 getRef -> EXCEPTION (not yet implemented)
+ 0 getShort ->'100' : java.lang.Short
+ 0 getString ->'100' : java.lang.String
+ 0 getTime -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 0 getTimeStamp -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+=== Columntype char(10)
+select col_1 from bit_table
+ 1 getObject ->'101 ' : java.lang.String
+ 1 getArray -> EXCEPTION (not yet implemented)
+ 1 getAsciiStream ->Object' : java.io.InputStream
+ 1 getBigDecimal ->'101' : java.math.BigDecimal
+ 1 getBinaryStream -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 1 getBlob -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 1 getBoolean ->'true' : java.lang.Boolean
+ 1 getByte ->'101' : java.lang.Byte
+ 1 getBytes -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 1 getCharacterStream ->Object' : java.io.Reader
+ 1 getClob -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 1 getDate -> EXCEPTION (Invalid data
conversion: Parameter instance 101 is invalid for requested conversion
to java.sql.Date.)
+ 1 getDouble ->'101.0' : java.lang.Double
+ 1 getFloat ->'101.0' : java.lang.Float
+ 1 getInt ->'101' : java.lang.Integer
+ 1 getLong ->'101' : java.lang.Long
+ 1 getRef -> EXCEPTION (not yet implemented)
+ 1 getShort ->'101' : java.lang.Short
+ 1 getString ->'101 ' : java.lang.String
+ 1 getTime -> EXCEPTION (Invalid data
conversion: Parameter instance 101 is invalid for requested conversion
to java.sql.Time.)
+ 1 getTimeStamp -> EXCEPTION (Invalid data
conversion: Parameter instance 101 is invalid for requested conversion
to java.sql.Timestamp.)
+=== Columntype varchar(80)
+select col_2 from bit_table
+ 2 getObject ->'102' : java.lang.String
+ 2 getArray -> EXCEPTION (not yet implemented)
+ 2 getAsciiStream ->Object' : java.io.InputStream
+ 2 getBigDecimal ->'102' : java.math.BigDecimal
+ 2 getBinaryStream -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 2 getBlob -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 2 getBoolean ->'true' : java.lang.Boolean
+ 2 getByte ->'102' : java.lang.Byte
+ 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 getDouble ->'102.0' : java.lang.Double
+ 2 getFloat ->'102.0' : java.lang.Float
+ 2 getInt ->'102' : java.lang.Integer
+ 2 getLong ->'102' : java.lang.Long
+ 2 getRef -> EXCEPTION (not yet implemented)
+ 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)
+=== Columntype long varchar
+select col_3 from bit_table
+ 3 getObject ->'103' : java.lang.String
+ 3 getArray -> EXCEPTION (not yet implemented)
+ 3 getAsciiStream ->Object' : java.io.InputStream
+ 3 getBigDecimal ->'103' : java.math.BigDecimal
+ 3 getBinaryStream -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 3 getBlob -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 3 getBoolean ->'true' : java.lang.Boolean
+ 3 getByte ->'103' : java.lang.Byte
+ 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 getDouble ->'103.0' : java.lang.Double
+ 3 getFloat ->'103.0' : java.lang.Float
+ 3 getInt ->'103' : java.lang.Integer
+ 3 getLong ->'103' : java.lang.Long
+ 3 getRef -> EXCEPTION (not yet implemented)
+ 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)
+=== Columntype char(10) for bit data
+select col_4 from bit_table
+ 4 getObject ->Object' : byte[]
+ 4 getArray -> EXCEPTION (not yet implemented)
+ 4 getAsciiStream ->Object' : java.io.InputStream
+ 4 getBigDecimal -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 4 getBinaryStream ->Object' : java.io.InputStream
+ 4 getBlob -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 4 getBoolean -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 4 getByte -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 4 getBytes ->Object' : byte[]
+ 4 getCharacterStream ->Object' : java.io.Reader
+ 4 getClob -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 4 getDate -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 4 getDouble -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 4 getFloat -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 4 getInt -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 4 getLong -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 4 getRef -> EXCEPTION (not yet implemented)
+ 4 getShort -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 4 getString ->'00310030003420202020' :
java.lang.String
+ 4 getTime -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 4 getTimeStamp -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+=== Columntype long varchar for bit data
+select col_5 from bit_table
+ 5 getObject ->Object' : byte[]
+ 5 getArray -> EXCEPTION (not yet implemented)
+ 5 getAsciiStream ->Object' : java.io.InputStream
+ 5 getBigDecimal -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 5 getBinaryStream ->Object' : java.io.InputStream
+ 5 getBlob -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 5 getBoolean -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 5 getByte -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 5 getBytes ->Object' : byte[]
+ 5 getCharacterStream ->Object' : java.io.Reader
+ 5 getClob -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 5 getDate -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 5 getDouble -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 5 getFloat -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 5 getInt -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 5 getLong -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 5 getRef -> EXCEPTION (not yet implemented)
+ 5 getShort -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 5 getString ->'003100300035' : java.lang.String
+ 5 getTime -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 5 getTimeStamp -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+=== Columntype blob(80)
+select col_6 from bit_table
+ 6 getObject ->Object' : java.sql.Blob
+ 6 getArray -> EXCEPTION (not yet implemented)
+ 6 getAsciiStream ->Object' : java.io.InputStream
+ 6 getBigDecimal -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 6 getBinaryStream ->Object' : java.io.InputStream
+ 6 getBlob ->Object' : java.sql.Blob
+ 6 getBoolean -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 6 getByte -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 6 getBytes ->Object' : byte[]
+ 6 getCharacterStream ->Object' : java.io.Reader
+ 6 getClob -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 6 getDate -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 6 getDouble -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 6 getFloat -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 6 getInt -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 6 getLong -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 6 getRef -> EXCEPTION (not yet implemented)
+ 6 getShort -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 6 getString ->'003100300036' : java.lang.String
+ 6 getTime -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 6 getTimeStamp -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+=== Columntype char (8 ) for bit data
+select typecol from bit_table
+ 7 getObject ->Object' : byte[]
+ 7 getArray -> EXCEPTION (not yet implemented)
+ 7 getAsciiStream ->Object' : java.io.InputStream
+ 7 getBigDecimal -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 7 getBinaryStream ->Object' : java.io.InputStream
+ 7 getBlob -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 7 getBoolean -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 7 getByte -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 7 getBytes ->Object' : byte[]
+ 7 getCharacterStream ->Object' : java.io.Reader
+ 7 getClob -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 7 getDate -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 7 getDouble -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 7 getFloat -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 7 getInt -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 7 getLong -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 7 getRef -> EXCEPTION (not yet implemented)
+ 7 getShort -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 7 getString ->'0031003000372020' : java.lang.String
+ 7 getTime -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 7 getTimeStamp -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+-----< METADATA TESTS
+select col_0 from bit_table
+ ---- 1
+ Column : COL_0
+ Type : 4
+ TypeName : INTEGER
+ ClassName : java.lang.Integer
+ Label : COL_0
+ DisplaySz : 11
+ Precision : 10
+ Scale : 0
+ isCurrency: false
+ isCaseSens: false
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = '100' : java.lang.Integer
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+select col_1 from bit_table
+ ---- 1
+ Column : COL_1
+ Type : 1
+ TypeName : CHAR
+ ClassName : java.lang.String
+ Label : COL_1
+ DisplaySz : 10
+ Precision : 10
+ Scale : 0
+ isCurrency: false
+ isCaseSens: true
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = '101 ' : java.lang.String
+ OUT = 'true ' : java.lang.String
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+select col_2 from bit_table
+ ---- 1
+ Column : COL_2
+ Type : 12
+ TypeName : VARCHAR
+ ClassName : java.lang.String
+ Label : COL_2
+ DisplaySz : 80
+ Precision : 80
+ Scale : 0
+ isCurrency: false
+ isCaseSens: true
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = '102' : java.lang.String
+ OUT = NULL
+ OUT = 'true' : java.lang.String
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+select col_3 from bit_table
+ ---- 1
+ Column : COL_3
+ Type : -1
+ TypeName : LONG VARCHAR
+ ClassName : java.lang.String
+ Label : COL_3
+ DisplaySz : 32700
+ Precision : 32700
+ Scale : 0
+ isCurrency: false
+ isCaseSens: true
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = '103' : java.lang.String
+ OUT = NULL
+ OUT = NULL
+ OUT = 'true' : java.lang.String
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+select col_4 from bit_table
+ ---- 1
+ Column : COL_4
+ Type : -2
+ TypeName : CHAR FOR BIT DATA
+ ClassName : byte[]
+ Label : COL_4
+ DisplaySz : 20
+ Precision : 10
+ Scale : 0
+ isCurrency: false
+ isCaseSens: false
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = Object : byte[]
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = Object : byte[]
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+select col_5 from bit_table
+ ---- 1
+ Column : COL_5
+ Type : -4
+ TypeName : LONG VARCHAR FOR BIT DATA
+ ClassName : byte[]
+ Label : COL_5
+ DisplaySz : 65400
+ Precision : 32700
+ Scale : 0
+ isCurrency: false
+ isCaseSens: false
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = Object : byte[]
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = Object : byte[]
+ OUT = NULL
+ OUT = NULL
+select col_6 from bit_table
+ ---- 1
+ Column : COL_6
+ Type : 2004
+ TypeName : BLOB
+ ClassName : java.sql.Blob
+ Label : COL_6
+ DisplaySz : 160
+ Precision : 80
+ Scale : 0
+ isCurrency: false
+ isCaseSens: false
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = Object : java.sql.Blob
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = Object : java.sql.Blob
+ OUT = NULL
+select typecol from bit_table
+ ---- 1
+ Column : TYPECOL
+ Type : -2
+ TypeName : CHAR FOR BIT DATA
+ ClassName : byte[]
+ Label : TYPECOL
+ DisplaySz : 16
+ Precision : 8
+ Scale : 0
+ isCurrency: false
+ isCaseSens: false
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = Object : byte[]
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ 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'.
+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'.
+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'.
+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'.
+select cast( col_4 as char (8) for bit data ) from bit_table
+ ---- 1
+ Column : 1
+ Type : -2
+ TypeName : CHAR FOR BIT DATA
+ ClassName : byte[]
+ Label : 1
+ DisplaySz : 16
+ Precision : 8
+ Scale : 0
+ isCurrency: false
+ isCaseSens: false
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = Object : byte[]
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = Object : byte[]
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+select cast( col_5 as char (8) for bit data ) from bit_table
+ ---- 1
+ Column : 1
+ Type : -2
+ TypeName : CHAR FOR BIT DATA
+ ClassName : byte[]
+ Label : 1
+ DisplaySz : 16
+ Precision : 8
+ Scale : 0
+ isCurrency: false
+ isCaseSens: false
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = Object : byte[]
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = Object : byte[]
+ 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'.
+select cast( typecol as char (8) for bit data ) from bit_table
+ ---- 1
+ Column : 1
+ Type : -2
+ TypeName : CHAR FOR BIT DATA
+ ClassName : byte[]
+ Label : 1
+ DisplaySz : 16
+ Precision : 8
+ Scale : 0
+ isCurrency: false
+ isCaseSens: false
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = Object : byte[]
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ 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'.
+select cast( typecol as char(10) ) from bit_table
+ com.ibm.db2.jcc.c.SqlException: 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'.
+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'.
+select cast( typecol as char(10) for bit data ) from bit_table
+ ---- 1
+ Column : 1
+ Type : -2
+ TypeName : CHAR FOR BIT DATA
+ ClassName : byte[]
+ Label : 1
+ DisplaySz : 20
+ Precision : 10
+ Scale : 0
+ isCurrency: false
+ isCaseSens: false
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = Object : byte[]
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = Object : byte[]
+select cast( typecol as long varchar for bit data ) from bit_table
+ ---- 1
+ Column : 1
+ Type : -4
+ TypeName : LONG VARCHAR FOR BIT DATA
+ ClassName : byte[]
+ Label : 1
+ DisplaySz : 65400
+ Precision : 32700
+ Scale : 0
+ isCurrency: false
+ isCaseSens: false
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = Object : byte[]
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = Object : byte[]
+select cast( typecol as blob(80) ) from bit_table
+ ---- 1
+ Column : 1
+ Type : 2004
+ TypeName : BLOB
+ ClassName : java.sql.Blob
+ Label : 1
+ DisplaySz : 160
+ Precision : 80
+ Scale : 0
+ isCurrency: false
+ isCaseSens: false
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = Object : java.sql.Blob
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = Object : java.sql.Blob
+select cast( typecol as char (8 ) for bit data ) from bit_table
+ ---- 1
+ Column : 1
+ Type : -2
+ TypeName : CHAR FOR BIT DATA
+ ClassName : byte[]
+ Label : 1
+ DisplaySz : 16
+ Precision : 8
+ Scale : 0
+ isCurrency: false
+ isCaseSens: false
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = Object : byte[]
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = Object : byte[]
+drop table bit_table
+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'.
+insert into blob_table ( col_1 ) values ( 'true' )
+insert into blob_table ( col_2 ) values ( 'true' )
+insert into blob_table ( col_3 ) values ( 'true' )
+insert into blob_table ( col_4 ) values cast ( X'0074007200750065' AS
char(10) for bit data)
+insert into blob_table ( col_5 ) values cast ( X'0074007200750065' AS long
varchar for bit data)
+insert into blob_table ( col_6 ) values cast ( X'0074007200750065' AS
blob(80))
+insert into blob_table ( typecol ) values cast ( X'0074007200750065' AS blob
(2 M))
+=== Columntype int
+select col_0 from blob_table
+ 0 getObject ->'100' : java.lang.Integer
+ 0 getArray -> EXCEPTION (not yet implemented)
+ 0 getAsciiStream -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 0 getBigDecimal ->'100' : java.math.BigDecimal
+ 0 getBinaryStream -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 0 getBlob -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 0 getBoolean ->'true' : java.lang.Boolean
+ 0 getByte ->'100' : java.lang.Byte
+ 0 getBytes -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 0 getCharacterStream -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 0 getClob -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 0 getDate -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 0 getDouble ->'100.0' : java.lang.Double
+ 0 getFloat ->'100.0' : java.lang.Float
+ 0 getInt ->'100' : java.lang.Integer
+ 0 getLong ->'100' : java.lang.Long
+ 0 getRef -> EXCEPTION (not yet implemented)
+ 0 getShort ->'100' : java.lang.Short
+ 0 getString ->'100' : java.lang.String
+ 0 getTime -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 0 getTimeStamp -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+=== Columntype char(10)
+select col_1 from blob_table
+ 1 getObject ->'101 ' : java.lang.String
+ 1 getArray -> EXCEPTION (not yet implemented)
+ 1 getAsciiStream ->Object' : java.io.InputStream
+ 1 getBigDecimal ->'101' : java.math.BigDecimal
+ 1 getBinaryStream -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 1 getBlob -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 1 getBoolean ->'true' : java.lang.Boolean
+ 1 getByte ->'101' : java.lang.Byte
+ 1 getBytes -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 1 getCharacterStream ->Object' : java.io.Reader
+ 1 getClob -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 1 getDate -> EXCEPTION (Invalid data
conversion: Parameter instance 101 is invalid for requested conversion
to java.sql.Date.)
+ 1 getDouble ->'101.0' : java.lang.Double
+ 1 getFloat ->'101.0' : java.lang.Float
+ 1 getInt ->'101' : java.lang.Integer
+ 1 getLong ->'101' : java.lang.Long
+ 1 getRef -> EXCEPTION (not yet implemented)
+ 1 getShort ->'101' : java.lang.Short
+ 1 getString ->'101 ' : java.lang.String
+ 1 getTime -> EXCEPTION (Invalid data
conversion: Parameter instance 101 is invalid for requested conversion
to java.sql.Time.)
+ 1 getTimeStamp -> EXCEPTION (Invalid data
conversion: Parameter instance 101 is invalid for requested conversion
to java.sql.Timestamp.)
+=== Columntype varchar(80)
+select col_2 from blob_table
+ 2 getObject ->'102' : java.lang.String
+ 2 getArray -> EXCEPTION (not yet implemented)
+ 2 getAsciiStream ->Object' : java.io.InputStream
+ 2 getBigDecimal ->'102' : java.math.BigDecimal
+ 2 getBinaryStream -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 2 getBlob -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 2 getBoolean ->'true' : java.lang.Boolean
+ 2 getByte ->'102' : java.lang.Byte
+ 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 getDouble ->'102.0' : java.lang.Double
+ 2 getFloat ->'102.0' : java.lang.Float
+ 2 getInt ->'102' : java.lang.Integer
+ 2 getLong ->'102' : java.lang.Long
+ 2 getRef -> EXCEPTION (not yet implemented)
+ 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)
+=== Columntype long varchar
+select col_3 from blob_table
+ 3 getObject ->'103' : java.lang.String
+ 3 getArray -> EXCEPTION (not yet implemented)
+ 3 getAsciiStream ->Object' : java.io.InputStream
+ 3 getBigDecimal ->'103' : java.math.BigDecimal
+ 3 getBinaryStream -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 3 getBlob -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 3 getBoolean ->'true' : java.lang.Boolean
+ 3 getByte ->'103' : java.lang.Byte
+ 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 getDouble ->'103.0' : java.lang.Double
+ 3 getFloat ->'103.0' : java.lang.Float
+ 3 getInt ->'103' : java.lang.Integer
+ 3 getLong ->'103' : java.lang.Long
+ 3 getRef -> EXCEPTION (not yet implemented)
+ 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)
+=== Columntype char(10) for bit data
+select col_4 from blob_table
+ 4 getObject ->Object' : byte[]
+ 4 getArray -> EXCEPTION (not yet implemented)
+ 4 getAsciiStream ->Object' : java.io.InputStream
+ 4 getBigDecimal -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 4 getBinaryStream ->Object' : java.io.InputStream
+ 4 getBlob -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 4 getBoolean -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 4 getByte -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 4 getBytes ->Object' : byte[]
+ 4 getCharacterStream ->Object' : java.io.Reader
+ 4 getClob -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 4 getDate -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 4 getDouble -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 4 getFloat -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 4 getInt -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 4 getLong -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 4 getRef -> EXCEPTION (not yet implemented)
+ 4 getShort -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 4 getString ->'00310030003420202020' :
java.lang.String
+ 4 getTime -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 4 getTimeStamp -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+=== Columntype long varchar for bit data
+select col_5 from blob_table
+ 5 getObject ->Object' : byte[]
+ 5 getArray -> EXCEPTION (not yet implemented)
+ 5 getAsciiStream ->Object' : java.io.InputStream
+ 5 getBigDecimal -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 5 getBinaryStream ->Object' : java.io.InputStream
+ 5 getBlob -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 5 getBoolean -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 5 getByte -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 5 getBytes ->Object' : byte[]
+ 5 getCharacterStream ->Object' : java.io.Reader
+ 5 getClob -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 5 getDate -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 5 getDouble -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 5 getFloat -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 5 getInt -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 5 getLong -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 5 getRef -> EXCEPTION (not yet implemented)
+ 5 getShort -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 5 getString ->'003100300035' : java.lang.String
+ 5 getTime -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 5 getTimeStamp -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+=== Columntype blob(80)
+select col_6 from blob_table
+ 6 getObject ->Object' : java.sql.Blob
+ 6 getArray -> EXCEPTION (not yet implemented)
+ 6 getAsciiStream ->Object' : java.io.InputStream
+ 6 getBigDecimal -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 6 getBinaryStream ->Object' : java.io.InputStream
+ 6 getBlob ->Object' : java.sql.Blob
+ 6 getBoolean -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 6 getByte -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 6 getBytes ->Object' : byte[]
+ 6 getCharacterStream ->Object' : java.io.Reader
+ 6 getClob -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 6 getDate -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 6 getDouble -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 6 getFloat -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 6 getInt -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 6 getLong -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 6 getRef -> EXCEPTION (not yet implemented)
+ 6 getShort -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 6 getString ->'003100300036' : java.lang.String
+ 6 getTime -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 6 getTimeStamp -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+=== Columntype blob (2 M)
+select typecol from blob_table
+ 7 getObject ->Object' : java.sql.Blob
+ 7 getArray -> EXCEPTION (not yet implemented)
+ 7 getAsciiStream ->Object' : java.io.InputStream
+ 7 getBigDecimal -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 7 getBinaryStream ->Object' : java.io.InputStream
+ 7 getBlob ->Object' : java.sql.Blob
+ 7 getBoolean -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 7 getByte -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 7 getBytes ->Object' : byte[]
+ 7 getCharacterStream ->Object' : java.io.Reader
+ 7 getClob -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 7 getDate -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 7 getDouble -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 7 getFloat -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 7 getInt -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 7 getLong -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 7 getRef -> EXCEPTION (not yet implemented)
+ 7 getShort -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 7 getString ->'003100300037' : java.lang.String
+ 7 getTime -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 7 getTimeStamp -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+-----< METADATA TESTS
+select col_0 from blob_table
+ ---- 1
+ Column : COL_0
+ Type : 4
+ TypeName : INTEGER
+ ClassName : java.lang.Integer
+ Label : COL_0
+ DisplaySz : 11
+ Precision : 10
+ Scale : 0
+ isCurrency: false
+ isCaseSens: false
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = '100' : java.lang.Integer
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+select col_1 from blob_table
+ ---- 1
+ Column : COL_1
+ Type : 1
+ TypeName : CHAR
+ ClassName : java.lang.String
+ Label : COL_1
+ DisplaySz : 10
+ Precision : 10
+ Scale : 0
+ isCurrency: false
+ isCaseSens: true
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = '101 ' : java.lang.String
+ OUT = 'true ' : java.lang.String
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+select col_2 from blob_table
+ ---- 1
+ Column : COL_2
+ Type : 12
+ TypeName : VARCHAR
+ ClassName : java.lang.String
+ Label : COL_2
+ DisplaySz : 80
+ Precision : 80
+ Scale : 0
+ isCurrency: false
+ isCaseSens: true
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = '102' : java.lang.String
+ OUT = NULL
+ OUT = 'true' : java.lang.String
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+select col_3 from blob_table
+ ---- 1
+ Column : COL_3
+ Type : -1
+ TypeName : LONG VARCHAR
+ ClassName : java.lang.String
+ Label : COL_3
+ DisplaySz : 32700
+ Precision : 32700
+ Scale : 0
+ isCurrency: false
+ isCaseSens: true
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = '103' : java.lang.String
+ OUT = NULL
+ OUT = NULL
+ OUT = 'true' : java.lang.String
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+select col_4 from blob_table
+ ---- 1
+ Column : COL_4
+ Type : -2
+ TypeName : CHAR FOR BIT DATA
+ ClassName : byte[]
+ Label : COL_4
+ DisplaySz : 20
+ Precision : 10
+ Scale : 0
+ isCurrency: false
+ isCaseSens: false
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = Object : byte[]
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = Object : byte[]
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+select col_5 from blob_table
+ ---- 1
+ Column : COL_5
+ Type : -4
+ TypeName : LONG VARCHAR FOR BIT DATA
+ ClassName : byte[]
+ Label : COL_5
+ DisplaySz : 65400
+ Precision : 32700
+ Scale : 0
+ isCurrency: false
+ isCaseSens: false
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = Object : byte[]
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = Object : byte[]
+ OUT = NULL
+ OUT = NULL
+select col_6 from blob_table
+ ---- 1
+ Column : COL_6
+ Type : 2004
+ TypeName : BLOB
+ ClassName : java.sql.Blob
+ Label : COL_6
+ DisplaySz : 160
+ Precision : 80
+ Scale : 0
+ isCurrency: false
+ isCaseSens: false
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = Object : java.sql.Blob
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = Object : java.sql.Blob
+ OUT = NULL
+select typecol from blob_table
+ ---- 1
+ Column : TYPECOL
+ Type : 2004
+ TypeName : BLOB
+ ClassName : java.sql.Blob
+ Label : TYPECOL
+ DisplaySz : 4194304
+ Precision : 2097152
+ Scale : 0
+ isCurrency: false
+ isCaseSens: false
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = Object : java.sql.Blob
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ 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'.
+select cast( col_1 as blob(2 M) ) from blob_table
+ com.ibm.db2.jcc.c.SqlException: 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'.
+select cast( col_3 as blob(2 M) ) from blob_table
+ com.ibm.db2.jcc.c.SqlException: Cannot convert types 'LONG VARCHAR' to
'BLOB'.
+select cast( col_4 as blob(2 M) ) from blob_table
+ ---- 1
+ Column : 1
+ Type : 2004
+ TypeName : BLOB
+ ClassName : java.sql.Blob
+ Label : 1
+ DisplaySz : 4194304
+ Precision : 2097152
+ Scale : 0
+ isCurrency: false
+ isCaseSens: false
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = Object : java.sql.Blob
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = Object : java.sql.Blob
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+select cast( col_5 as blob(2 M) ) from blob_table
+ ---- 1
+ Column : 1
+ Type : 2004
+ TypeName : BLOB
+ ClassName : java.sql.Blob
+ Label : 1
+ DisplaySz : 4194304
+ Precision : 2097152
+ Scale : 0
+ isCurrency: false
+ isCaseSens: false
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = Object : java.sql.Blob
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = Object : java.sql.Blob
+ OUT = NULL
+ OUT = NULL
+select cast( col_6 as blob(2 M) ) from blob_table
+ ---- 1
+ Column : 1
+ Type : 2004
+ TypeName : BLOB
+ ClassName : java.sql.Blob
+ Label : 1
+ DisplaySz : 4194304
+ Precision : 2097152
+ Scale : 0
+ isCurrency: false
+ isCaseSens: false
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = Object : java.sql.Blob
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = Object : java.sql.Blob
+ OUT = NULL
+select cast( typecol as blob(2 M) ) from blob_table
+ ---- 1
+ Column : 1
+ Type : 2004
+ TypeName : BLOB
+ ClassName : java.sql.Blob
+ Label : 1
+ DisplaySz : 4194304
+ Precision : 2097152
+ Scale : 0
+ isCurrency: false
+ isCaseSens: false
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = Object : java.sql.Blob
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ 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'.
+select cast( typecol as char(10) ) from blob_table
+ com.ibm.db2.jcc.c.SqlException: 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'.
+select cast( typecol as long varchar ) from blob_table
+ com.ibm.db2.jcc.c.SqlException: 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'.
+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'.
+select cast( typecol as blob(80) ) from blob_table
+ ---- 1
+ Column : 1
+ Type : 2004
+ TypeName : BLOB
+ ClassName : java.sql.Blob
+ Label : 1
+ DisplaySz : 160
+ Precision : 80
+ Scale : 0
+ isCurrency: false
+ isCaseSens: false
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = Object : java.sql.Blob
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = Object : java.sql.Blob
+select cast( typecol as blob (2 M) ) from blob_table
+ ---- 1
+ Column : 1
+ Type : 2004
+ TypeName : BLOB
+ ClassName : java.sql.Blob
+ Label : 1
+ DisplaySz : 4194304
+ Precision : 2097152
+ Scale : 0
+ isCurrency: false
+ isCaseSens: false
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = Object : java.sql.Blob
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = Object : java.sql.Blob
+drop table blob_table
+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'.
+insert into blob_table ( col_1 ) values ( 'true' )
+insert into blob_table ( col_2 ) values ( 'true' )
+insert into blob_table ( col_3 ) values ( 'true' )
+insert into blob_table ( col_4 ) values cast ( X'0074007200750065' AS
char(10) for bit data)
+insert into blob_table ( col_5 ) values cast ( X'0074007200750065' AS long
varchar for bit data)
+insert into blob_table ( col_6 ) values cast ( X'0074007200750065' AS
blob(80))
+insert into blob_table ( typecol ) values cast ( X'0074007200750065' AS blob
(2 K))
+=== Columntype int
+select col_0 from blob_table
+ 0 getObject ->'100' : java.lang.Integer
+ 0 getArray -> EXCEPTION (not yet implemented)
+ 0 getAsciiStream -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 0 getBigDecimal ->'100' : java.math.BigDecimal
+ 0 getBinaryStream -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 0 getBlob -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 0 getBoolean ->'true' : java.lang.Boolean
+ 0 getByte ->'100' : java.lang.Byte
+ 0 getBytes -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 0 getCharacterStream -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 0 getClob -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 0 getDate -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 0 getDouble ->'100.0' : java.lang.Double
+ 0 getFloat ->'100.0' : java.lang.Float
+ 0 getInt ->'100' : java.lang.Integer
+ 0 getLong ->'100' : java.lang.Long
+ 0 getRef -> EXCEPTION (not yet implemented)
+ 0 getShort ->'100' : java.lang.Short
+ 0 getString ->'100' : java.lang.String
+ 0 getTime -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 0 getTimeStamp -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+=== Columntype char(10)
+select col_1 from blob_table
+ 1 getObject ->'101 ' : java.lang.String
+ 1 getArray -> EXCEPTION (not yet implemented)
+ 1 getAsciiStream ->Object' : java.io.InputStream
+ 1 getBigDecimal ->'101' : java.math.BigDecimal
+ 1 getBinaryStream -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 1 getBlob -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 1 getBoolean ->'true' : java.lang.Boolean
+ 1 getByte ->'101' : java.lang.Byte
+ 1 getBytes -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 1 getCharacterStream ->Object' : java.io.Reader
+ 1 getClob -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 1 getDate -> EXCEPTION (Invalid data
conversion: Parameter instance 101 is invalid for requested conversion
to java.sql.Date.)
+ 1 getDouble ->'101.0' : java.lang.Double
+ 1 getFloat ->'101.0' : java.lang.Float
+ 1 getInt ->'101' : java.lang.Integer
+ 1 getLong ->'101' : java.lang.Long
+ 1 getRef -> EXCEPTION (not yet implemented)
+ 1 getShort ->'101' : java.lang.Short
+ 1 getString ->'101 ' : java.lang.String
+ 1 getTime -> EXCEPTION (Invalid data
conversion: Parameter instance 101 is invalid for requested conversion
to java.sql.Time.)
+ 1 getTimeStamp -> EXCEPTION (Invalid data
conversion: Parameter instance 101 is invalid for requested conversion
to java.sql.Timestamp.)
+=== Columntype varchar(80)
+select col_2 from blob_table
+ 2 getObject ->'102' : java.lang.String
+ 2 getArray -> EXCEPTION (not yet implemented)
+ 2 getAsciiStream ->Object' : java.io.InputStream
+ 2 getBigDecimal ->'102' : java.math.BigDecimal
+ 2 getBinaryStream -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 2 getBlob -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 2 getBoolean ->'true' : java.lang.Boolean
+ 2 getByte ->'102' : java.lang.Byte
+ 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 getDouble ->'102.0' : java.lang.Double
+ 2 getFloat ->'102.0' : java.lang.Float
+ 2 getInt ->'102' : java.lang.Integer
+ 2 getLong ->'102' : java.lang.Long
+ 2 getRef -> EXCEPTION (not yet implemented)
+ 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)
+=== Columntype long varchar
+select col_3 from blob_table
+ 3 getObject ->'103' : java.lang.String
+ 3 getArray -> EXCEPTION (not yet implemented)
+ 3 getAsciiStream ->Object' : java.io.InputStream
+ 3 getBigDecimal ->'103' : java.math.BigDecimal
+ 3 getBinaryStream -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 3 getBlob -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 3 getBoolean ->'true' : java.lang.Boolean
+ 3 getByte ->'103' : java.lang.Byte
+ 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 getDouble ->'103.0' : java.lang.Double
+ 3 getFloat ->'103.0' : java.lang.Float
+ 3 getInt ->'103' : java.lang.Integer
+ 3 getLong ->'103' : java.lang.Long
+ 3 getRef -> EXCEPTION (not yet implemented)
+ 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)
+=== Columntype char(10) for bit data
+select col_4 from blob_table
+ 4 getObject ->Object' : byte[]
+ 4 getArray -> EXCEPTION (not yet implemented)
+ 4 getAsciiStream ->Object' : java.io.InputStream
+ 4 getBigDecimal -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 4 getBinaryStream ->Object' : java.io.InputStream
+ 4 getBlob -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 4 getBoolean -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 4 getByte -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 4 getBytes ->Object' : byte[]
+ 4 getCharacterStream ->Object' : java.io.Reader
+ 4 getClob -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 4 getDate -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 4 getDouble -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 4 getFloat -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 4 getInt -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 4 getLong -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 4 getRef -> EXCEPTION (not yet implemented)
+ 4 getShort -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 4 getString ->'00310030003420202020' :
java.lang.String
+ 4 getTime -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 4 getTimeStamp -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+=== Columntype long varchar for bit data
+select col_5 from blob_table
+ 5 getObject ->Object' : byte[]
+ 5 getArray -> EXCEPTION (not yet implemented)
+ 5 getAsciiStream ->Object' : java.io.InputStream
+ 5 getBigDecimal -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 5 getBinaryStream ->Object' : java.io.InputStream
+ 5 getBlob -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 5 getBoolean -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 5 getByte -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 5 getBytes ->Object' : byte[]
+ 5 getCharacterStream ->Object' : java.io.Reader
+ 5 getClob -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 5 getDate -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 5 getDouble -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 5 getFloat -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 5 getInt -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 5 getLong -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 5 getRef -> EXCEPTION (not yet implemented)
+ 5 getShort -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 5 getString ->'003100300035' : java.lang.String
+ 5 getTime -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 5 getTimeStamp -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+=== Columntype blob(80)
+select col_6 from blob_table
+ 6 getObject ->Object' : java.sql.Blob
+ 6 getArray -> EXCEPTION (not yet implemented)
+ 6 getAsciiStream ->Object' : java.io.InputStream
+ 6 getBigDecimal -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 6 getBinaryStream ->Object' : java.io.InputStream
+ 6 getBlob ->Object' : java.sql.Blob
+ 6 getBoolean -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 6 getByte -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 6 getBytes ->Object' : byte[]
+ 6 getCharacterStream ->Object' : java.io.Reader
+ 6 getClob -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 6 getDate -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 6 getDouble -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 6 getFloat -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 6 getInt -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 6 getLong -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 6 getRef -> EXCEPTION (not yet implemented)
+ 6 getShort -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 6 getString ->'003100300036' : java.lang.String
+ 6 getTime -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 6 getTimeStamp -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+=== Columntype blob (2 K)
+select typecol from blob_table
+ 7 getObject ->Object' : java.sql.Blob
+ 7 getArray -> EXCEPTION (not yet implemented)
+ 7 getAsciiStream ->Object' : java.io.InputStream
+ 7 getBigDecimal -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 7 getBinaryStream ->Object' : java.io.InputStream
+ 7 getBlob ->Object' : java.sql.Blob
+ 7 getBoolean -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 7 getByte -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 7 getBytes ->Object' : byte[]
+ 7 getCharacterStream ->Object' : java.io.Reader
+ 7 getClob -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 7 getDate -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 7 getDouble -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 7 getFloat -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 7 getInt -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 7 getLong -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 7 getRef -> EXCEPTION (not yet implemented)
+ 7 getShort -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 7 getString ->'003100300037' : java.lang.String
+ 7 getTime -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 7 getTimeStamp -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+-----< METADATA TESTS
+select col_0 from blob_table
+ ---- 1
+ Column : COL_0
+ Type : 4
+ TypeName : INTEGER
+ ClassName : java.lang.Integer
+ Label : COL_0
+ DisplaySz : 11
+ Precision : 10
+ Scale : 0
+ isCurrency: false
+ isCaseSens: false
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = '100' : java.lang.Integer
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+select col_1 from blob_table
+ ---- 1
+ Column : COL_1
+ Type : 1
+ TypeName : CHAR
+ ClassName : java.lang.String
+ Label : COL_1
+ DisplaySz : 10
+ Precision : 10
+ Scale : 0
+ isCurrency: false
+ isCaseSens: true
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = '101 ' : java.lang.String
+ OUT = 'true ' : java.lang.String
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+select col_2 from blob_table
+ ---- 1
+ Column : COL_2
+ Type : 12
+ TypeName : VARCHAR
+ ClassName : java.lang.String
+ Label : COL_2
+ DisplaySz : 80
+ Precision : 80
+ Scale : 0
+ isCurrency: false
+ isCaseSens: true
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = '102' : java.lang.String
+ OUT = NULL
+ OUT = 'true' : java.lang.String
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+select col_3 from blob_table
+ ---- 1
+ Column : COL_3
+ Type : -1
+ TypeName : LONG VARCHAR
+ ClassName : java.lang.String
+ Label : COL_3
+ DisplaySz : 32700
+ Precision : 32700
+ Scale : 0
+ isCurrency: false
+ isCaseSens: true
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = '103' : java.lang.String
+ OUT = NULL
+ OUT = NULL
+ OUT = 'true' : java.lang.String
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+select col_4 from blob_table
+ ---- 1
+ Column : COL_4
+ Type : -2
+ TypeName : CHAR FOR BIT DATA
+ ClassName : byte[]
+ Label : COL_4
+ DisplaySz : 20
+ Precision : 10
+ Scale : 0
+ isCurrency: false
+ isCaseSens: false
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = Object : byte[]
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = Object : byte[]
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+select col_5 from blob_table
+ ---- 1
+ Column : COL_5
+ Type : -4
+ TypeName : LONG VARCHAR FOR BIT DATA
+ ClassName : byte[]
+ Label : COL_5
+ DisplaySz : 65400
+ Precision : 32700
+ Scale : 0
+ isCurrency: false
+ isCaseSens: false
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = Object : byte[]
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = Object : byte[]
+ OUT = NULL
+ OUT = NULL
+select col_6 from blob_table
+ ---- 1
+ Column : COL_6
+ Type : 2004
+ TypeName : BLOB
+ ClassName : java.sql.Blob
+ Label : COL_6
+ DisplaySz : 160
+ Precision : 80
+ Scale : 0
+ isCurrency: false
+ isCaseSens: false
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = Object : java.sql.Blob
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = Object : java.sql.Blob
+ OUT = NULL
+select typecol from blob_table
+ ---- 1
+ Column : TYPECOL
+ Type : 2004
+ TypeName : BLOB
+ ClassName : java.sql.Blob
+ Label : TYPECOL
+ DisplaySz : 4096
+ Precision : 2048
+ Scale : 0
+ isCurrency: false
+ isCaseSens: false
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = Object : java.sql.Blob
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ 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'.
+select cast( col_1 as blob(2 K) ) from blob_table
+ com.ibm.db2.jcc.c.SqlException: 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'.
+select cast( col_3 as blob(2 K) ) from blob_table
+ com.ibm.db2.jcc.c.SqlException: Cannot convert types 'LONG VARCHAR' to
'BLOB'.
+select cast( col_4 as blob(2 K) ) from blob_table
+ ---- 1
+ Column : 1
+ Type : 2004
+ TypeName : BLOB
+ ClassName : java.sql.Blob
+ Label : 1
+ DisplaySz : 4096
+ Precision : 2048
+ Scale : 0
+ isCurrency: false
+ isCaseSens: false
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = Object : java.sql.Blob
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = Object : java.sql.Blob
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+select cast( col_5 as blob(2 K) ) from blob_table
+ ---- 1
+ Column : 1
+ Type : 2004
+ TypeName : BLOB
+ ClassName : java.sql.Blob
+ Label : 1
+ DisplaySz : 4096
+ Precision : 2048
+ Scale : 0
+ isCurrency: false
+ isCaseSens: false
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = Object : java.sql.Blob
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = Object : java.sql.Blob
+ OUT = NULL
+ OUT = NULL
+select cast( col_6 as blob(2 K) ) from blob_table
+ ---- 1
+ Column : 1
+ Type : 2004
+ TypeName : BLOB
+ ClassName : java.sql.Blob
+ Label : 1
+ DisplaySz : 4096
+ Precision : 2048
+ Scale : 0
+ isCurrency: false
+ isCaseSens: false
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = Object : java.sql.Blob
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = Object : java.sql.Blob
+ OUT = NULL
+select cast( typecol as blob(2 K) ) from blob_table
+ ---- 1
+ Column : 1
+ Type : 2004
+ TypeName : BLOB
+ ClassName : java.sql.Blob
+ Label : 1
+ DisplaySz : 4096
+ Precision : 2048
+ Scale : 0
+ isCurrency: false
+ isCaseSens: false
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = Object : java.sql.Blob
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ 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'.
+select cast( typecol as char(10) ) from blob_table
+ com.ibm.db2.jcc.c.SqlException: 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'.
+select cast( typecol as long varchar ) from blob_table
+ com.ibm.db2.jcc.c.SqlException: 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'.
+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'.
+select cast( typecol as blob(80) ) from blob_table
+ ---- 1
+ Column : 1
+ Type : 2004
+ TypeName : BLOB
+ ClassName : java.sql.Blob
+ Label : 1
+ DisplaySz : 160
+ Precision : 80
+ Scale : 0
+ isCurrency: false
+ isCaseSens: false
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = Object : java.sql.Blob
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = Object : java.sql.Blob
+select cast( typecol as blob (2 K) ) from blob_table
+ ---- 1
+ Column : 1
+ Type : 2004
+ TypeName : BLOB
+ ClassName : java.sql.Blob
+ Label : 1
+ DisplaySz : 4096
+ Precision : 2048
+ Scale : 0
+ isCurrency: false
+ isCaseSens: false
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = Object : java.sql.Blob
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = Object : java.sql.Blob
+drop table blob_table
+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'.
+insert into blob_table ( col_1 ) values ( 'true' )
+insert into blob_table ( col_2 ) values ( 'true' )
+insert into blob_table ( col_3 ) values ( 'true' )
+insert into blob_table ( col_4 ) values cast ( X'0074007200750065' AS
char(10) for bit data)
+insert into blob_table ( col_5 ) values cast ( X'0074007200750065' AS long
varchar for bit data)
+insert into blob_table ( col_6 ) values cast ( X'0074007200750065' AS
blob(80))
+insert into blob_table ( typecol ) values cast ( X'0074007200750065' AS blob
(64 ))
+=== Columntype int
+select col_0 from blob_table
+ 0 getObject ->'100' : java.lang.Integer
+ 0 getArray -> EXCEPTION (not yet implemented)
+ 0 getAsciiStream -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 0 getBigDecimal ->'100' : java.math.BigDecimal
+ 0 getBinaryStream -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 0 getBlob -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 0 getBoolean ->'true' : java.lang.Boolean
+ 0 getByte ->'100' : java.lang.Byte
+ 0 getBytes -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 0 getCharacterStream -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 0 getClob -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 0 getDate -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 0 getDouble ->'100.0' : java.lang.Double
+ 0 getFloat ->'100.0' : java.lang.Float
+ 0 getInt ->'100' : java.lang.Integer
+ 0 getLong ->'100' : java.lang.Long
+ 0 getRef -> EXCEPTION (not yet implemented)
+ 0 getShort ->'100' : java.lang.Short
+ 0 getString ->'100' : java.lang.String
+ 0 getTime -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 0 getTimeStamp -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+=== Columntype char(10)
+select col_1 from blob_table
+ 1 getObject ->'101 ' : java.lang.String
+ 1 getArray -> EXCEPTION (not yet implemented)
+ 1 getAsciiStream ->Object' : java.io.InputStream
+ 1 getBigDecimal ->'101' : java.math.BigDecimal
+ 1 getBinaryStream -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 1 getBlob -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 1 getBoolean ->'true' : java.lang.Boolean
+ 1 getByte ->'101' : java.lang.Byte
+ 1 getBytes -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 1 getCharacterStream ->Object' : java.io.Reader
+ 1 getClob -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 1 getDate -> EXCEPTION (Invalid data
conversion: Parameter instance 101 is invalid for requested conversion
to java.sql.Date.)
+ 1 getDouble ->'101.0' : java.lang.Double
+ 1 getFloat ->'101.0' : java.lang.Float
+ 1 getInt ->'101' : java.lang.Integer
+ 1 getLong ->'101' : java.lang.Long
+ 1 getRef -> EXCEPTION (not yet implemented)
+ 1 getShort ->'101' : java.lang.Short
+ 1 getString ->'101 ' : java.lang.String
+ 1 getTime -> EXCEPTION (Invalid data
conversion: Parameter instance 101 is invalid for requested conversion
to java.sql.Time.)
+ 1 getTimeStamp -> EXCEPTION (Invalid data
conversion: Parameter instance 101 is invalid for requested conversion
to java.sql.Timestamp.)
+=== Columntype varchar(80)
+select col_2 from blob_table
+ 2 getObject ->'102' : java.lang.String
+ 2 getArray -> EXCEPTION (not yet implemented)
+ 2 getAsciiStream ->Object' : java.io.InputStream
+ 2 getBigDecimal ->'102' : java.math.BigDecimal
+ 2 getBinaryStream -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 2 getBlob -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 2 getBoolean ->'true' : java.lang.Boolean
+ 2 getByte ->'102' : java.lang.Byte
+ 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 getDouble ->'102.0' : java.lang.Double
+ 2 getFloat ->'102.0' : java.lang.Float
+ 2 getInt ->'102' : java.lang.Integer
+ 2 getLong ->'102' : java.lang.Long
+ 2 getRef -> EXCEPTION (not yet implemented)
+ 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)
+=== Columntype long varchar
+select col_3 from blob_table
+ 3 getObject ->'103' : java.lang.String
+ 3 getArray -> EXCEPTION (not yet implemented)
+ 3 getAsciiStream ->Object' : java.io.InputStream
+ 3 getBigDecimal ->'103' : java.math.BigDecimal
+ 3 getBinaryStream -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 3 getBlob -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 3 getBoolean ->'true' : java.lang.Boolean
+ 3 getByte ->'103' : java.lang.Byte
+ 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 getDouble ->'103.0' : java.lang.Double
+ 3 getFloat ->'103.0' : java.lang.Float
+ 3 getInt ->'103' : java.lang.Integer
+ 3 getLong ->'103' : java.lang.Long
+ 3 getRef -> EXCEPTION (not yet implemented)
+ 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)
+=== Columntype char(10) for bit data
+select col_4 from blob_table
+ 4 getObject ->Object' : byte[]
+ 4 getArray -> EXCEPTION (not yet implemented)
+ 4 getAsciiStream ->Object' : java.io.InputStream
+ 4 getBigDecimal -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 4 getBinaryStream ->Object' : java.io.InputStream
+ 4 getBlob -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 4 getBoolean -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 4 getByte -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 4 getBytes ->Object' : byte[]
+ 4 getCharacterStream ->Object' : java.io.Reader
+ 4 getClob -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 4 getDate -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 4 getDouble -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 4 getFloat -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 4 getInt -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 4 getLong -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 4 getRef -> EXCEPTION (not yet implemented)
+ 4 getShort -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 4 getString ->'00310030003420202020' :
java.lang.String
+ 4 getTime -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 4 getTimeStamp -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+=== Columntype long varchar for bit data
+select col_5 from blob_table
+ 5 getObject ->Object' : byte[]
+ 5 getArray -> EXCEPTION (not yet implemented)
+ 5 getAsciiStream ->Object' : java.io.InputStream
+ 5 getBigDecimal -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 5 getBinaryStream ->Object' : java.io.InputStream
+ 5 getBlob -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 5 getBoolean -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 5 getByte -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 5 getBytes ->Object' : byte[]
+ 5 getCharacterStream ->Object' : java.io.Reader
+ 5 getClob -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 5 getDate -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 5 getDouble -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 5 getFloat -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 5 getInt -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 5 getLong -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 5 getRef -> EXCEPTION (not yet implemented)
+ 5 getShort -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 5 getString ->'003100300035' : java.lang.String
+ 5 getTime -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 5 getTimeStamp -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+=== Columntype blob(80)
+select col_6 from blob_table
+ 6 getObject ->Object' : java.sql.Blob
+ 6 getArray -> EXCEPTION (not yet implemented)
+ 6 getAsciiStream ->Object' : java.io.InputStream
+ 6 getBigDecimal -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 6 getBinaryStream ->Object' : java.io.InputStream
+ 6 getBlob ->Object' : java.sql.Blob
+ 6 getBoolean -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 6 getByte -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 6 getBytes ->Object' : byte[]
+ 6 getCharacterStream ->Object' : java.io.Reader
+ 6 getClob -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 6 getDate -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 6 getDouble -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 6 getFloat -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 6 getInt -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 6 getLong -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 6 getRef -> EXCEPTION (not yet implemented)
+ 6 getShort -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 6 getString ->'003100300036' : java.lang.String
+ 6 getTime -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 6 getTimeStamp -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+=== Columntype blob (64 )
+select typecol from blob_table
+ 7 getObject ->Object' : java.sql.Blob
+ 7 getArray -> EXCEPTION (not yet implemented)
+ 7 getAsciiStream ->Object' : java.io.InputStream
+ 7 getBigDecimal -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 7 getBinaryStream ->Object' : java.io.InputStream
+ 7 getBlob ->Object' : java.sql.Blob
+ 7 getBoolean -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 7 getByte -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 7 getBytes ->Object' : byte[]
+ 7 getCharacterStream ->Object' : java.io.Reader
+ 7 getClob -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 7 getDate -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 7 getDouble -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 7 getFloat -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 7 getInt -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 7 getLong -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 7 getRef -> EXCEPTION (not yet implemented)
+ 7 getShort -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 7 getString ->'003100300037' : java.lang.String
+ 7 getTime -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 7 getTimeStamp -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+-----< METADATA TESTS
+select col_0 from blob_table
+ ---- 1
+ Column : COL_0
+ Type : 4
+ TypeName : INTEGER
+ ClassName : java.lang.Integer
+ Label : COL_0
+ DisplaySz : 11
+ Precision : 10
+ Scale : 0
+ isCurrency: false
+ isCaseSens: false
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = '100' : java.lang.Integer
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+select col_1 from blob_table
+ ---- 1
+ Column : COL_1
+ Type : 1
+ TypeName : CHAR
+ ClassName : java.lang.String
+ Label : COL_1
+ DisplaySz : 10
+ Precision : 10
+ Scale : 0
+ isCurrency: false
+ isCaseSens: true
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = '101 ' : java.lang.String
+ OUT = 'true ' : java.lang.String
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+select col_2 from blob_table
+ ---- 1
+ Column : COL_2
+ Type : 12
+ TypeName : VARCHAR
+ ClassName : java.lang.String
+ Label : COL_2
+ DisplaySz : 80
+ Precision : 80
+ Scale : 0
+ isCurrency: false
+ isCaseSens: true
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = '102' : java.lang.String
+ OUT = NULL
+ OUT = 'true' : java.lang.String
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+select col_3 from blob_table
+ ---- 1
+ Column : COL_3
+ Type : -1
+ TypeName : LONG VARCHAR
+ ClassName : java.lang.String
+ Label : COL_3
+ DisplaySz : 32700
+ Precision : 32700
+ Scale : 0
+ isCurrency: false
+ isCaseSens: true
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = '103' : java.lang.String
+ OUT = NULL
+ OUT = NULL
+ OUT = 'true' : java.lang.String
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+select col_4 from blob_table
+ ---- 1
+ Column : COL_4
+ Type : -2
+ TypeName : CHAR FOR BIT DATA
+ ClassName : byte[]
+ Label : COL_4
+ DisplaySz : 20
+ Precision : 10
+ Scale : 0
+ isCurrency: false
+ isCaseSens: false
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = Object : byte[]
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = Object : byte[]
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+select col_5 from blob_table
+ ---- 1
+ Column : COL_5
+ Type : -4
+ TypeName : LONG VARCHAR FOR BIT DATA
+ ClassName : byte[]
+ Label : COL_5
+ DisplaySz : 65400
+ Precision : 32700
+ Scale : 0
+ isCurrency: false
+ isCaseSens: false
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = Object : byte[]
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = Object : byte[]
+ OUT = NULL
+ OUT = NULL
+select col_6 from blob_table
+ ---- 1
+ Column : COL_6
+ Type : 2004
+ TypeName : BLOB
+ ClassName : java.sql.Blob
+ Label : COL_6
+ DisplaySz : 160
+ Precision : 80
+ Scale : 0
+ isCurrency: false
+ isCaseSens: false
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = Object : java.sql.Blob
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = Object : java.sql.Blob
+ OUT = NULL
+select typecol from blob_table
+ ---- 1
+ Column : TYPECOL
+ Type : 2004
+ TypeName : BLOB
+ ClassName : java.sql.Blob
+ Label : TYPECOL
+ DisplaySz : 128
+ Precision : 64
+ Scale : 0
+ isCurrency: false
+ isCaseSens: false
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = Object : java.sql.Blob
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ 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'.
+select cast( col_1 as blob(64 ) ) from blob_table
+ com.ibm.db2.jcc.c.SqlException: 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'.
+select cast( col_3 as blob(64 ) ) from blob_table
+ com.ibm.db2.jcc.c.SqlException: Cannot convert types 'LONG VARCHAR' to
'BLOB'.
+select cast( col_4 as blob(64 ) ) from blob_table
+ ---- 1
+ Column : 1
+ Type : 2004
+ TypeName : BLOB
+ ClassName : java.sql.Blob
+ Label : 1
+ DisplaySz : 128
+ Precision : 64
+ Scale : 0
+ isCurrency: false
+ isCaseSens: false
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = Object : java.sql.Blob
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = Object : java.sql.Blob
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+select cast( col_5 as blob(64 ) ) from blob_table
+ ---- 1
+ Column : 1
+ Type : 2004
+ TypeName : BLOB
+ ClassName : java.sql.Blob
+ Label : 1
+ DisplaySz : 128
+ Precision : 64
+ Scale : 0
+ isCurrency: false
+ isCaseSens: false
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = Object : java.sql.Blob
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = Object : java.sql.Blob
+ OUT = NULL
+ OUT = NULL
+select cast( col_6 as blob(64 ) ) from blob_table
+ ---- 1
+ Column : 1
+ Type : 2004
+ TypeName : BLOB
+ ClassName : java.sql.Blob
+ Label : 1
+ DisplaySz : 128
+ Precision : 64
+ Scale : 0
+ isCurrency: false
+ isCaseSens: false
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = Object : java.sql.Blob
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = Object : java.sql.Blob
+ OUT = NULL
+select cast( typecol as blob(64 ) ) from blob_table
+ ---- 1
+ Column : 1
+ Type : 2004
+ TypeName : BLOB
+ ClassName : java.sql.Blob
+ Label : 1
+ DisplaySz : 128
+ Precision : 64
+ Scale : 0
+ isCurrency: false
+ isCaseSens: false
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = Object : java.sql.Blob
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ 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'.
+select cast( typecol as char(10) ) from blob_table
+ com.ibm.db2.jcc.c.SqlException: 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'.
+select cast( typecol as long varchar ) from blob_table
+ com.ibm.db2.jcc.c.SqlException: 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'.
+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'.
+select cast( typecol as blob(80) ) from blob_table
+ ---- 1
+ Column : 1
+ Type : 2004
+ TypeName : BLOB
+ ClassName : java.sql.Blob
+ Label : 1
+ DisplaySz : 160
+ Precision : 80
+ Scale : 0
+ isCurrency: false
+ isCaseSens: false
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = Object : java.sql.Blob
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = Object : java.sql.Blob
+select cast( typecol as blob (64 ) ) from blob_table
+ ---- 1
+ Column : 1
+ Type : 2004
+ TypeName : BLOB
+ ClassName : java.sql.Blob
+ Label : 1
+ DisplaySz : 128
+ Precision : 64
+ Scale : 0
+ isCurrency: false
+ isCaseSens: false
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = Object : java.sql.Blob
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = Object : java.sql.Blob
+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'.
+insert into clob_table ( col_0 ) values ( 'true' )
+ com.ibm.db2.jcc.c.SqlException: 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' )
+insert into clob_table ( col_4 ) values cast ( X'0074007200750065' AS
char(10) for bit data)
+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'.
+=== Columntype int
+select col_0 from clob_table
+ 0 getObject -> EXCEPTION (null)
+ 0 getArray -> EXCEPTION (jdbc 2 method not
yet implemented)
+ 0 getAsciiStream -> EXCEPTION (null)
+ 0 getBigDecimal -> EXCEPTION (null)
+ 0 getBinaryStream -> EXCEPTION (null)
+ 0 getBlob -> EXCEPTION (null)
+ 0 getBoolean ->'false' : java.lang.Boolean
+ 0 getByte ->'0' : java.lang.Byte
+ 0 getBytes -> EXCEPTION (null)
+ 0 getCharacterStream -> EXCEPTION (null)
+ 0 getClob -> EXCEPTION (null)
+ 0 getDate -> EXCEPTION (null)
+ 0 getDouble ->'0.0' : java.lang.Double
+ 0 getFloat ->'0.0' : java.lang.Float
+ 0 getInt ->'0' : java.lang.Integer
+ 0 getLong ->'0' : java.lang.Long
+ 0 getRef -> EXCEPTION (jdbc 2 method not
yet implemented)
+ 0 getShort ->'0' : java.lang.Short
+ 0 getString -> EXCEPTION (null)
+ 0 getTime -> EXCEPTION (null)
+ 0 getTimeStamp -> EXCEPTION (null)
+=== Columntype char(10)
+select col_1 from clob_table
+ 1 getObject ->'true ' : java.lang.String
+ 1 getArray -> EXCEPTION (not yet implemented)
+ 1 getAsciiStream ->Object' : java.io.InputStream
+ 1 getBigDecimal -> EXCEPTION (Invalid data
conversion: Parameter instance true is invalid for requested conversion
to java.math.BigDecimal.)
+ 1 getBinaryStream -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 1 getBlob -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 1 getBoolean ->'true' : java.lang.Boolean
+ 1 getByte -> EXCEPTION (Invalid data
conversion: Parameter instance true is invalid for requested conversion
to byte.)
+ 1 getBytes -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 1 getCharacterStream ->Object' : java.io.Reader
+ 1 getClob -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 1 getDate -> EXCEPTION (Invalid data
conversion: Parameter instance true is invalid for requested conversion
to java.sql.Date.)
+ 1 getDouble -> EXCEPTION (Invalid data
conversion: Parameter instance true is invalid for requested conversion
to double.)
+ 1 getFloat -> EXCEPTION (Invalid data
conversion: Parameter instance true is invalid for requested conversion
to float.)
+ 1 getInt -> EXCEPTION (Invalid data
conversion: Parameter instance true is invalid for requested conversion
to int.)
+ 1 getLong -> EXCEPTION (Invalid data
conversion: Parameter instance true is invalid for requested conversion
to long.)
+ 1 getRef -> EXCEPTION (not yet implemented)
+ 1 getShort -> EXCEPTION (Invalid data
conversion: Parameter instance true is invalid for requested conversion
to short.)
+ 1 getString ->'true ' : java.lang.String
+ 1 getTime -> EXCEPTION (Invalid data
conversion: Parameter instance true is invalid for requested conversion
to java.sql.Time.)
+ 1 getTimeStamp -> EXCEPTION (Invalid data
conversion: Parameter instance true is invalid for requested conversion
to java.sql.Timestamp.)
+=== Columntype varchar(80)
+select col_2 from clob_table
+ 2 getObject -> EXCEPTION (null)
+ 2 getArray -> EXCEPTION (jdbc 2 method not
yet implemented)
+ 2 getAsciiStream -> EXCEPTION (null)
+ 2 getBigDecimal -> EXCEPTION (null)
+ 2 getBinaryStream -> EXCEPTION (null)
+ 2 getBlob -> EXCEPTION (null)
+ 2 getBoolean ->'false' : java.lang.Boolean
+ 2 getByte ->'0' : java.lang.Byte
+ 2 getBytes -> EXCEPTION (null)
+ 2 getCharacterStream -> EXCEPTION (null)
+ 2 getClob -> EXCEPTION (null)
+ 2 getDate -> EXCEPTION (null)
+ 2 getDouble ->'0.0' : java.lang.Double
+ 2 getFloat ->'0.0' : java.lang.Float
+ 2 getInt ->'0' : java.lang.Integer
+ 2 getLong ->'0' : java.lang.Long
+ 2 getRef -> EXCEPTION (jdbc 2 method not
yet implemented)
+ 2 getShort ->'0' : java.lang.Short
+ 2 getString -> EXCEPTION (null)
+ 2 getTime -> EXCEPTION (null)
+ 2 getTimeStamp -> EXCEPTION (null)
+=== Columntype long varchar
+select col_3 from clob_table
+ 3 getObject -> EXCEPTION (null)
+ 3 getArray -> EXCEPTION (jdbc 2 method not
yet implemented)
+ 3 getAsciiStream -> EXCEPTION (null)
+ 3 getBigDecimal -> EXCEPTION (null)
+ 3 getBinaryStream -> EXCEPTION (null)
+ 3 getBlob -> EXCEPTION (null)
+ 3 getBoolean ->'false' : java.lang.Boolean
+ 3 getByte ->'0' : java.lang.Byte
+ 3 getBytes -> EXCEPTION (null)
+ 3 getCharacterStream -> EXCEPTION (null)
+ 3 getClob -> EXCEPTION (null)
+ 3 getDate -> EXCEPTION (null)
+ 3 getDouble ->'0.0' : java.lang.Double
+ 3 getFloat ->'0.0' : java.lang.Float
+ 3 getInt ->'0' : java.lang.Integer
+ 3 getLong ->'0' : java.lang.Long
+ 3 getRef -> EXCEPTION (jdbc 2 method not
yet implemented)
+ 3 getShort ->'0' : java.lang.Short
+ 3 getString -> EXCEPTION (null)
+ 3 getTime -> EXCEPTION (null)
+ 3 getTimeStamp -> EXCEPTION (null)
+=== Columntype char(10) for bit data
+select col_4 from clob_table
+ 4 getObject -> EXCEPTION (null)
+ 4 getArray -> EXCEPTION (jdbc 2 method not
yet implemented)
+ 4 getAsciiStream -> EXCEPTION (null)
+ 4 getBigDecimal -> EXCEPTION (null)
+ 4 getBinaryStream -> EXCEPTION (null)
+ 4 getBlob -> EXCEPTION (null)
+ 4 getBoolean ->'false' : java.lang.Boolean
+ 4 getByte ->'0' : java.lang.Byte
+ 4 getBytes -> EXCEPTION (null)
+ 4 getCharacterStream -> EXCEPTION (null)
+ 4 getClob -> EXCEPTION (null)
+ 4 getDate -> EXCEPTION (null)
+ 4 getDouble ->'0.0' : java.lang.Double
+ 4 getFloat ->'0.0' : java.lang.Float
+ 4 getInt ->'0' : java.lang.Integer
+ 4 getLong ->'0' : java.lang.Long
+ 4 getRef -> EXCEPTION (jdbc 2 method not
yet implemented)
+ 4 getShort ->'0' : java.lang.Short
+ 4 getString -> EXCEPTION (null)
+ 4 getTime -> EXCEPTION (null)
+ 4 getTimeStamp -> EXCEPTION (null)
+=== Columntype long varchar for bit data
+select col_5 from clob_table
+ 5 getObject -> EXCEPTION (null)
+ 5 getArray -> EXCEPTION (jdbc 2 method not
yet implemented)
+ 5 getAsciiStream -> EXCEPTION (null)
+ 5 getBigDecimal -> EXCEPTION (null)
+ 5 getBinaryStream -> EXCEPTION (null)
+ 5 getBlob -> EXCEPTION (null)
+ 5 getBoolean ->'false' : java.lang.Boolean
+ 5 getByte ->'0' : java.lang.Byte
+ 5 getBytes -> EXCEPTION (null)
+ 5 getCharacterStream -> EXCEPTION (null)
+ 5 getClob -> EXCEPTION (null)
+ 5 getDate -> EXCEPTION (null)
+ 5 getDouble ->'0.0' : java.lang.Double
+ 5 getFloat ->'0.0' : java.lang.Float
+ 5 getInt ->'0' : java.lang.Integer
+ 5 getLong ->'0' : java.lang.Long
+ 5 getRef -> EXCEPTION (jdbc 2 method not
yet implemented)
+ 5 getShort ->'0' : java.lang.Short
+ 5 getString -> EXCEPTION (null)
+ 5 getTime -> EXCEPTION (null)
+ 5 getTimeStamp -> EXCEPTION (null)
+=== Columntype blob(80)
+select col_6 from clob_table
+ 6 getObject -> EXCEPTION (null)
+ 6 getArray -> EXCEPTION (jdbc 2 method not
yet implemented)
+ 6 getAsciiStream -> EXCEPTION (null)
+ 6 getBigDecimal -> EXCEPTION (null)
+ 6 getBinaryStream -> EXCEPTION (null)
+ 6 getBlob -> EXCEPTION (null)
+ 6 getBoolean ->'false' : java.lang.Boolean
+ 6 getByte ->'0' : java.lang.Byte
+ 6 getBytes -> EXCEPTION (null)
+ 6 getCharacterStream -> EXCEPTION (null)
+ 6 getClob -> EXCEPTION (null)
+ 6 getDate -> EXCEPTION (null)
+ 6 getDouble ->'0.0' : java.lang.Double
+ 6 getFloat ->'0.0' : java.lang.Float
+ 6 getInt ->'0' : java.lang.Integer
+ 6 getLong ->'0' : java.lang.Long
+ 6 getRef -> EXCEPTION (jdbc 2 method not
yet implemented)
+ 6 getShort ->'0' : java.lang.Short
+ 6 getString -> EXCEPTION (null)
+ 6 getTime -> EXCEPTION (null)
+ 6 getTimeStamp -> EXCEPTION (null)
+=== Columntype clob (2 K)
+select typecol from clob_table
+ 7 getObject -> EXCEPTION (null)
+ 7 getArray -> EXCEPTION (jdbc 2 method not
yet implemented)
+ 7 getAsciiStream -> EXCEPTION (null)
+ 7 getBigDecimal -> EXCEPTION (null)
+ 7 getBinaryStream -> EXCEPTION (null)
+ 7 getBlob -> EXCEPTION (null)
+ 7 getBoolean ->'false' : java.lang.Boolean
+ 7 getByte ->'0' : java.lang.Byte
+ 7 getBytes -> EXCEPTION (null)
+ 7 getCharacterStream -> EXCEPTION (null)
+ 7 getClob -> EXCEPTION (null)
+ 7 getDate -> EXCEPTION (null)
+ 7 getDouble ->'0.0' : java.lang.Double
+ 7 getFloat ->'0.0' : java.lang.Float
+ 7 getInt ->'0' : java.lang.Integer
+ 7 getLong ->'0' : java.lang.Long
+ 7 getRef -> EXCEPTION (jdbc 2 method not
yet implemented)
+ 7 getShort ->'0' : java.lang.Short
+ 7 getString -> EXCEPTION (null)
+ 7 getTime -> EXCEPTION (null)
+ 7 getTimeStamp -> EXCEPTION (null)
+-----< METADATA TESTS
+select col_0 from clob_table
+ ---- 1
+ Column : COL_0
+ Type : 4
+ TypeName : INTEGER
+ ClassName : java.lang.Integer
+ Label : COL_0
+ DisplaySz : 11
+ Precision : 10
+ Scale : 0
+ isCurrency: false
+ isCaseSens: false
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+select col_1 from clob_table
+ ---- 1
+ Column : COL_1
+ Type : 1
+ TypeName : CHAR
+ ClassName : java.lang.String
+ Label : COL_1
+ DisplaySz : 10
+ Precision : 10
+ Scale : 0
+ isCurrency: false
+ isCaseSens: true
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = 'true ' : java.lang.String
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+select col_2 from clob_table
+ ---- 1
+ Column : COL_2
+ Type : 12
+ TypeName : VARCHAR
+ ClassName : java.lang.String
+ Label : COL_2
+ DisplaySz : 80
+ Precision : 80
+ Scale : 0
+ isCurrency: false
+ isCaseSens: true
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = NULL
+ OUT = 'true' : java.lang.String
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+select col_3 from clob_table
+ ---- 1
+ Column : COL_3
+ Type : -1
+ TypeName : LONG VARCHAR
+ ClassName : java.lang.String
+ Label : COL_3
+ DisplaySz : 32700
+ Precision : 32700
+ Scale : 0
+ isCurrency: false
+ isCaseSens: true
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = NULL
+ OUT = NULL
+ OUT = 'true' : java.lang.String
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+select col_4 from clob_table
+ ---- 1
+ Column : COL_4
+ Type : -2
+ TypeName : CHAR FOR BIT DATA
+ ClassName : byte[]
+ Label : COL_4
+ DisplaySz : 20
+ Precision : 10
+ Scale : 0
+ isCurrency: false
+ isCaseSens: false
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = Object : byte[]
+ OUT = NULL
+ OUT = NULL
+select col_5 from clob_table
+ ---- 1
+ Column : COL_5
+ Type : -4
+ TypeName : LONG VARCHAR FOR BIT DATA
+ ClassName : byte[]
+ Label : COL_5
+ DisplaySz : 65400
+ Precision : 32700
+ Scale : 0
+ isCurrency: false
+ isCaseSens: false
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = Object : byte[]
+ OUT = NULL
+select col_6 from clob_table
+ ---- 1
+ Column : COL_6
+ Type : 2004
+ TypeName : BLOB
+ ClassName : java.sql.Blob
+ Label : COL_6
+ DisplaySz : 160
+ Precision : 80
+ Scale : 0
+ isCurrency: false
+ isCaseSens: false
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = Object : java.sql.Blob
+select typecol from clob_table
+ ---- 1
+ Column : TYPECOL
+ Type : 2005
+ TypeName : CLOB
+ ClassName : java.sql.Clob
+ Label : TYPECOL
+ DisplaySz : 2048
+ Precision : 2048
+ Scale : 0
+ isCurrency: false
+ isCaseSens: true
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ 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'.
+select cast( col_1 as clob(2 K) ) from clob_table
+ ---- 1
+ Column : 1
+ Type : 2005
+ TypeName : CLOB
+ ClassName : java.sql.Clob
+ Label : 1
+ DisplaySz : 2048
+ Precision : 2048
+ Scale : 0
+ isCurrency: false
+ isCaseSens: true
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = Object : java.sql.Clob
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+select cast( col_2 as clob(2 K) ) from clob_table
+ ---- 1
+ Column : 1
+ Type : 2005
+ TypeName : CLOB
+ ClassName : java.sql.Clob
+ Label : 1
+ DisplaySz : 2048
+ Precision : 2048
+ Scale : 0
+ isCurrency: false
+ isCaseSens: true
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = NULL
+ OUT = Object : java.sql.Clob
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+select cast( col_3 as clob(2 K) ) from clob_table
+ ---- 1
+ Column : 1
+ Type : 2005
+ TypeName : CLOB
+ ClassName : java.sql.Clob
+ Label : 1
+ DisplaySz : 2048
+ Precision : 2048
+ Scale : 0
+ isCurrency: false
+ isCaseSens: true
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = NULL
+ OUT = NULL
+ OUT = Object : java.sql.Clob
+ OUT = NULL
+ 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'.
+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'.
+select cast( col_6 as clob(2 K) ) from clob_table
+ com.ibm.db2.jcc.c.SqlException: Cannot convert types 'BLOB' to 'CLOB'.
+select cast( typecol as clob(2 K) ) from clob_table
+ ---- 1
+ Column : 1
+ Type : 2005
+ TypeName : CLOB
+ ClassName : java.sql.Clob
+ Label : 1
+ DisplaySz : 2048
+ Precision : 2048
+ Scale : 0
+ isCurrency: false
+ isCaseSens: true
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ 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'.
+select cast( typecol as char(10) ) from clob_table
+ ---- 1
+ Column : 1
+ Type : 1
+ TypeName : CHAR
+ ClassName : java.lang.String
+ Label : 1
+ DisplaySz : 10
+ Precision : 10
+ Scale : 0
+ isCurrency: false
+ isCaseSens: true
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+select cast( typecol as varchar(80) ) from clob_table
+ ---- 1
+ Column : 1
+ Type : 12
+ TypeName : VARCHAR
+ ClassName : java.lang.String
+ Label : 1
+ DisplaySz : 80
+ Precision : 80
+ Scale : 0
+ isCurrency: false
+ isCaseSens: true
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+select cast( typecol as long varchar ) from clob_table
+ ---- 1
+ Column : 1
+ Type : -1
+ TypeName : LONG VARCHAR
+ ClassName : java.lang.String
+ Label : 1
+ DisplaySz : 32700
+ Precision : 32700
+ Scale : 0
+ isCurrency: false
+ isCaseSens: true
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ 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'.
+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'.
+select cast( typecol as blob(80) ) from clob_table
+ com.ibm.db2.jcc.c.SqlException: Cannot convert types 'CLOB' to 'BLOB'.
+select cast( typecol as clob (2 K) ) from clob_table
+ ---- 1
+ Column : 1
+ Type : 2005
+ TypeName : CLOB
+ ClassName : java.sql.Clob
+ Label : 1
+ DisplaySz : 2048
+ Precision : 2048
+ Scale : 0
+ isCurrency: false
+ isCaseSens: true
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+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'.
+insert into clob_table ( col_0 ) values ( 'true' )
+ com.ibm.db2.jcc.c.SqlException: 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' )
+insert into clob_table ( col_4 ) values cast ( X'0074007200750065' AS
char(10) for bit data)
+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'.
+=== Columntype int
+select col_0 from clob_table
+ 0 getObject -> EXCEPTION (null)
+ 0 getArray -> EXCEPTION (jdbc 2 method not
yet implemented)
+ 0 getAsciiStream -> EXCEPTION (null)
+ 0 getBigDecimal -> EXCEPTION (null)
+ 0 getBinaryStream -> EXCEPTION (null)
+ 0 getBlob -> EXCEPTION (null)
+ 0 getBoolean ->'false' : java.lang.Boolean
+ 0 getByte ->'0' : java.lang.Byte
+ 0 getBytes -> EXCEPTION (null)
+ 0 getCharacterStream -> EXCEPTION (null)
+ 0 getClob -> EXCEPTION (null)
+ 0 getDate -> EXCEPTION (null)
+ 0 getDouble ->'0.0' : java.lang.Double
+ 0 getFloat ->'0.0' : java.lang.Float
+ 0 getInt ->'0' : java.lang.Integer
+ 0 getLong ->'0' : java.lang.Long
+ 0 getRef -> EXCEPTION (jdbc 2 method not
yet implemented)
+ 0 getShort ->'0' : java.lang.Short
+ 0 getString -> EXCEPTION (null)
+ 0 getTime -> EXCEPTION (null)
+ 0 getTimeStamp -> EXCEPTION (null)
+=== Columntype char(10)
+select col_1 from clob_table
+ 1 getObject ->'true ' : java.lang.String
+ 1 getArray -> EXCEPTION (not yet implemented)
+ 1 getAsciiStream ->Object' : java.io.InputStream
+ 1 getBigDecimal -> EXCEPTION (Invalid data
conversion: Parameter instance true is invalid for requested conversion
to java.math.BigDecimal.)
+ 1 getBinaryStream -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 1 getBlob -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 1 getBoolean ->'true' : java.lang.Boolean
+ 1 getByte -> EXCEPTION (Invalid data
conversion: Parameter instance true is invalid for requested conversion
to byte.)
+ 1 getBytes -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 1 getCharacterStream ->Object' : java.io.Reader
+ 1 getClob -> EXCEPTION (Invalid data
conversion: Wrong result column type for requested conversion.)
+ 1 getDate -> EXCEPTION (Invalid data
conversion: Parameter instance true is invalid for requested conversion
to java.sql.Date.)
+ 1 getDouble -> EXCEPTION (Invalid data
conversion: Parameter instance true is invalid for requested conversion
to double.)
+ 1 getFloat -> EXCEPTION (Invalid data
conversion: Parameter instance true is invalid for requested conversion
to float.)
+ 1 getInt -> EXCEPTION (Invalid data
conversion: Parameter instance true is invalid for requested conversion
to int.)
+ 1 getLong -> EXCEPTION (Invalid data
conversion: Parameter instance true is invalid for requested conversion
to long.)
+ 1 getRef -> EXCEPTION (not yet implemented)
+ 1 getShort -> EXCEPTION (Invalid data
conversion: Parameter instance true is invalid for requested conversion
to short.)
+ 1 getString ->'true ' : java.lang.String
+ 1 getTime -> EXCEPTION (Invalid data
conversion: Parameter instance true is invalid for requested conversion
to java.sql.Time.)
+ 1 getTimeStamp -> EXCEPTION (Invalid data
conversion: Parameter instance true is invalid for requested conversion
to java.sql.Timestamp.)
+=== Columntype varchar(80)
+select col_2 from clob_table
+ 2 getObject -> EXCEPTION (null)
+ 2 getArray -> EXCEPTION (jdbc 2 method not
yet implemented)
+ 2 getAsciiStream -> EXCEPTION (null)
+ 2 getBigDecimal -> EXCEPTION (null)
+ 2 getBinaryStream -> EXCEPTION (null)
+ 2 getBlob -> EXCEPTION (null)
+ 2 getBoolean ->'false' : java.lang.Boolean
+ 2 getByte ->'0' : java.lang.Byte
+ 2 getBytes -> EXCEPTION (null)
+ 2 getCharacterStream -> EXCEPTION (null)
+ 2 getClob -> EXCEPTION (null)
+ 2 getDate -> EXCEPTION (null)
+ 2 getDouble ->'0.0' : java.lang.Double
+ 2 getFloat ->'0.0' : java.lang.Float
+ 2 getInt ->'0' : java.lang.Integer
+ 2 getLong ->'0' : java.lang.Long
+ 2 getRef -> EXCEPTION (jdbc 2 method not
yet implemented)
+ 2 getShort ->'0' : java.lang.Short
+ 2 getString -> EXCEPTION (null)
+ 2 getTime -> EXCEPTION (null)
+ 2 getTimeStamp -> EXCEPTION (null)
+=== Columntype long varchar
+select col_3 from clob_table
+ 3 getObject -> EXCEPTION (null)
+ 3 getArray -> EXCEPTION (jdbc 2 method not
yet implemented)
+ 3 getAsciiStream -> EXCEPTION (null)
+ 3 getBigDecimal -> EXCEPTION (null)
+ 3 getBinaryStream -> EXCEPTION (null)
+ 3 getBlob -> EXCEPTION (null)
+ 3 getBoolean ->'false' : java.lang.Boolean
+ 3 getByte ->'0' : java.lang.Byte
+ 3 getBytes -> EXCEPTION (null)
+ 3 getCharacterStream -> EXCEPTION (null)
+ 3 getClob -> EXCEPTION (null)
+ 3 getDate -> EXCEPTION (null)
+ 3 getDouble ->'0.0' : java.lang.Double
+ 3 getFloat ->'0.0' : java.lang.Float
+ 3 getInt ->'0' : java.lang.Integer
+ 3 getLong ->'0' : java.lang.Long
+ 3 getRef -> EXCEPTION (jdbc 2 method not
yet implemented)
+ 3 getShort ->'0' : java.lang.Short
+ 3 getString -> EXCEPTION (null)
+ 3 getTime -> EXCEPTION (null)
+ 3 getTimeStamp -> EXCEPTION (null)
+=== Columntype char(10) for bit data
+select col_4 from clob_table
+ 4 getObject -> EXCEPTION (null)
+ 4 getArray -> EXCEPTION (jdbc 2 method not
yet implemented)
+ 4 getAsciiStream -> EXCEPTION (null)
+ 4 getBigDecimal -> EXCEPTION (null)
+ 4 getBinaryStream -> EXCEPTION (null)
+ 4 getBlob -> EXCEPTION (null)
+ 4 getBoolean ->'false' : java.lang.Boolean
+ 4 getByte ->'0' : java.lang.Byte
+ 4 getBytes -> EXCEPTION (null)
+ 4 getCharacterStream -> EXCEPTION (null)
+ 4 getClob -> EXCEPTION (null)
+ 4 getDate -> EXCEPTION (null)
+ 4 getDouble ->'0.0' : java.lang.Double
+ 4 getFloat ->'0.0' : java.lang.Float
+ 4 getInt ->'0' : java.lang.Integer
+ 4 getLong ->'0' : java.lang.Long
+ 4 getRef -> EXCEPTION (jdbc 2 method not
yet implemented)
+ 4 getShort ->'0' : java.lang.Short
+ 4 getString -> EXCEPTION (null)
+ 4 getTime -> EXCEPTION (null)
+ 4 getTimeStamp -> EXCEPTION (null)
+=== Columntype long varchar for bit data
+select col_5 from clob_table
+ 5 getObject -> EXCEPTION (null)
+ 5 getArray -> EXCEPTION (jdbc 2 method not
yet implemented)
+ 5 getAsciiStream -> EXCEPTION (null)
+ 5 getBigDecimal -> EXCEPTION (null)
+ 5 getBinaryStream -> EXCEPTION (null)
+ 5 getBlob -> EXCEPTION (null)
+ 5 getBoolean ->'false' : java.lang.Boolean
+ 5 getByte ->'0' : java.lang.Byte
+ 5 getBytes -> EXCEPTION (null)
+ 5 getCharacterStream -> EXCEPTION (null)
+ 5 getClob -> EXCEPTION (null)
+ 5 getDate -> EXCEPTION (null)
+ 5 getDouble ->'0.0' : java.lang.Double
+ 5 getFloat ->'0.0' : java.lang.Float
+ 5 getInt ->'0' : java.lang.Integer
+ 5 getLong ->'0' : java.lang.Long
+ 5 getRef -> EXCEPTION (jdbc 2 method not
yet implemented)
+ 5 getShort ->'0' : java.lang.Short
+ 5 getString -> EXCEPTION (null)
+ 5 getTime -> EXCEPTION (null)
+ 5 getTimeStamp -> EXCEPTION (null)
+=== Columntype blob(80)
+select col_6 from clob_table
+ 6 getObject -> EXCEPTION (null)
+ 6 getArray -> EXCEPTION (jdbc 2 method not
yet implemented)
+ 6 getAsciiStream -> EXCEPTION (null)
+ 6 getBigDecimal -> EXCEPTION (null)
+ 6 getBinaryStream -> EXCEPTION (null)
+ 6 getBlob -> EXCEPTION (null)
+ 6 getBoolean ->'false' : java.lang.Boolean
+ 6 getByte ->'0' : java.lang.Byte
+ 6 getBytes -> EXCEPTION (null)
+ 6 getCharacterStream -> EXCEPTION (null)
+ 6 getClob -> EXCEPTION (null)
+ 6 getDate -> EXCEPTION (null)
+ 6 getDouble ->'0.0' : java.lang.Double
+ 6 getFloat ->'0.0' : java.lang.Float
+ 6 getInt ->'0' : java.lang.Integer
+ 6 getLong ->'0' : java.lang.Long
+ 6 getRef -> EXCEPTION (jdbc 2 method not
yet implemented)
+ 6 getShort ->'0' : java.lang.Short
+ 6 getString -> EXCEPTION (null)
+ 6 getTime -> EXCEPTION (null)
+ 6 getTimeStamp -> EXCEPTION (null)
+=== Columntype clob (64 )
+select typecol from clob_table
+ 7 getObject -> EXCEPTION (null)
+ 7 getArray -> EXCEPTION (jdbc 2 method not
yet implemented)
+ 7 getAsciiStream -> EXCEPTION (null)
+ 7 getBigDecimal -> EXCEPTION (null)
+ 7 getBinaryStream -> EXCEPTION (null)
+ 7 getBlob -> EXCEPTION (null)
+ 7 getBoolean ->'false' : java.lang.Boolean
+ 7 getByte ->'0' : java.lang.Byte
+ 7 getBytes -> EXCEPTION (null)
+ 7 getCharacterStream -> EXCEPTION (null)
+ 7 getClob -> EXCEPTION (null)
+ 7 getDate -> EXCEPTION (null)
+ 7 getDouble ->'0.0' : java.lang.Double
+ 7 getFloat ->'0.0' : java.lang.Float
+ 7 getInt ->'0' : java.lang.Integer
+ 7 getLong ->'0' : java.lang.Long
+ 7 getRef -> EXCEPTION (jdbc 2 method not
yet implemented)
+ 7 getShort ->'0' : java.lang.Short
+ 7 getString -> EXCEPTION (null)
+ 7 getTime -> EXCEPTION (null)
+ 7 getTimeStamp -> EXCEPTION (null)
+-----< METADATA TESTS
+select col_0 from clob_table
+ ---- 1
+ Column : COL_0
+ Type : 4
+ TypeName : INTEGER
+ ClassName : java.lang.Integer
+ Label : COL_0
+ DisplaySz : 11
+ Precision : 10
+ Scale : 0
+ isCurrency: false
+ isCaseSens: false
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+select col_1 from clob_table
+ ---- 1
+ Column : COL_1
+ Type : 1
+ TypeName : CHAR
+ ClassName : java.lang.String
+ Label : COL_1
+ DisplaySz : 10
+ Precision : 10
+ Scale : 0
+ isCurrency: false
+ isCaseSens: true
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = 'true ' : java.lang.String
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+select col_2 from clob_table
+ ---- 1
+ Column : COL_2
+ Type : 12
+ TypeName : VARCHAR
+ ClassName : java.lang.String
+ Label : COL_2
+ DisplaySz : 80
+ Precision : 80
+ Scale : 0
+ isCurrency: false
+ isCaseSens: true
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = NULL
+ OUT = 'true' : java.lang.String
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+select col_3 from clob_table
+ ---- 1
+ Column : COL_3
+ Type : -1
+ TypeName : LONG VARCHAR
+ ClassName : java.lang.String
+ Label : COL_3
+ DisplaySz : 32700
+ Precision : 32700
+ Scale : 0
+ isCurrency: false
+ isCaseSens: true
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = NULL
+ OUT = NULL
+ OUT = 'true' : java.lang.String
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+select col_4 from clob_table
+ ---- 1
+ Column : COL_4
+ Type : -2
+ TypeName : CHAR FOR BIT DATA
+ ClassName : byte[]
+ Label : COL_4
+ DisplaySz : 20
+ Precision : 10
+ Scale : 0
+ isCurrency: false
+ isCaseSens: false
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = Object : byte[]
+ OUT = NULL
+ OUT = NULL
+select col_5 from clob_table
+ ---- 1
+ Column : COL_5
+ Type : -4
+ TypeName : LONG VARCHAR FOR BIT DATA
+ ClassName : byte[]
+ Label : COL_5
+ DisplaySz : 65400
+ Precision : 32700
+ Scale : 0
+ isCurrency: false
+ isCaseSens: false
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = Object : byte[]
+ OUT = NULL
+select col_6 from clob_table
+ ---- 1
+ Column : COL_6
+ Type : 2004
+ TypeName : BLOB
+ ClassName : java.sql.Blob
+ Label : COL_6
+ DisplaySz : 160
+ Precision : 80
+ Scale : 0
+ isCurrency: false
+ isCaseSens: false
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = Object : java.sql.Blob
+select typecol from clob_table
+ ---- 1
+ Column : TYPECOL
+ Type : 2005
+ TypeName : CLOB
+ ClassName : java.sql.Clob
+ Label : TYPECOL
+ DisplaySz : 64
+ Precision : 64
+ Scale : 0
+ isCurrency: false
+ isCaseSens: true
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ 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'.
+select cast( col_1 as clob(64 ) ) from clob_table
+ ---- 1
+ Column : 1
+ Type : 2005
+ TypeName : CLOB
+ ClassName : java.sql.Clob
+ Label : 1
+ DisplaySz : 64
+ Precision : 64
+ Scale : 0
+ isCurrency: false
+ isCaseSens: true
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = Object : java.sql.Clob
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+select cast( col_2 as clob(64 ) ) from clob_table
+ ---- 1
+ Column : 1
+ Type : 2005
+ TypeName : CLOB
+ ClassName : java.sql.Clob
+ Label : 1
+ DisplaySz : 64
+ Precision : 64
+ Scale : 0
+ isCurrency: false
+ isCaseSens: true
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = NULL
+ OUT = Object : java.sql.Clob
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+select cast( col_3 as clob(64 ) ) from clob_table
+ ---- 1
+ Column : 1
+ Type : 2005
+ TypeName : CLOB
+ ClassName : java.sql.Clob
+ Label : 1
+ DisplaySz : 64
+ Precision : 64
+ Scale : 0
+ isCurrency: false
+ isCaseSens: true
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = NULL
+ OUT = NULL
+ OUT = Object : java.sql.Clob
+ OUT = NULL
+ 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'.
+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'.
+select cast( col_6 as clob(64 ) ) from clob_table
+ com.ibm.db2.jcc.c.SqlException: Cannot convert types 'BLOB' to 'CLOB'.
+select cast( typecol as clob(64 ) ) from clob_table
+ ---- 1
+ Column : 1
+ Type : 2005
+ TypeName : CLOB
+ ClassName : java.sql.Clob
+ Label : 1
+ DisplaySz : 64
+ Precision : 64
+ Scale : 0
+ isCurrency: false
+ isCaseSens: true
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ 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'.
+select cast( typecol as char(10) ) from clob_table
+ ---- 1
+ Column : 1
+ Type : 1
+ TypeName : CHAR
+ ClassName : java.lang.String
+ Label : 1
+ DisplaySz : 10
+ Precision : 10
+ Scale : 0
+ isCurrency: false
+ isCaseSens: true
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+select cast( typecol as varchar(80) ) from clob_table
+ ---- 1
+ Column : 1
+ Type : 12
+ TypeName : VARCHAR
+ ClassName : java.lang.String
+ Label : 1
+ DisplaySz : 80
+ Precision : 80
+ Scale : 0
+ isCurrency: false
+ isCaseSens: true
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+select cast( typecol as long varchar ) from clob_table
+ ---- 1
+ Column : 1
+ Type : -1
+ TypeName : LONG VARCHAR
+ ClassName : java.lang.String
+ Label : 1
+ DisplaySz : 32700
+ Precision : 32700
+ Scale : 0
+ isCurrency: false
+ isCaseSens: true
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ 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'.
+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'.
+select cast( typecol as blob(80) ) from clob_table
+ com.ibm.db2.jcc.c.SqlException: Cannot convert types 'CLOB' to 'BLOB'.
+select cast( typecol as clob (64 ) ) from clob_table
+ ---- 1
+ Column : 1
+ Type : 2005
+ TypeName : CLOB
+ ClassName : java.sql.Clob
+ Label : 1
+ DisplaySz : 64
+ Precision : 64
+ Scale : 0
+ isCurrency: false
+ isCaseSens: true
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+drop table clob_table
+-----< 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'.
+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'.
+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'.
+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'.
+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'.
+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'.
+insert into blobCheck (bl ) values (cast (X'a78a' as blob(80)) )
Property changes on:
java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/LOBTest.out
___________________________________________________________________
Name: svn:eol-style
+ native
Index:
java/testing/org/apache/derbyTesting/functionTests/suites/derbynetmats.properties
===================================================================
---
java/testing/org/apache/derbyTesting/functionTests/suites/derbynetmats.properties
(revision 149302)
+++
java/testing/org/apache/derbyTesting/functionTests/suites/derbynetmats.properties
(working copy)
@@ -1,5 +1,5 @@
framework=DerbyNet
-suites=derbynetmats
+suites=derbynetmats jdbcapi jdbc20
jdk12test=true
runwithj9=false
timeout=60
Index:
java/testing/org/apache/derbyTesting/functionTests/suites/j9derbynetmats.properties
===================================================================
---
java/testing/org/apache/derbyTesting/functionTests/suites/j9derbynetmats.properties
(revision 149302)
+++
java/testing/org/apache/derbyTesting/functionTests/suites/j9derbynetmats.properties
(working copy)
@@ -1,5 +1,5 @@
framework=DerbyNet
-suites=j9derbynetmats
+suites=j9derbynetmats jdbcapi jdbc20
jdk12test=true
runwithj9=false
runwithibm13=false
Index:
java/testing/org/apache/derbyTesting/functionTests/suites/derbynetmats.runall
===================================================================
---
java/testing/org/apache/derbyTesting/functionTests/suites/derbynetmats.runall
(revision 149302)
+++
java/testing/org/apache/derbyTesting/functionTests/suites/derbynetmats.runall
(working copy)
@@ -15,6 +15,8 @@
derbynet/testconnection.java
derbynet/testij.java
derbynet/timeslice.java
+jdbcapi/autoGeneratedJdbc30.java
+jdbcapi/dbMetaDataJdbc30.java
jdbcapi/metadata.java
jdbcapi/metadataMultiConn.java
jdbcapi/parameterMetaDataJdbc30.java
@@ -30,3 +32,5 @@
lang/wisconsin.sql
store/holdCursorExternalSortJDBC30.sql
store/holdCursorJDBC30.sql
+tools/importExport.java
+tools/ieptests.sql
Index:
java/testing/org/apache/derbyTesting/functionTests/suites/j9derbynetmats.runall
===================================================================
---
java/testing/org/apache/derbyTesting/functionTests/suites/j9derbynetmats.runall
(revision 149302)
+++
java/testing/org/apache/derbyTesting/functionTests/suites/j9derbynetmats.runall
(working copy)
@@ -8,16 +8,19 @@
derbynet/getCurrentProperties.java
derbynet/maxthreads.java
derbynet/prepStmt.java
+derbynet/runtimeinfo.java
derbynet/testProperties.java
derbynet/testconnection.java
derbynet/testij.java
derbynet/timeslice.java
+jdbcapi/autoGeneratedJdbc30.java
+jdbcapi/dbMetaDataJdbc30.java
jdbcapi/metadata.java
jdbcapi/metadataMultiConn.java
jdbcapi/parameterMetaDataJdbc30.java
jdbcapi/savepointJdbc30.java
lang/big.sql
-lang/bug5054.sql
+lang/bug5054.java
lang/forupdate.sql
lang/holdCursorIJ.sql
lang/holdCursorJavaReflection.java
@@ -26,3 +29,5 @@
lang/supersimple.sql
store/holdCursorExternalSortJDBC30.sql
store/holdCursorJDBC30.sql
+tools/importExport.java
+tools/ieptests.sql
