The following table
lists the PreparedStatement.setXXX() 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 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
Informix JDBC
Driver.
The table does not include
setXXX() methods that
you cannot use with any of the
Informix extended
data types.
Table 1. Informix 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. Informix 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.