Java Object Type | JDBC Type |
java.lang.String | CHAR, VARCHAR, or LONGVARCHAR |
java.math.BigDecimal | NUMERIC |
java.lang.Boolean | BIT |
java.lang.Integer | INTEGER |
java.lang.Long | BIGINT |
java.lang.Float | REAL |
java.lang.Double | DOUBLE |
byte[] | BINARY, VARBINARY, or LONGVARBINARY |
java.sql.Date | DATE |
java.sql.Time | TIME |
java.sql.Timestamp | TIMESTAMP |
java.sql.Clob | CLOB |
java.sql.Blob | BLOB |
java.sql.Array | ARRAY |
java.sql.Struct | STRUCT |
java.sql.Ref | REF |
Java class | JAVA_OBJECT |
20.19.SQL Data Type Java Data Type | ||||
20.19.1. | Mapping Between Java to JDBC SQL Types | |||
20.19.2. | Java Types Mapped to JDBC Types | |||
20.19.3. | JDBC Types Mapped to Java Object Types | |||
20.19.4. | Java Object Types Mapped to JDBC Types | |||
20.19.5. | Getting the Name of a JDBC Type | |||
20.19.6. | Get the database-specific type name | |||
20.19.7. | Get the java.sql.Types type to which this database-specific type is mapped | |||
20.19.8. | Retrieve type info from the result set | |||
20.19.9. | converting a java.sql.Types integer value into a printable name | |||
20.19.10. | uses reflection to get all the field names from java.sql.Types. |