📄 lobtest.out

📁 derby database source code.good for you.
💻 OUT
📖 第 1 页 / 共 5 页
字号:
	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 varcharselect 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 dataselect 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 dataselect 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 dataselect 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 TESTSselect 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 = NULLselect 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 = NULLselect 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 = NULLselect 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 = NULLselect 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 = NULLselect 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 = NULLselect col_6 from bit_table
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -