MySQL Type      Java Type----------      ---------CHAR            StringVARCHAR         StringLONGVARCHAR     StringNUMERIC         java.math.BigDecimalDECIMAL         java.math.BigDecimalBIT             booleanTINYINT         byteSMALLINT        shortINTEGER         intBIGINT          longREAL            floatFLOAT           doubleDOUBLE          doubleBINARY          byte[]VARBINARY       byte[]LONGVARBINARY   byte[]DATE            java.sql.DateTIME            java.sql.TimeTIMESTAMP       java.sql.Tiimestamp

Mysql Java type mapping