HCL OneDB extended data types

The following table lists the PreparedStatement.setXXX() 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 setXXX() methods you can use to write data of a particular extended data type.

An uppercase and bold X indicates the recommended setXXX() method to use; a lowercase x indicates other setXXX() methods supported by HCL OneDB JDBC Driver. The table does not include setXXX() methods that you cannot use with any of the HCL OneDB extended data types.
Table 1. HCL OneDB extended data types
setXXX() method BOOLEAN LVARCHAR Opaque types BLOB CLOB BYTE TEXT
setByte() x x
setShort() x
setInt() x
setBoolean() X
setString() X x x
setBytes() x x
setAsciiStream() x x X
setCharacterStream() x x X
setBinaryStream() x x X
setObject() x x X x x x x
setArray()
setBlob() X
setClob() X
Table 2. HCL OneDB extended data types (continued)
setXXX() method NAMED ROW UNNAMED ROW SET or MULTISET LIST
setObject() X X x x
setArray() x x

The setMaxRows() method writes an SQL null value.