Skip to main content
Adaptive Insights
Knowledge and Support - Adaptive Insights

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

 

  • Was this article helpful?