Used in recent work, save a copy.
Java data type, Hibernate data type, corresponding tables between standard SQL data types
Java Data Type |
Hibernate Data Type |
Standard SQL data type (PS: different databases may be different) |
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 |