Supported JDBC-compliant Data Types
Adaptive Integration supported JDBC-compliant data types
Adaptive Integration only supports a subset of the JDBC-compliant data types. Those data types not supported are not reported back to the server during the import structure process.
The JDBC drivers map the underlying data types to a JDBC type, so to understand what DBMS types are supported, you need to consult documentation for the specific DBMS. This section contains the supported data types for general JDBC-compliant databases, Oracle, SQL Server, and H2 databases.
Supported JDBC data types
JDBC TYPE | DISCOVERY TYPE |
---|---|
CHAR | STRING |
VARCHAR | STRING |
LONGVARCHAR | STRING |
BIT | BOOLEAN |
BOOLEAN | BOOLEAN |
TINYINT | LONG |
SMALLINT | LONG |
INTEGER | LONG |
BIGINT | LONG |
REAL | DOUBLE |
DOUBLE | DOUBLE |
FLOAT | DOUBLE |
DATE | DATE |
TIME | DATE |
TIMESTAMP | DATE |
The following JDBC types are not supported: BINARY, VARBINARY, LONGVARBINARY, DECIMAL, and NUMERIC.
Supported MS SQL Server data types
SQL Server | JDBC | Support |
---|---|---|
bigint | BIGINT | Y |
bit | BIT | Y |
decimal | DECIMAL | N |
int | INTEGER | Y |
money | DECIMAL | N |
numeric | NUMERIC | N |
smallint | SMALLINT | Y |
smallmoney | DECIMAL | N |
tinyint | TINYINT | Y |
float | DOUBLE | Y |
real | REAL | Y |
date | VARCHAR | Y |
datetime2 | VARCHAR | Y |
datetime | TIMESTAMP | Y |
datetimeoffset | VARCHAR | Y |
smalldatetime | TIMESTAMP | Y |
time | VARCHAR | Y |
char | CHAR | Y |
varchar | VARCHAR | Y |
text | CLOB | N |
nchar | CHAR | Y |
nvarchar | CLOB | N |
ntext | CLOB | N |
binary | BINARY | N |
image | BLOB | N |
hierarchyid | BLOB | N |
sql_variant | VARCHAR | Y |
timestamp | BINARY | N |
uniqueidentifier | CHAR | Y |
xml | CLOB | N |
Supported Oracle data types
SQL Server | JDBC | Support |
---|---|---|
CHAR | CHAR | Y |
VARCHAR2 | VARCHAR | Y |
NCHAR | OTHER | N |
NVARCHAR2 | OTHER | N |
NUMBER | DECIMAL | N |
FLOAT | FLOAT | Y |
BINARY_FLOW | ?100 | N |
BINARY_DOUBLE | ?101 | N |
RAW | VARBINARY | N |
DATE | TIMESTAMP | Y |
TIMESTAMP | TIMESTAMP | Y |
INTERVAL_YEAR_TO_MONTH | ?-103 | N |
INTERVAL_DAY_TO_SECOND | ?-104 | N |
BLOB | BLOB | N |
CLOB | CLOB | N |
NCLOB | OTHER | N |
BFILE | ?-13 | N |
CHARACTER | CHAR | Y |
VARCHAR | VARCHAR | Y |
NATIONAL_CHARACTER | OTHER | N |
NATIONAL_CHAR | OTHER | N |
NUMERIC | DECIMAL | N |
DECIMAL | DECIMAL | N |
DEC | DECIMAL | N |
INTEGER | DECIMAL | N |
INT | DECIMAL | N |
SMALLINT | DECIMAL | N |
DOUBLE_PRECISION | FLOAT | Y |
REAL | FLOAT | Y |
Supported H2 data types
SQL Server | JDBC | Support |
---|---|---|
INT | INTEGER | Y |
INTEGER | INTEGER | Y |
MEDIUMINT | INTEGER | Y |
INT4 | INTEGER | Y |
SIGNED | INTEGER | Y |
BOOLEAN | BOOLEAN | Y |
BIT | BOOLEAN | Y |
BOOL | BOOLEAN | Y |
TINYINT | TINYINT | Y |
SMALLINT | SMALLINT | Y |
INT2 | SMALLINT | Y |
YEAR | SMALLINT | Y |
BIGINT | BIGINT | Y |
IDENTITY | BIGINT | Y |
DECIMAL | DECIMAL | N |
NUMBER | DECIMAL | N |
DEC | DECIMAL | N |
NUMERIC | DECIMAL | N |
DOUBLE | DOUBLE | Y |
FLOAT | DOUBLE | Y |
FLOAT4 | REAL | Y |
FLOAT8 | DOUBLE | Y |
REAL | REAL | Y |
TIME | TIME | Y |
DATE | DATE | Y |
TIMESTAMP | TIMESTAMP | Y |
DATETIME | TIMESTAMP | Y |
SMALLDATETIME | TIMESTAMP | Y |
BINARY | VARBINARY | N |
VARBINARY | VARBINARY | N |
LONGVARBINARY | VARBINARY | N |
RAW | VARBINARY | N |
BYTEA | VARBINARY | N |
OTHER | OTHER | N |
VARCHAR | VARCHAR | Y |
LONGVARCHAR | VARCHAR | Y |
VARCHAR2 | VARCHAR | Y |
NVARCHAR | VARCHAR | Y |
NVARCHAR2 | VARCHAR | Y |
VARCHAR_CASESENSTIVE | VARCHAR | Y |
VARCHAR_IGNORECASE | VARCHAR | Y |
CHAR | CHAR | Y |
CHARACTER | CHAR | Y |
NCHAR | CHAR | Y |
BLOB | BLOB | N |
TINYBLOB | BLOB | N |
MEDIUMBLOB | BLOB | N |
LONGBLOB | BLOB | N |
IMAGE | BLOB | N |
OID | BLOB | N |
CLOB | CLOB | N |