Share on Google+Share on Google+

Hibernate Data types

This section lists Hibernate data types.

Hibernate Data types

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 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



Posted on: July 21, 2012 If you enjoyed this post then why not add us on Google+? Add us to your Circles

Share this Tutorial Follow us on Twitter, or add us on Facebook or Google Plus to keep you updated with the recent trends of Java and other open source platforms.

Discuss: Hibernate Data types  

Post your Comment

Your Name (*) :
Your Email :
Subject (*):
Your Comment (*):
  Reload Image