jdbcType与javaType的对应关系

Java 类型	java.sql.Types 值	Oracle	IBM DB2	Sybase	SQL	Informix	IBM Content Manager
java.lang.long	BIGINT	NUMBER (38, 0)	BIGINT	BIGINT	BIGINT	INT8	DK_CM_BIGINT
byte[]	BINARY	RAW	CHAR FOR BIT DATA	BINARY	IMAGE	BYTE	DK_CM_BLOB
java.lang.Boolean	BIT	BIT	N/A	BIT	BIT	BIT	DK_CM_SMALLINT
byte[]	BLOB	BLOB	BLOB	BLOB	BLOB	BLOB	DK_CM_BLOB
java.lang.String	CHAR	CHAR	CHAR, GRAPHIC	CHAR	CHAR	CHAR	DK_CM_CHAR
java.lang.String	CLOB	CLOB	CLOB, DBCLOB	CLOB	CLOB	CLOB	DK_CM_CLOB
java.sql.Date	DATE	DATE	DATE	DATE	DATE	DATE	DK_CM_DATE
java.math.BigDecimal	DECIMAL	NUMBER	DECIMAL	DECIMAL, MONEY, SMALLMONEY	DECIMAL	DECIMAL	DK_CM_DECIMAL
java.lang.Double	DOUBLE	DOUBLE PRECISION	DOUBLE	DOUBLE PRECISION	DOUBLE PRECISION	DOUBLE PRECISION	DK_CM_DOUBLE
java.lang.Double	FLOAT	FLOAT	FLOAT	FLOAT	FLOAT	FLOAT	DK_CM_DOUBLE
java.lang.Integer	INTEGER	INTEGER	INTEGER	INT	INTEGER	INTEGER	DK_CM_INTEGER
java.lang.Object	JAVA_OBJECT	JAVA_OBJECT	JAVA_OBJECT	JAVA_OBJECT	JAVA_OBJECT	OPAQUE	N/A
byte[]	LONGVARBINARY	LONG RAW	LONG VARCHAR FOR BIT DATA	IMAGE	IMAGE	BYTE	DK_CM_BLOB
java.lang.String	LONGVARCHAR	LONG	LONG VARCHAR, LONG VARGRAPHIC	TEXT	TEXT	TEXT	DK_CM_VARCHAR(3500)
java.math.BigDecimal	NUMERIC	NUMBER	NUMERIC	NUMERIC	NUMERIC	NUMERIC	DK_CM_DECIMAL
java.lang.Object	OTHER	OTHER	OTHER	OTHER	OTHER	OTHER	N/A
java.lang.Float	REAL	REAL	REAL	REAL	REAL	REAL	DK_CM_DOUBLE
java.lang.Integer	SMALLINT	SMALLINT	SMALLINT	SMALLINT	SMALLINT	SMALLINT	DK_CM_INTEGER
java.sql.Time	TIME	DATE	TIME	TIME	TIME	DATETIME HOUR TO SECOND	DK_CM_TIME
java.sql.Timestamp	TIMESTAMP	DATE	TIMESTAMP	DATETIME, SMALLDATETIME	DATETIME	DATETIME YEAR TO FRACTION (5)	DK_CM_TIMESTAMP
java.lang.Bute	TINYINT	TINYINT	SMALLINT	TINYINT	TINYINT	TINYINT	DK_CM_INTEGER
byte[]	VARBINARY	RAW	VARCHAR FOR BIT DATA	VARBINARY	IMAGE	BYTE	DK_CM_BLOB
java.lang.String	VARCHAR	VARCHAR	VARCHAR, VARGRAPHIC	VARCHAR	VARCHAR	VARCHAR	DK_CM_VARCHAR