ResultSetMetaData Differences for API Calls
The connectors return different metadata for the following API calls.
getCatalogs
| Column Name | Version 1.x | Version 2.x | ||
TABLE_CAT |
Metadata | Value | Metadata | Value |
| Type Name | varchar | Type Name | VARCHAR | |
| Type ID | -16 | Type ID | 12 | |
| Display Size | 1073741824 | Display Size | 128 | |
| Precision | 1073741824 | Precision | 128 | |
| Scale | 0 | Scale | 0 | |
getColumns
| Column Name | Version 1.x | Version 2.x | ||
|
TABLE_CAT TABLE_SCHEM TABLE_NAME COLUMN_NAME TYPE_NAME IS_AUTOINCREMENT IS_GENERATEDCOLUMN |
Metadata | Value | Metadata | Value |
| Type Name | varchar | Type Name | VARCHAR | |
| Type ID | -16 | Type ID | 12 | |
| Display Size | 1073741824 | Display Size | 128 | |
| Precision | 1073741824 | Precision | 128 | |
| Scale | 0 | Scale | 0 | |
|
REMARKS COLUMN_DEF IS_NULLABLE SCOPE_CATALOG SCOPE_SCHEMA SCOPE_TABLE |
Metadata | Value | Metadata | Value |
| Type Name | varchar | Type Name | VARCHAR | |
| Type ID | -16 | Type ID | 12 | |
| Display Size | 1073741824 | Display Size | 254 | |
| Precision | 1073741824 | Precision | 254 | |
| Scale | 0 | Scale | 0 | |
SOURCE_DATA_TYPE |
Metadata | Value | Metadata | Value |
| Type Name | smallint | Type Name | INTEGER | |
| Type ID | 5 | Type ID | 4 | |
| Display Size | 6 | Display Size | 11 | |
| Precision | 5 | Precision | 10 | |
| Scale | 0 | Scale | 0 | |
getSchemas
| Column Name | Version 1.x | Version 2.x | ||
TABLE_SCHEMTABLE_CATALOG
|
Metadata | Value | Metadata | Value |
| Type Name | varchar | Type Name | VARCHAR | |
| Type ID | -16 | Type ID | 12 | |
| Display Size | 1073741824 | Display Size | 128 | |
| Precision | 1073741824 | Precision | 128 | |
| Scale | 0 | Scale | 0 | |
getTables
| Column Name | Version 1.x | Version 2.x | ||
TABLE_CATTABLE_SCHEMTABLE_NAMETABLE_TYPETYPE_CATTYPE_SCHEMTYPE_NAMESELF_REFERENCING_COL_NAMEREF_GENERATION
|
Metadata | Value | Metadata | Value |
| Type Name | varchar | Type Name | VARCHAR | |
| Type ID | -16 | Type ID | 12 | |
| Display Size | 1073741824 | Display Size | 128 | |
| Precision | 1073741824 | Precision | 128 | |
| Scale | 0 | Scale | 0 | |
REMARKS |
Metadata | Value | Metadata | Value |
| Type Name | varchar | Type Name | VARCHAR | |
| Type ID | -16 | Type ID | 12 | |
| Display Size | 1073741824 | Display Size | 254 | |
| Precision | 1073741824 | Precision | 254 | |
| Scale | 0 | Scale | 0 | |