Default forward data type mappings for JDBC data sources

The following table lists the default forward data type mappings for JDBC data sources.

Table 1. JDBC default forward data type mappings
Remote Typename Remote Lower Len Remote Upper Len Remote Lower Scale Remote Upper Scale Remote Bit Data Remote Data Operators Federated Typename Federated Length Federated Scale Federated Bit Data
BIGINT - - - - - - BIGINT 8 - -
BINARY - 254 - - - - CHAR - - Y
BINARY 255 32672 - - - - VARCHAR - - Y
BINARY 32673 2147483647 - - - - BLOB 2147483647 - -
BIT - - - - - - SMALLINT 2 - -
BLOB - - - - - - BLOB 2147483647 - -
BOOLEAN - - - - - - SMALLINT 2 - -
CHAR - 254 - - - - CHAR - - -
CHAR 255 32672 - - - - VARCHAR - - -
CHAR 32673 2147483647 - - - - CLOB 2147483647 - -
CLOB - - - - - - CLOB 2147483647 - -
DATE - - - - - - DATE - - -
DATE - - - - - - TIMESTAMP1 - - -
DECIMAL 1 31 0 31 - - DECIMAL - - -
DECIMAL 32 38 0 38 - - DOUBLE 8 - -
DOUBLE - - - - - - DOUBLE 8 - -
FLOAT - - - - - - FLOAT 4 - -
INTEGER - - - - - - INTEGER 4 - -
LONGVARCHAR - 32672 - - - - VARCHAR - - -
LONGVARCHAR 32673 2147483647 - - - - CLOB 2147483647 - -
LONGVARBINARY - 32672 - - - - VARCHAR - - Y
LONGVARBINARY 32673 2147483647 - - - - BLOB 2147483647 - -
LONGNVARCHAR - 16336 - - - - VARGRAPHIC - - -
LONGNVARCHAR2 16337 1073741823 - - - - DBCLOB - - -
NCHAR2 - 127 - - - - GRAPHIC - - -
NCHAR2 128 16336 - - - - VARGRAPHIC - - -
NCHAR2 16337 1073741823 - - - - DBCLOB - - -
NCLOB2 - - - - - - DBCLOB - - -
NUMERIC 1 31 0 31 - - DECIMAL - - -
NUMERIC 32 38 0 38 - - DOUBLE 8 - -
NVARCHAR2 - 16336 - - - - VARGRAPHIC - - -
NVARCHAR2 16337 1073741823 - - - - DBCLOB - - -
REAL             REAL 4    
SMALLINT - - - - - - SMALLINT 2 - -
TIME - - - - - - TIME 3 - -
TIMESTAMP - - - - - - TIMESTAMP(6) 10 6 -
TIMESTAMP(p) - - - - - - TIMESTAMP(6) 10 6 -
TINYINT - - - - - - SMALLINT 2 - -
VARBINARY - 32672 - - - - VARCHAR - - Y
VARBINARY 32673 2147483647 - - - - BLOB 2147483647 - -
VARCHAR - 32672 - - - - VARCHAR - - -
VARCHAR 32673 2147483647 - - - - CLOB 2147483647 - -
Note:
  1. The federated type is TIMESTAMP(0) if the date_compat configuration parameter is set to ON.
  2. Data types that are only supported by the JDBC 4.0 driver: NCHAR, NVARCHAR, LONGVARCHAR, and NCLOB.

The following data types are unsupported by the JDBC wrapper: DATALINK, OTHER, JAVA_OBJECT, DISTINCT, STRUCT, ARRAY, and REF.