Informix extended data types
The following table lists the ResultSet.getXXX() methods that Informix® JDBC Driver supports for the Informix extended data types, the mappings for which are shown in the table Data type mapping between extended types and Java and JDBC types. The table lists the getXXX() methods you can use to retrieve data of a particular extended data type.
An
uppercase and bold X indicates the recommended getXXX() method
to use; a lowercase x indicates other getXXX() methods
supported by Informix JDBC
Driver.
The table does not include getXXX() methods that
you cannot use with any of the Informix extended
data types.
| getXXX() method | BOOLEAN | LVARCHAR | Opaque types | BLOB | CLOB | BYTE |
|---|---|---|---|---|---|---|
| getByte() | x | x | ||||
| getShort() | x | |||||
| getInt() | x | |||||
| getBoolean() | X | |||||
| getString() | X | x | ||||
| getBytes() | x | x | ||||
| getAsciiStream() | x | x | ||||
| getCharacterStream() | x | x | ||||
| getBinaryStream() | x | x | X | |||
| getObject() | x | x | X | x | x | x |
| getBlob() | X | |||||
| getClob() | X |
| getXXX() method | TEXT | NAMED ROW | UNNAMED ROW | SET or MULTISET | LIST |
|---|---|---|---|---|---|
| getString() | x | ||||
| getBytes() | |||||
| getAsciiStream() | X | ||||
| getCharacterStream() | X | ||||
| getBinaryStream() | |||||
| getObject() | x | X | X | x | x |
| getArray() | x | x | |||
| getBlob() | |||||
| getClob() |