lobtest.out

derby database source code.good for you.

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 (Feature not implemented: no details.)
	0 getAsciiStream       ->		EXCEPTION (An attempt was made to get a data value of type 'java.io.InputStream(ASCII)' from a data value of type 'INTEGER'.)
	0 getBigDecimal        ->'100'    	: java.math.BigDecimal
	0 getBinaryStream      ->		EXCEPTION (An attempt was made to get a data value of type 'java.io.InputStream' from a data value of type 'INTEGER'.)
	0 getBlob              ->		EXCEPTION (An attempt was made to get a data value of type 'java.sql.Blob' from a data value of type 'INTEGER'.)
	0 getBoolean           ->'true'    	: java.lang.Boolean
	0 getByte              ->'100'    	: java.lang.Byte
	0 getBytes             ->		EXCEPTION (An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'.)
	0 getCharacterStream   ->		EXCEPTION (An attempt was made to get a data value of type 'java.io.Reader' from a data value of type 'INTEGER'.)
	0 getClob              ->		EXCEPTION (An attempt was made to get a data value of type 'java.sql.Clob' from a data value of type 'INTEGER'.)
	0 getDate              ->		EXCEPTION (An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'INTEGER'.)
	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 (Feature not implemented: no details.)
	0 getShort             ->'100'    	: java.lang.Short
	0 getString            ->'100'    	: java.lang.String
	0 getTime              ->		EXCEPTION (An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'INTEGER'.)
	0 getTimeStamp         ->		EXCEPTION (An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'INTEGER'.)
=== Columntype char(10)
select col_1 from bit_table
	1 getObject            ->'101       '    	: java.lang.String
	1 getArray             ->		EXCEPTION (Feature not implemented: no details.)
	1 getAsciiStream       ->Object'   	: java.io.InputStream
	1 getBigDecimal        ->'101'    	: java.math.BigDecimal
	1 getBinaryStream      ->		EXCEPTION (An attempt was made to get a data value of type 'java.io.InputStream' from a data value of type 'CHAR'.)
	1 getBlob              ->		EXCEPTION (An attempt was made to get a data value of type 'java.sql.Blob' from a data value of type 'CHAR'.)
	1 getBoolean           ->'true'    	: java.lang.Boolean
	1 getByte              ->'101'    	: java.lang.Byte
	1 getBytes             ->		EXCEPTION (An attempt was made to get a data value of type 'byte[]' from a data value of type 'CHAR'.)
	1 getCharacterStream   ->Object'   	: java.io.Reader
	1 getClob              ->		EXCEPTION (An attempt was made to get a data value of type 'java.sql.Clob' from a data value of type 'CHAR'.)
	1 getDate              ->		EXCEPTION (The syntax of the string representation of a datetime value is incorrect.)
	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 (Feature not implemented: no details.)
	1 getShort             ->'101'    	: java.lang.Short
	1 getString            ->'101       '    	: java.lang.String
	1 getTime              ->		EXCEPTION (The syntax of the string representation of a datetime value is incorrect.)
	1 getTimeStamp         ->		EXCEPTION (The syntax of the string representation of a datetime value is incorrect.)
=== Columntype varchar(80)
select col_2 from bit_table
	2 getObject            ->'102'    	: java.lang.String
	2 getArray             ->		EXCEPTION (Feature not implemented: no details.)
	2 getAsciiStream       ->Object'   	: java.io.InputStream
	2 getBigDecimal        ->'102'    	: java.math.BigDecimal
	2 getBinaryStream      ->		EXCEPTION (An attempt was made to get a data value of type 'java.io.InputStream' from a data value of type 'VARCHAR'.)
	2 getBlob              ->		EXCEPTION (An attempt was made to get a data value of type 'java.sql.Blob' from a data value of type 'VARCHAR'.)
	2 getBoolean           ->'true'    	: java.lang.Boolean
	2 getByte              ->'102'    	: java.lang.Byte
	2 getBytes             ->		EXCEPTION (An attempt was made to get a data value of type 'byte[]' from a data value of type 'VARCHAR'.)
	2 getCharacterStream   ->Object'   	: java.io.Reader
	2 getClob              ->		EXCEPTION (An attempt was made to get a data value of type 'java.sql.Clob' from a data value of type 'VARCHAR'.)
	2 getDate              ->		EXCEPTION (The syntax of the string representation of a datetime value is incorrect.)
	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 (Feature not implemented: no details.)
	2 getShort             ->'102'    	: java.lang.Short
	2 getString            ->'102'    	: java.lang.String
	2 getTime              ->		EXCEPTION (The syntax of the string representation of a datetime value is incorrect.)
	2 getTimeStamp         ->		EXCEPTION (The syntax of the string representation of a datetime value is incorrect.)
=== Columntype long varchar
select col_3 from bit_table
	3 getObject            ->'103'    	: java.lang.String
	3 getArray             ->		EXCEPTION (Feature not implemented: no details.)
	3 getAsciiStream       ->Object'   	: java.io.InputStream
	3 getBigDecimal        ->'103'    	: java.math.BigDecimal
	3 getBinaryStream      ->		EXCEPTION (An attempt was made to get a data value of type 'java.io.InputStream' from a data value of type 'LONG VARCHAR'.)
	3 getBlob              ->		EXCEPTION (An attempt was made to get a data value of type 'java.sql.Blob' from a data value of type 'LONG VARCHAR'.)
	3 getBoolean           ->'true'    	: java.lang.Boolean
	3 getByte              ->'103'    	: java.lang.Byte
	3 getBytes             ->		EXCEPTION (An attempt was made to get a data value of type 'byte[]' from a data value of type 'LONG VARCHAR'.)
	3 getCharacterStream   ->Object'   	: java.io.Reader
	3 getClob              ->		EXCEPTION (An attempt was made to get a data value of type 'java.sql.Clob' from a data value of type 'LONG VARCHAR'.)
	3 getDate              ->		EXCEPTION (The syntax of the string representation of a datetime value is incorrect.)
	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 (Feature not implemented: no details.)
	3 getShort             ->'103'    	: java.lang.Short
	3 getString            ->'103'    	: java.lang.String
	3 getTime              ->		EXCEPTION (The syntax of the string representation of a datetime value is incorrect.)
	3 getTimeStamp         ->		EXCEPTION (The syntax of the string representation of a datetime value is incorrect.)
=== Columntype char(10) for bit data
select col_4 from bit_table
	4 getObject            ->Object'   	: byte[]
	4 getArray             ->		EXCEPTION (Feature not implemented: no details.)
	4 getAsciiStream       ->Object'   	: java.io.InputStream
	4 getBigDecimal        ->		EXCEPTION (An attempt was made to get a data value of type 'java.math.BigDecimal' from a data value of type 'CHAR () FOR BIT DATA'.)
	4 getBinaryStream      ->Object'   	: java.io.InputStream
	4 getBlob              ->		EXCEPTION (An attempt was made to get a data value of type 'java.sql.Blob' from a data value of type 'CHAR () FOR BIT DATA'.)
	4 getBoolean           ->		EXCEPTION (An attempt was made to get a data value of type 'boolean' from a data value of type 'CHAR () FOR BIT DATA'.)
	4 getByte              ->		EXCEPTION (An attempt was made to get a data value of type 'byte' from a data value of type 'CHAR () FOR BIT DATA'.)
	4 getBytes             ->Object'   	: byte[]
	4 getCharacterStream   ->Object'   	: java.io.Reader
	4 getClob              ->		EXCEPTION (An attempt was made to get a data value of type 'java.sql.Clob' from a data value of type 'CHAR () FOR BIT DATA'.)
	4 getDate              ->		EXCEPTION (An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'CHAR () FOR BIT DATA'.)
	4 getDouble            ->		EXCEPTION (An attempt was made to get a data value of type 'double' from a data value of type 'CHAR () FOR BIT DATA'.)
	4 getFloat             ->		EXCEPTION (An attempt was made to get a data value of type 'float' from a data value of type 'CHAR () FOR BIT DATA'.)
	4 getInt               ->		EXCEPTION (An attempt was made to get a data value of type 'int' from a data value of type 'CHAR () FOR BIT DATA'.)
	4 getLong              ->		EXCEPTION (An attempt was made to get a data value of type 'long' from a data value of type 'CHAR () FOR BIT DATA'.)
	4 getRef               ->		EXCEPTION (Feature not implemented: no details.)
	4 getShort             ->		EXCEPTION (An attempt was made to get a data value of type 'short' from a data value of type 'CHAR () FOR BIT DATA'.)
	4 getString            ->'00310030003420202020'    	: java.lang.String
	4 getTime              ->		EXCEPTION (An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'CHAR () FOR BIT DATA'.)
	4 getTimeStamp         ->		EXCEPTION (An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'CHAR () FOR BIT DATA'.)
=== Columntype long varchar for bit data
select col_5 from bit_table
	5 getObject            ->Object'   	: byte[]
	5 getArray             ->		EXCEPTION (Feature not implemented: no details.)
	5 getAsciiStream       ->Object'   	: java.io.InputStream
	5 getBigDecimal        ->		EXCEPTION (An attempt was made to get a data value of type 'java.math.BigDecimal' from a data value of type 'LONG VARCHAR FOR BIT DATA'.)
	5 getBinaryStream      ->Object'   	: java.io.InputStream
	5 getBlob              ->		EXCEPTION (An attempt was made to get a data value of type 'java.sql.Blob' from a data value of type 'LONG VARCHAR FOR BIT DATA'.)
	5 getBoolean           ->		EXCEPTION (An attempt was made to get a data value of type 'boolean' from a data value of type 'LONG VARCHAR FOR BIT DATA'.)
	5 getByte              ->		EXCEPTION (An attempt was made to get a data value of type 'byte' from a data value of type 'LONG VARCHAR FOR BIT DATA'.)
	5 getBytes             ->Object'   	: byte[]
	5 getCharacterStream   ->Object'   	: java.io.Reader
	5 getClob              ->		EXCEPTION (An attempt was made to get a data value of type 'java.sql.Clob' from a data value of type 'LONG VARCHAR FOR BIT DATA'.)
	5 getDate              ->		EXCEPTION (An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'LONG VARCHAR FOR BIT DATA'.)
	5 getDouble            ->		EXCEPTION (An attempt was made to get a data value of type 'double' from a data value of type 'LONG VARCHAR FOR BIT DATA'.)
	5 getFloat             ->		EXCEPTION (An attempt was made to get a data value of type 'float' from a data value of type 'LONG VARCHAR FOR BIT DATA'.)
	5 getInt               ->		EXCEPTION (An attempt was made to get a data value of type 'int' from a data value of type 'LONG VARCHAR FOR BIT DATA'.)
	5 getLong              ->		EXCEPTION (An attempt was made to get a data value of type 'long' from a data value of type 'LONG VARCHAR FOR BIT DATA'.)
	5 getRef               ->		EXCEPTION (Feature not implemented: no details.)
	5 getShort             ->		EXCEPTION (An attempt was made to get a data value of type 'short' from a data value of type 'LONG VARCHAR FOR BIT DATA'.)
	5 getString            ->'003100300035'    	: java.lang.String
	5 getTime              ->		EXCEPTION (An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'LONG VARCHAR FOR BIT DATA'.)
	5 getTimeStamp         ->		EXCEPTION (An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'LONG VARCHAR FOR BIT DATA'.)
=== Columntype blob(80)
select col_6 from bit_table
	6 getObject            ->Object'   	: java.sql.Blob
	6 getArray             ->		EXCEPTION (Feature not implemented: no details.)
	6 getAsciiStream       ->Object'   	: java.io.InputStream
	6 getBigDecimal        ->		EXCEPTION (An attempt was made to get a data value of type 'java.math.BigDecimal' from a data value of type 'BLOB'.)
	6 getBinaryStream      ->Object'   	: java.io.InputStream
	6 getBlob              ->Object'   	: java.sql.Blob
	6 getBoolean           ->		EXCEPTION (An attempt was made to get a data value of type 'boolean' from a data value of type 'BLOB'.)
	6 getByte              ->		EXCEPTION (An attempt was made to get a data value of type 'byte' from a data value of type 'BLOB'.)
	6 getBytes             ->Object'   	: byte[]
	6 getCharacterStream   ->Object'   	: java.io.Reader
	6 getClob              ->		EXCEPTION (An attempt was made to get a data value of type 'java.sql.Clob' from a data value of type 'BLOB'.)
	6 getDate              ->		EXCEPTION (An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'BLOB'.)
	6 getDouble            ->		EXCEPTION (An attempt was made to get a data value of type 'double' from a data value of type 'BLOB'.)
	6 getFloat             ->		EXCEPTION (An attempt was made to get a data value of type 'float' from a data value of type 'BLOB'.)
	6 getInt               ->		EXCEPTION (An attempt was made to get a data value of type 'int' from a data value of type 'BLOB'.)
	6 getLong              ->		EXCEPTION (An attempt was made to get a data value of type 'long' from a data value of type 'BLOB'.)
	6 getRef               ->		EXCEPTION (Feature not implemented: no details.)
	6 getShort             ->		EXCEPTION (An attempt was made to get a data value of type 'short' from a data value of type 'BLOB'.)
	6 getString            ->'003100300036'    	: java.lang.String
	6 getTime              ->		EXCEPTION (An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'BLOB'.)
	6 getTimeStamp         ->		EXCEPTION (An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'BLOB'.)
=== Columntype char (8 ) for bit data
select typecol from bit_table
	7 getObject            ->Object'   	: byte[]
	7 getArray             ->		EXCEPTION (Feature not implemented: no details.)
	7 getAsciiStream       ->Object'   	: java.io.InputStream
	7 getBigDecimal        ->		EXCEPTION (An attempt was made to get a data value of type 'java.math.BigDecimal' from a data value of type 'CHAR () FOR BIT DATA'.)
	7 getBinaryStream      ->Object'   	: java.io.InputStream
	7 getBlob              ->		EXCEPTION (An attempt was made to get a data value of type 'java.sql.Blob' from a data value of type 'CHAR () FOR BIT DATA'.)
	7 getBoolean           ->		EXCEPTION (An attempt was made to get a data value of type 'boolean' from a data value of type 'CHAR () FOR BIT DATA'.)
	7 getByte              ->		EXCEPTION (An attempt was made to get a data value of type 'byte' from a data value of type 'CHAR () FOR BIT DATA'.)
	7 getBytes             ->Object'   	: byte[]
	7 getCharacterStream   ->Object'   	: java.io.Reader
	7 getClob              ->		EXCEPTION (An attempt was made to get a data value of type 'java.sql.Clob' from a data value of type 'CHAR () FOR BIT DATA'.)
	7 getDate              ->		EXCEPTION (An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'CHAR () FOR BIT DATA'.)
	7 getDouble            ->		EXCEPTION (An attempt was made to get a data value of type 'double' from a data value of type 'CHAR () FOR BIT DATA'.)
	7 getFloat             ->		EXCEPTION (An attempt was made to get a data value of type 'float' from a data value of type 'CHAR () FOR BIT DATA'.)
	7 getInt               ->		EXCEPTION (An attempt was made to get a data value of type 'int' from a data value of type 'CHAR () FOR BIT DATA'.)
	7 getLong              ->		EXCEPTION (An attempt was made to get a data value of type 'long' from a data value of type 'CHAR () FOR BIT DATA'.)
	7 getRef               ->		EXCEPTION (Feature not implemented: no details.)
	7 getShort             ->		EXCEPTION (An attempt was made to get a data value of type 'short' from a data value of type 'CHAR () FOR BIT DATA'.)
	7 getString            ->'0031003000372020'    	: java.lang.String
	7 getTime              ->		EXCEPTION (An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'CHAR () FOR BIT DATA'.)
	7 getTimeStamp         ->		EXCEPTION (An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'CHAR () FOR BIT DATA'.)
---< 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