This section lists Hibernate data types.
Hibernate Data Types :
Hibernate data type plays an important roll as it acts like a bridge between
java types and DB data types.
It is necessary to choose correct data type during table creation. Hibernate
data types are used when we write
hibernate mapping files(*.hbm.xml) . This is also known as mapping types.
Here we are categorizing the mapping types in Hibernate -
1. Primitive Types :
| Java Type | Hibernate Type | SQL Type |
| int/java.lang.Integer | integer | INTEGER |
| long/java.lang.Long | long | BIGINT |
| short/java.lang.Short | short | SMALLINT |
| float/java.lang.Float | float | Float |
| double/java.lang.Double | double | DOUBLE |
| java.math.BigDecimal | big_decimal | NUMERIC |
| java.lang.String | character | CHAR(1) |
| java.lang.String | string | VARCHAR |
| byte/java.lang.Byte | byte | TINYINT |
| boolean/java.lang.Boolean | boolean | BIT |
| boolean/java.lang.Boolean | yes_no | CHAR(1)('Y' or 'N') |
| boolean/java.lang.Boolean | true/false | CHAR(1)('T' or 'F') |
2.Date and Time Type :
| Java Type | Hibernate Type | SQL Type |
| 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.Calender | calender | TIMESTAMP |
| java.util.Calender | calender_date | DATE |
3.Binary and Large Object Type :
| Java Type | Hibernate Type | SQL Type |
| byte[] | binary | VARBINARY/BLOB |
| java.lang.String | text | CLOB |
| any java class that implements java.io.Serializable | serializable | VARBINARY/BLOB |
| java.sql.Clob | clob | CLOB |
| java.sql.Blob | blob | BLOB |
4.Other JDK-related Type :
| Java Type | Hibernate Type | SQL Type |
| java.lang.Class | class | VARCHAR |
| java.util.Locale | locale | VARCHAR |
| java.util.TimeZone | timezone | VARCHAR |
| java.util.Currency | currency | VARCHAR |
If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.
Ask your questions, our development team will try to give answers to your questions.
Ask Questions? Discuss: Hibernate Data types
Post your Comment