Relationships between SQL data types and Java classes

By default, the data retrieved by an SQL statement maps to the following Java classes:

SQL Type	Java class
CHAR	java.lang.String
VARCHAR	java.lang.String
LONG VARCHAR	java.lang.String
INTEGER	java.lang.Integer
TINYINT	java.lang.Integer
SMALLINT	java.lang.Short
DECIMAL	java.math.BigDecimal
NUMERIC	java.math.BigDecimal
BIT	java.math.Boolean
BIGINT	java.lang.Long
REAL	java.lang.Float
FLOAT	java.lang.Double
DOUBLE	java.lang.Double
BINARY	java.lang.byte[]
VARBINARY	java.lang.byte[]
LONGVARBINARY	java.lang.byte[]
DATE	java.sql.Date
TIME	java.sql.Time
TIMESTAMP	java.sql.Timestamp

Back to Remapping data to a different SQL data type