CONNX Data Integration Suite 14.7.0 | Developer Guide | CONNX JDBC Driver | JDBC Data Type Conversions
 
JDBC Data Type Conversions
The following tables show 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