The correspondence between Jdbctype and Javatype

Java.sql.Types value Java type IBM DB2 Oracle Sybase SQL Informix IBM Content Manager
BIGINT java.lang.long BIGINT Number (0) BIGINT BIGINT INT8 Dk_cm_bigint
BINARY byte[] CHAR for BIT DATA RAW BINARY IMAGE byte Dk_cm_blob
Bit Java.lang.Boolean N/a bit bit bits dk_cm_smallint
Blob-byte[] blob blob blob blob blob Dk_cm_blob
Char java.lang.String Char, GRAPHIC Char Char Char char Dk_cm_char
CLOB java.lang.String CLOB, Dbclob CLOB CLOB CLOB CLOB Dk_cm_clob
Date Java.sql.Date date, date date, date date dk_cm_date
Decimal java.math.BigDecimal decimal number decimal, Money, smallmoney decimal decimal dk_cm_d Ecimal
Double java.lang.Double double double PRECISION double PRECISION double PRECISION double PRECISION Dk_cm_double
Float java.lang.Double float float float float float dk_cm_double
Integer java.lang.Integer integer integer INT integer dk_cm_integer
Java_object java.lang.Object java_object java_object java_object java_object OPAQUE N/A
LongVarBinary byte[] LONG VARCHAR for BIT DATA LONG RAW image Image byte Dk_cm_blob
LongVarChar java.lang.String long VARCHAR, long vargraphic long text text, text Dk_cm_varchar (3 500)
NUMERIC java.math.BigDecimal NUMERIC number NUMERIC NUMERIC NUMERIC dk_cm_decimal
Other Java.lang.Object, other, other, other, N/A
Real Java.lang.Float real real real real real dk_cm_double
SMALLINT java.lang.Integer SMALLINT SMALLINT SMALLINT SMALLINT SMALLINT Dk_cm_integer
Time Java.sql.Time time DATE time time DATETIME HOUR to SECOND dk_cm_time
TIMESTAMP java.sql.Timestamp TIMESTAMP DATE datetime, smalldatetime datetime datetime year to FRAC tion (5) Dk_cm_timestamp
TINYINT Java.lang.Bute SMALLINT

TINYINT


TINYINT
TINYINT TINYINT Dk_cm_integer
VARBINARY byte[] VARCHAR for BIT DATA RAW VARBINARY IMAGE byte Dk_cm_blob
varchar java.lang.String varchar, vargraphic varchar varchar varchar varchar DK_CM_VARCHAR

The correspondence between Jdbctype and Javatype