Supported Db2 LUW data types

Datatype

Generic SQL datatype

Java datatype for modification

BIGINT

BIGINT

java.math.BigDecimal

BINARY VARYING

CLOB

java.lang.byte[]

BINARY

CLOB

java.lang.byte[]

BLOB

BLOB

java.sql.Blob

BOOLEAN

BOOLEAN

java.math.BigDecimal

CHARACTER

CHAR

java.lang.String

CLOB

CLOB

java.sql.Clob

DATE

DATE

de.ubs.xdm.utils.core.HighPrecisionTimestamp

DBCLOB

CLOB

java.sql.Clob

DECFLOAT

DECIMAL

java.math.BigDecimal

DECIMAL

DECIMAL

java.math.BigDecimal

DOUBLE

DOUBLE

java.math.BigDecimal

FLOAT

FLOAT

java.math.BigDecimal

GRAPHIC

CHAR

java.lang.String

INTEGER

INTEGER

java.math.BigDecimal

LONG VARCHAR

LONGVARCHAR

java.lang.String

LONG VARGRAPHIC

LONGNVARCHAR

java.lang.String

REAL

FLOAT

java.math.BigDecimal

SMALLINT

SMALLINT

java.math.BigDecimal

TIMESTAMP

TIMESTAMP

de.ubs.xdm.utils.core.HighPrecisionTimestamp

TIME

TIME

de.ubs.xdm.utils.core.HighPrecisionTimestamp

VARBINARY

CLOB

java.lang.byte[]

VARCHAR

VARCHAR

java.lang.String

VARGRAPHIC

VARCHAR

java.lang.String

XML

SQLXML

java.sql.Clob