Mega Code Archive

 

Categories / Java Tutorial / Database

 

Mapping Between Java to JDBC SQL Types

JDBC Type Java Type CHARjava.lang.String VARCHARjava.lang.String LONGVARCHARjava.lang.String NUMERICjava.math.BigDecimal DECIMALjava.math.BigDecimal BITboolean TINYINTbyte SMALLINTshort INTEGERint BIGINTlong REALfloat FLOATdouble DOUBLEdouble BINARYbyte[] VARBINARYbyte[] LONGVARBINARYbyte[] DATEjava.sql.Date TIMEjava.sql.Time TIMESTAMPjava.sql.Timestamp CLOBjava.sql.Clob BLOBjava.sql.Blob ARRAYjava.sql.Array DISTINCTMapping of underlying type STRUCTjava.sql.Struct REFjava.sql.Ref JAVA_OBJECTUnderlying Java class