HCL OneDB extended data types
The following table lists the ResultSet.getXXX() methods that HCL OneDB™ JDBC Driver supports for the HCL OneDB 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 HCL OneDB JDBC
Driver.
The table does not include getXXX() methods that
you cannot use with any of the HCL
OneDB 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() |