JDBC Data Type to Java Data Type Mappings

Each column in the database table is assigned a SQL type. The JDBC driver maps each SQL data type to a JDBC data type. Adapter for JDBC then maps each JDBC data type to one or more Java data types that are used as the input or output of the adapter service or notification.

The following table shows the JDBC data type to Java data type mappings. You can map each JDBC data type to a set of Java data types by choosing one from the set. The JDBC data type you select during configuration will then map to the input or output of the adapter service or notification.

For a list of data types for which Integration Server has some constraints, see JDBC Data Type to Java Data Type Mapping Constraints.

Note: Adapter for JDBC does not support the DATALINK DB2 data type when using the adapter with DB2 for AS/400 or DB2 for OS/390.

Note: Adapter for JDBC does not support the TIMESTAMP WITH TIME ZONE and TIMESTAMP WITH LOCAL TIME ZONE data types in Oracle 10g.

Note: Adapter for JDBC does not support user-defined data types, Oracle PL/SQL collections, or Oracle PL/SQL records.

JDBC Data Type	Java Data Type
ARRAY	java.sql.Array java.lang.Object
BIT	java.lang.Boolean java.lang.String java.lang.Object
TINYINT	java.lang.Byte java.lang.Integer java.lang.String java.lang.Object SetAsString
SMALLINT	java.lang.Short java.lang.Integer java.lang.String java.lang.Object
INTEGER	java.lang.Integer java.lang.String java.lang.Object
BIGINT	java.lang.Long java.lang.String java.lang.Object
FLOAT	java.lang.Double java.lang.String java.lang.Object java.math.BigDecimal SetAsString
REAL	java.lang.Float java.lang.String java.lang.Object java.math.BigDecimal
BOOLEAN	java.lang.Boolean java.lang.String java.lang.Object
DOUBLE	java.lang.Double java.lang.String java.lang.Object java.math.BigDecimal SetAsString
NUMERIC	java.math.BigDecimal java.lang.String java.lang.Object
DECIMAL	java.math.BigDecimal java.lang.String java.lang.Object
CHAR	java.lang.String java.lang.Character java.lang.Object
VARCHAR	java.lang.String java.lang.Object
LONGVARCHAR	java.lang.String java.lang.Object
DATE	java.sql.Date java.util.Date java.lang.String java.lang.Object SetAsString
TIME	java.sql.Time java.util.Date java.lang.String java.lang.Object SetAsString
TIMESTAMP	java.sql.Timestamp java.util.Date java.lang.String java.lang.Object SetAsString
TIMESTAMP WITH TIME ZONE
TIMESTAMP WITH LOCAL TIME ZONE
BINARY	byte array (byte []) java.lang.Object
VARBINARY	byte array (byte[]) java.lang.Object
LONGVARBINARY	byte array (byte[]) java.lang.Object
LONGNVARCHAR	java.lang.String java.lang.Object
NCHAR	java.lang.String java.lang.Object
NULL	java.lang.String java.lang.Object
NVARCHAR	java.lang.String java.lang.Object
CLOB	java.sql.Clob java.lang.String java.io.Reader java.lang.Object
BLOB	java.sql.Blob byte array java.io.InputStream java.lang.Object
ORACLECURSOR	java.lang.Object
ORACLEFIXED_CHAR	java.lang.String
STRUCT	java.sql.Struct java.lang.Object
OTHER	java.lang.Object java.lang.String java.sql.Struct java.sql.Array