Data Types

The following table lists the data types that are supported and what java type they map to.

SQL TypeJava Type
BITboolean
TINYINTbyte
SMALLINTshort
INTEGERint
BIGINTlong
FLOATdouble
REALfloat
DOUBLEdouble
NUMERICBigDecimal
DECIMALBigDecimal
CHARString
VARCHARString
LONGVARCHARString
DATEDate
TIMETime
TIMESTAMPTimestamp
BINARYBlob
VARBINARYBlob
LONGVARBINARYBlob
NULLNot Supported
OTHERNot Supported
JAVA_OBJECTNot Supported
DISTINCTNot Supported
STRUCTNot Supported
ARRAYNot Supported
BLOBBlob
CLOBString
REFNot Supported
DATALINKNot Supported
BOOLEANboolean
ROWIDNo Supported
NCHARString
NVARCHARString
LONGNVARCHARString
NCLOBString
SQLXMLNot Supported
REF_CURSORNot Supported
TIME_WITH_TIMEZONENot Supported
TIMESTAMP_WITH_TIMEZONENot Supported
PARAMETERNot Supported