The following table lists the data types supported by Oracle Business Components for Java. These types are used to map table columns to entity attributes. In addition, you can use a custom domain as a type.
In this release of JDeveloper, support for TIMESTAMP columns with local timezones was added through a TIMESTAMP domain. In addition, Business Components for Java automatically creates domains for nested tables and VARRAYs when you are performing reverse generation. VARRAYs are supported for forward generation, but nested tables are not.
Note that both nested tables and VARRAYs are mapped to oracle.jbo.domain.Array.
| Database Column Type | Java Class Name | JDBC Type | JDBC SQL Type ID | Int |
|---|---|---|---|---|
|
TINYINT |
oracle.jbo.domain.Number |
TINYINT |
TINYINT |
-6 |
|
SMALLINT |
oracle.jbo.domain.Number |
SMALLINT |
SMALLINT |
5 |
|
INTEGER |
oracle.jbo.domain.Number |
INTEGER |
INTEGER |
4 |
|
BIGINT |
oracle.jbo.domain.Number |
NUMERIC |
NUMERIC |
2 |
| INT | oracle.jbo.domain.Number | NUMERIC | NUMERIC | 2 |
|
REAL |
oracle.jbo.domain.Number |
REAL |
REAL |
7 |
|
DOUBLE |
oracle.jbo.domain.Number |
DOUBLE |
DOUBLE |
8 |
|
FLOAT |
oracle.jbo.domain.Number |
FLOAT |
FLOAT |
6 |
|
DECIMAL |
oracle.jbo.domain.Number |
DECIMAL |
DECIMAL |
3 |
|
NUMERIC |
oracle.jbo.domain.Number |
NUMERIC |
NUMBER |
2 |
|
BIT |
oracle.jbo.domain.Number |
BIT |
BIT |
-7 |
|
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 |
|
RAW |
oracle.jbo.domain.Raw |
BINARY |
BINARY |
-2 |
|
RAW |
oracle.jbo.domain.Raw |
VARBINARY |
VARBINARY |
-3 |
|
RAW |
oracle.jbo.domain.Raw |
LONGVARBINARY |
LONGVARBINARY |
-4 |
|
LONG RAW |
oracle.jbo.domain.Raw |
LONGVARBINARY |
LONGVARBINARY |
-4 |
|
CLOB |
oracle.jbo.domain.ClobDomain |
CLOB |
CLOB |
2005 |
|
BLOB |
oracle.jbo.domain.BlobDomain |
BLOB |
BLOB |
2004 |
|
BFILE |
oracle.jbo.domain.BFileDomain |
BFILE |
BFILE |
-13 |
|
TIMESTAMP |
oracle.jbo.domain.Date |
TIMESTAMP |
TIMESTAMP |
93 |
|
TIME |
oracle.jbo.domain.Date |
TIMESTAMP |
TIME |
92 |
|
TIME |
oracle.jbo.domain.Date |
TIMESTAMP |
TIMESTAMP |
93 |
|
DATE |
oracle.jbo.domain.Date |
DATE |
DATE |
91 |
|
DATE |
oracle.jbo.domain.Date |
TIMESTAMP |
TIMESTAMP |
93 |
| DATETIME | oracle.jbo.domain.Date | TIMESTAMP | * see note below | 93 |
|
ROWID |
oracle.jbo.domain.RowID |
VARCHAR |
VARCHAR |
12 |
|
VARCHAR2 |
oracle.jbo.domain.Char |
VARCHAR |
VARCHAR |
12 |
|
NVARCHAR2 |
oracle.jbo.domain.Char |
VARCHAR |
VARCHAR |
12 |
|
CHAR |
oracle.jbo.domain.Char |
CHAR |
CHAR |
1 |
|
VARCHAR |
oracle.jbo.domain.Char |
VARCHAR |
VARCHAR |
12 |
|
LONG |
oracle.jbo.domain.Char |
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 |
|
ORDSYS.ORDIMAGE |
oracle.ord.im.OrdImageDomain |
STRUCT |
STRUCT |
2002 |
|
ORDSYS.ORDAUDIO |
oracle.ord.im.OrdAudioDomain |
STRUCT |
STRUCT |
2002 |
|
ORDSYS.ORDVIDEO |
oracle.ord.im.OrdVideoDomain |
STRUCT |
STRUCT |
2002 |
|
ORDSYS.ORDVIR |
oracle.ord.im.OrdVirDomain |
STRUCT |
STRUCT |
2002 |
| ORDSYS.ORDDOC | oracle.ord.im.OrdDocDomain | STRUCT | STRUCT | 2002 |
| ORDSYS.ORDIMAGESIGNATURE | oracle.ord.im.OrdImageSignatureDomain | STRUCT | STRUCT | 2002 |
|
ARRAY |
oracle.jbo.domain.Array |
ARRAY |
ARRAY |
2003 |
|
REF |
oracle.sql.REF |
REF |
REF |
2006 |
|
STRUCT |
java.lang.Object |
OTHER |
OTHER |
1111 |
*Note: All JDBC SQL Type IDs are of OracleType.<JDBC type> except DATETIME which is of the type java.sql.Types.TIMESTAMP.