Hiberante SQL mapping corresponds
Java Data types |
Hibernate data type |
Standard SQL data type (PS: May vary for different db) |
BYTE, Java.lang.Byte |
Byte |
TINYINT |
Short, Java.lang.Short |
Short |
SMALLINT |
int, Java.lang.Integer |
Integer |
Ingeger |
Long, Java.lang.Long |
Long |
BIGINT |
float, java.lang.Float |
Float |
FLOAT |
Double, java.lang.Double |
Double |
DOUBLE |
Java.math.BigDecimal |
Big_decimal |
NUMERIC |
Char, Java.lang.Character |
Character |
CHAR (1) |
Boolean, Java.lang.Boolean |
Boolean |
BIT |
Java.lang.String |
String |
VARCHAR |
Boolean, Java.lang.Boolean |
Yes_no |
CHAR (1) (' Y ' or ' N ') |
Boolean, Java.lang.Boolean |
True_false |
CHAR (1) (' Y ' or ' N ') |
Java.util.Date, Java.sql.Date |
Date |
DATE |
Java.util.Date, Java.sql.Time |
Time |
Time |
Java.util.Date, Java.sql.Timestamp |
Timestamp |
TIMESTAMP |
Java.util.Calendar |
Calendar |
TIMESTAMP |
Java.util.Calendar |
Calendar_date |
DATE |
Byte[] |
Binary |
VARBINARY, BLOB |
Java.lang.String |
Text |
Clob |
Java.io.Serializable |
Serializable |
VARBINARY, BLOB |
Java.sql.Clob |
Clob |
Clob |
Java.sql.Blob |
Blob |
Blob |
Java.lang.Class |
Class |
VARCHAR |
Java.util.Locale |
Locale |
VARCHAR |
Java.util.TimeZone |
TimeZone |
VARCHAR |
Java.util.Currency |
Currency |
VARCHAR |
One, for large characters, which is Colb,blob
The hibernate annoation can be used as follows:
@Lob
public String getC() {
return c;
}
@Lob
public byte[] getB() {
return b;
}