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