lobtest.out

derby database source code.good for you.

	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