JDBC Data Type Conversions

The following tables display the data conversions that are acceptable for both retrieval and update in CONNX JDBC.

getxxx Methods to Update Data
Available Data Type Conversions
Methods	Binary	Bit	Char	Double	Integer	Long Varbinary	Long Varchar	Numeric	Real	Smallint	Timestamp
getAsciStream	X		X			X	X
getBigDecimal		X	X	X	X		X	X	X	X
getBinaryStream						X
getBoolean		X	X	X	X		X	X	X	X
getByte	X	X	X	X	X		X	X	X	X
getBytes	X		X		X		X
getDate											X
getDouble		X	X	X	X		X	X	X	X
getFloat		X	X	X	X		X	X	X	X
getInt		X	X	X	X		X	X	X	X
getLong		X	X	X	X		X	X	X	X
getObject	X	X	X	X	X	X	X	X	X	X
getShort		X	X	X	X		X	X	X	X
getString		X	X	X	X		X	X	X	x	X
getTime					X						X
getTimestamp					X						x
getUnicodeStream	x	x	X			X	X

setxxx Methods to Update Data
Available Data Type Conversions
Methods	Binary	Bit	Char	Double	Integer	Long Varbinary	Long Varchar	Numeric	Real	Smallint	Timestamp
setAsciStream	X		X			X	X
setBigDecimal		X	X	X	X		X	X	X	X
setBinaryStream						X
setBoolean		X	X	X	X		X	X	X	X
setByte	X	X	X	X	X		X	X	X	X
setBytes	X		X		X		X
setDate											X
setDouble		X	X	X	X		X	X	X	X
setFloat		X	X	X	X		X	X	X	X
setInt		X	X	X	X		X	X	X	X
setLong		X	X	X	X		X	X	X	X
setObject	X	X	X	X	X	X	X	X	X	X
setShort		X	X	X	X		X	X	X	X
setString		X	X	X	X		X	X	X	x	X
setTime					X						X
setTimestamp					X						x
setUnicodeStream	x	x	X			X	X