SQL to Java data type conversions

SQL type Java type
CHAR String
VARCHAR String
TEXT String
NUMERIC java.math.BigDecimal
DECIMAL java.math.BigDecimal
MONEY java.math.BigDecimal
SMALLMONEY java.math.BigDecimal
UNSIGNED BIGINT java.math.BigDecimal (precision=20, scale=0)
BIT boolean
TINYINT byte
SMALLINT short
UNSIGNED SMALLINT int
INTEGER int
UNSIGNED INTEGER long
BIGINT long
REAL float
FLOAT double
DOUBLE double
BINARY byte[ ]
VARBINARY byte[ ]
LONG BINARY byte[ ]
IMAGE byte[ ]
DATE java.sql.Date
TIME java.sql.Time
TIMESTAMP java.sql.Timestamp