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.