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 |