lobtest.out

derby database source code.good for you.

	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
	ERROR 42846: Cannot convert types 'INTEGER' to 'CHAR () FOR BIT DATA'.
select cast( col_1 as char (8) for bit data ) from bit_table
	ERROR 42846: Cannot convert types 'CHAR' to 'CHAR () FOR BIT DATA'.
select cast( col_2 as char (8) for bit data ) from bit_table
	ERROR 42846: Cannot convert types 'VARCHAR' to 'CHAR () FOR BIT DATA'.
select cast( col_3 as char (8) for bit data ) from bit_table
	ERROR 42846: Cannot convert types 'LONG VARCHAR' to 'CHAR () FOR BIT DATA'.
select cast( col_4 as char (8) for bit data ) from bit_table
	---- 1
	Column    : 1
	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
	ERROR 42846: Cannot convert types 'BLOB' to 'CHAR () FOR BIT DATA'.
select cast( typecol as char (8) for bit data ) from bit_table
	---- 1
	Column    : 1
	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
	ERROR 42846: Cannot convert types 'CHAR () FOR BIT DATA' to 'INTEGER'.
select cast( typecol as char(10) ) from bit_table
	ERROR 42846: Cannot convert types 'CHAR () FOR BIT DATA' to 'CHAR'.
select cast( typecol as varchar(80) ) from bit_table
	ERROR 42846: Cannot convert types 'CHAR () FOR BIT DATA' to 'VARCHAR'.
select cast( typecol as long varchar ) from bit_table
	ERROR 42846: Cannot convert types 'CHAR () FOR BIT DATA' to 'LONG VARCHAR'.
select cast( typecol as char(10) for bit data ) from bit_table
	---- 1
	Column    : 1
	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' )
	ERROR 42821: Columns of type 'INTEGER' cannot hold values of type 'CHAR'. 
insert into bit_table ( col_1 ) values ( 'true' )
insert into bit_table ( col_2 ) values ( 'true' )
insert into bit_table ( col_3 ) values ( 'true' )
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