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 |  |  |  |