Supported Oracle data types
| Datatype | Generic SQL datatype | Java datatype for modification |
|---|---|---|
BFILE |
BLOB |
java.sql.Blob |
BINARY_DOUBLE |
DOUBLE |
java.math.BigDecimal |
BINARY_FLOAT |
FLOAT |
java.math.BigDecimal |
BLOB |
BLOB |
java.sql.Blob |
CHAR |
CHAR |
java.lang.String |
CLOB |
CLOB |
java.sql.Clob |
DATE |
TIMESTAMP |
de.ubs.xdm.utils.core.HighPrecisionTimestamp |
DOUBLE |
DECIMAL |
java.math.BigDecimal |
FLOAT |
DECIMAL |
java.math.BigDecimal |
LONG RAW |
LONGVARCHAR |
java.lang.byte[] |
LONG |
LONGVARCHAR |
java.lang.String |
NCHAR |
NCHAR |
java.lang.String |
NCLOB |
CLOB |
java.sql.Clob |
NUMBER |
DECIMAL |
java.math.BigDecimal |
NVARCHAR2 |
NVARCHAR |
java.lang.String |
NVARCHAR |
NVARCHAR |
java.lang.String |
RAW |
VARCLOB |
java.lang.byte[] |
ROWID |
ROWID |
java.lang.byte[] |
SDO_ELEM_INFO_ARRAY |
ELEM_INFO_ARRAY |
not supported |
SDO_GEOMETRY |
GEOGRAPHY |
com.microsoft.sqlserver.jdbc.Geography |
SDO_ORDINATE_ARRAY |
ORDINATE_ARRAY |
not supported |
SDO_POINT_TYPE |
POINT_TYPE |
not supported |
TIMESTAMP WITH LOCAL TIME ZONE |
TIMESTAMP_WITH_TIMEZONE |
de.ubs.xdm.utils.core.HighPrecisionTimestamp |
TIMESTAMP WITH TIME ZONE |
TIMESTAMP_WITH_TIMEZONE |
de.ubs.xdm.utils.core.HighPrecisionTimestamp |
TIMESTAMP |
TIMESTAMP |
de.ubs.xdm.utils.core.HighPrecisionTimestamp |
UROWID |
ROWID |
java.lang.byte[] |
VARCHAR2 |
VARCHAR |
java.lang.String |
VARCHAR |
VARCHAR |
java.lang.String |
XMLTYPE |
SQLXML |
java.sql.Clob |