lobtest.out

derby database source code.good for you.

	---- 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 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' )
	ERROR 42821: Columns of type 'INTEGER' cannot hold values of type 'CHAR'. 
insert into blob_table ( col_1 ) values ( 'true' )
insert into blob_table ( col_2 ) values ( 'true' )
insert into blob_table ( col_3 ) values ( 'true' )
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