Nonextended data types
The following tables list the PreparedStatement.setXXX() methods that HCL Informix® JDBC Driver supports for nonextended data types. The top heading lists the standard JDBC API data types defined in the java.sql.Types class. These translate to specific Informix data types, as shown in the table in Data type mapping between extended types and Java and JDBC types. The tables below list the setXXX() methods you can use to write data of a particular JDBC API data type. An uppercase and bold X indicates the setXXX() method that it is recommended you use with HCL Informix JDBC Driver; a lowercase x indicates other setXXX() methods that HCL Informix JDBC Driver supports.
Numeric JDBC API data types
setXXX() method | TINYINT | SMALLINT | INTEGER | BIGINT |
---|---|---|---|---|
setByte() | X | x | x | x |
setShort() | x | X | x | x |
setInt() | x | x | X | x |
setLong() | x | x | x | X |
setFloat() | x | x | x | x |
setDouble() | x | x | x | x |
setBigDecimal() | x | x | x | x |
setBoolean() | x | x | x | x |
setString() | x | x | x | x |
setObject() | x | x | x | x |
setXXX() method | REAL | FLOAT | DOUBLE | DECIMAL | NUMERIC |
---|---|---|---|---|---|
setByte() | x | x | x | x | x |
setShort() | x | x | x | x | x |
setInt() | x | x | x | x | x |
setLong() | x | x | x | x | x |
setFloat() | X | x | x | x | x |
setDouble() | x | X | X | x | x |
setBigDecimal() | x | x | x | X | X |
setBoolean() | x | x | x | x | x |
setString() | x | x | x | x | x |
setObject() | x | x | x | x | x |
Character and chronological JDBC API data types
setXXX() method | CHAR | VARCHAR | LONGVARCHAR | BINARY |
---|---|---|---|---|
setByte() | x1 | x1 | ||
setShort() | x1 | x1 | ||
setInt() | x1 | x1 | ||
setLong() | x1 | x1 | ||
setFloat() | x1 | x1 | ||
setDouble() | x1 | x1 | ||
setBigDecimal() | x | x | ||
setBoolean() | x | x | ||
setString() | X | X | x | x |
setBytes() | x | X | ||
setDate() | x | x | ||
setTime() | x | x | ||
setTimestamp() | x | x | ||
setAsciiStream() | X | x | ||
setCharacterStream() | X | x | ||
setBinaryStream() | x | x | ||
setObject() | x | x | x2 | x |
Notes:
- The column value must match the type of setXXX() exactly, or an SQLException is raised. If the column value is not within the allowed value range, the setXXX() method raises an exception instead of converting the data type. For example, setByte(1) raises an SQLException if the value being written is 1000.
- A byte array is written.
setXXX() method | VARBINARY | LONGVARBINARY | DATE | TIME | TIMESTAMP |
---|---|---|---|---|---|
setString() | x | x | x | x | x |
setBytes() | X | x | |||
setDate() | X | x | |||
setTime() | X | x | |||
setTimestamp() | x | X | |||
setAsciiStream() | x | x | |||
setCharacterStream() | x | x | |||
setBinaryStream() | x | X | |||
setObject() | x | x1 | x | x2 | x |
Notes:
- A byte array is written.
- A Timestamp object is written instead of a Time object.
The setMaxRows() method writes an SQL null value.