The following table lists the standard Java data types and their mappings. These types are used to map table columns to entity object attributes. Types that were added to this table in version 3.2 are highlighted.
|
Database Column Type |
Java Class Name |
JDBC Type |
JDBC SQL Type ID |
Int |
|
NUMBER |
java.lang.Boolean |
BIT |
BIT |
-7 |
|
VARCHAR2 |
java.lang.String |
VARCHAR |
VARCHAR |
12 |
|
NVARCHAR2 |
java.lang.String |
VARCHAR |
VARCHAR |
12 |
|
CHAR |
java.lang.String |
CHAR |
CHAR |
1 |
|
VARCHAR |
java.lang.String |
VARCHAR |
VARCHAR |
12 |
|
LONG |
java.lang.String |
LONGVARCHAR |
LONGVARCHAR |
-1 |
|
VARCHAR |
java.lang.String |
VARCHAR |
VARCHAR |
12 |
|
NUMBER |
java.lang.Integer |
NUMERIC |
NUMBER |
2 |
|
NUMBER |
java.math.BigDecimal |
NUMERIC |
NUMBER |
2 |
|
TIMESTAMP |
java.sql.Timestamp |
TIMESTAMP |
TIMESTAMP |
93 |
|
DATE |
java.sql.Date |
DATE |
DATE |
91 |
|
STRUCT |
java.lang.Object |
STRUCT |
STRUCT |
2002 |
|
STRUCT |
java.lang.Object |
OTHER |
OTHER |
1111 |
See the Java type map class.