Supported generic JDBC data types

For generic JDBC configurations (and some other specific databases) XDM maps from the JDBC data type to the internal Generic SQL data type. Refer to your JDBC drivers manual how the data types are represented as java.sql.Types constant.

Datatype	Generic SQL datatype	Java datatype for modification
ARRAY	ARRAY	not supported
BIGINT	INT	java.math.BigDecimal
BINARY	BINARY	java.lang.byte[]
BIT_STRING	BIT_STRING	java.lang.byte[]
BIT	BIT	java.math.BigDecimal
BLOB	BLOB	java.sql.Blob
BOOLEAN	BOOLEAN	java.math.BigDecimal
BOX	BOX	PGbox
CHAR	CHAR	java.lang.String
CIRCLE	CIRCLE	PGcircle
CLOB	CLOB	java.sql.Clob
DATALINK	DATALINK	not supported
DATE	DATE	de.ubs.xdm.utils.core.HighPrecisionTimestamp
DECIMAL	DECIMAL	java.math.BigDecimal
DISTINCT	DISTINCT	not supported
DOUBLE	DOUBLE	java.math.BigDecimal
ELEM_INFO_ARRAY	ELEM_INFO_ARRAY	not supported
FLOAT	FLOAT	java.math.BigDecimal
GEOGRAPHY	GEOGRAPHY	com.microsoft.sqlserver.jdbc.Geography
INTEGER	INTEGER	java.math.BigDecimal
JAVA_OBJECT	JAVA_OBJECT	not supported
JSONB	JSONB	java.lang.String
JSON	JSON	java.lang.String
LINE	LINE	PGline
LONGNVARCHAR	LONGNVARCHAR	java.lang.String
LONGVARBINARY	LONGVARBINARY	java.lang.byte[]
LONGVARCHAR	LONGVARCHAR	java.lang.String
LSEG	LSEG	PGlseg
NCHAR	CHAR	java.lang.String
NCLOB	NCLOB	java.sql.Clob
NULL	NULL	not supported
NUMERIC	NUMERIC	java.math.BigDecimal
NVARCHAR	VARCHAR	java.lang.String
ORDINATE_ARRAY	ORDINATE_ARRAY	not supported
OTHER	OTHER	not supported
PATH	PATH	PGpath
POINT_TYPE	POINT_TYPE	not supported
POLYGON	POLYGON	PGpolygon
REAL	REAL	java.math.BigDecimal
REF_CURSOR	REF_CURSOR	not supported
REF	REF	not supported
ROWID	ROWID	java.lang.byte[]
SMALLINT	SMALLINT	java.math.BigDecimal
SQLXML	SQLXML	java.sql.Clob
STRUCT	STRUCT	not supported
SYSNAME	SYSNAME	java.lang.String
TIMESTAMP_WITH_TIMEZONE	TIMESTAMP_WITH_TIMEZONE	de.ubs.xdm.utils.core.HighPrecisionTimestamp
TIMESTAMP	TIMESTAMP	de.ubs.xdm.utils.core.HighPrecisionTimestamp
TIME_WITH_TIMEZONE	TIME_WITH_TIMEZONE	de.ubs.xdm.utils.core.HighPrecisionTimestamp
TIME	TIME	de.ubs.xdm.utils.core.HighPrecisionTimestamp
TINYINT	TINYINT	java.math.BigDecimal
UUID	UUID	java.lang.String
VARBINARY	VARBINARY	java.lang.byte[]
VARCHAR	VARCHAR	java.lang.String
VAR_BIT_STRING	VAR_BIT_STRING	java.lang.byte[]

Datatype

Generic SQL datatype

Java datatype for modification

ARRAY

not supported

BIGINT

INT

java.math.BigDecimal

BINARY

java.lang.byte[]

BIT_STRING

java.lang.byte[]

BIT

java.math.BigDecimal

BLOB

java.sql.Blob

BOOLEAN

java.math.BigDecimal

BOX

PGbox

CHAR

java.lang.String

CIRCLE

PGcircle

CLOB

java.sql.Clob

DATALINK

not supported

DATE

de.ubs.xdm.utils.core.HighPrecisionTimestamp

DECIMAL

java.math.BigDecimal

DISTINCT

not supported

DOUBLE

java.math.BigDecimal

ELEM_INFO_ARRAY

not supported

FLOAT

java.math.BigDecimal

GEOGRAPHY

com.microsoft.sqlserver.jdbc.Geography

INTEGER

java.math.BigDecimal

JAVA_OBJECT

not supported

JSONB

java.lang.String

JSON

java.lang.String

LINE

PGline

LONGNVARCHAR

java.lang.String

LONGVARBINARY

java.lang.byte[]

LONGVARCHAR

java.lang.String

LSEG

PGlseg

NCHAR

CHAR

java.lang.String

NCLOB

java.sql.Clob

NULL

not supported

NUMERIC

java.math.BigDecimal

NVARCHAR

VARCHAR

java.lang.String

ORDINATE_ARRAY

not supported

OTHER

not supported

PATH

PGpath

POINT_TYPE

not supported

POLYGON

PGpolygon

REAL

java.math.BigDecimal

REF_CURSOR

not supported

REF

not supported

ROWID

java.lang.byte[]

SMALLINT

java.math.BigDecimal

SQLXML

java.sql.Clob

STRUCT

not supported

SYSNAME

java.lang.String

TIMESTAMP_WITH_TIMEZONE

de.ubs.xdm.utils.core.HighPrecisionTimestamp

TIMESTAMP

de.ubs.xdm.utils.core.HighPrecisionTimestamp

TIME_WITH_TIMEZONE

de.ubs.xdm.utils.core.HighPrecisionTimestamp

TIME

de.ubs.xdm.utils.core.HighPrecisionTimestamp

TINYINT

java.math.BigDecimal

UUID

java.lang.String

VARBINARY

java.lang.byte[]

VARCHAR

java.lang.String

VAR_BIT_STRING

java.lang.byte[]