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