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.
A-Z
, a-z
, 0-9
and _
, then you must quote the identifier.
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) |
DatabaseMetadata.getExtraNameCharacters()
.