JDBC Type Conversions for RowSets

See Also

SQL data types returned in rowsets are converted to Java specification data types according to the table of JDBC Types Mapped to Java Types in Appendix B of the JDBC 3.0 Specification (copied below). For more information, see JDBC 3.0 - Final Release.

JDBC Type	Java Type
CHAR	java.lang.String
VARCHAR	java.lang.String
LONGVARCHAR	java.lang.String
NUMERIC	java.math.BigDecimal
DECIMAL	java.math.BigDecimal
BIT	boolean
BOOLEAN	boolean
TINYINT	byte
SMALLINT	short
INTEGER	int
BIGINT	long
REAL	float
FLOAT	double
DOUBLE	double
BINARY	byte[ ]
VARBINARY	byte[ ]
LONGVARBINARY	byte[ ]
DATE	java.sql.Date
TIME	java.sql.Time
TIMESTAMP	java.sql .Timestamp
CLOB	java.sql.Clob
BLOB	java.sql.Blob
ARRAY	java.sql.Array
DISTINCT	(mapping of underlying type)
STRUCT	java.sql.Struct
REF	java.sql.Ref
DATALINK	java.net.URL
JAVA_OBJECT	(underlying Java class)

See Also

About Binding Components to Data

Data Source Tasks: Quick Reference

JDBC RowSet Javadoc

JDBC RowSet Java Tutorial Example

Java Database Programming Course