[
https://issues.apache.org/jira/browse/NIFI-2356?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Peter Wicks updated NIFI-2356:
------------------------------
Description:
ConvertJSONToSQL Processor, it assumes that the column "IS_AUTOINCREMENT" will
always be available.
When using Teradata JDBC driver this column is not available. Available
columns are:
TABLE_CAT
TABLE_SCHEM
TABLE_NAME
COLUMN_NAME
DATA_TYPE
TYPE_NAME
COLUMN_SIZE
BUFFER_LENGTH
DECIMAL_DIGITS
NUM_PREC_RADIX
NULLABLE
REMARKS
COLUMN_DEF
SQL_DATA_TYPE
SQL_DATETIME_SUB
CHAR_OCTET_LENGTH
ORDINAL_POSITION
IS_NULLABLE
SCOPE_CATLOG
SCOPE_SCHEMA
SCOPE_TABLE
SOURCE_DATA_TYPE
was:
ConvertJSONToSQL.java assumes that the column "IS_AUTOINCREMENT" will always be
available.
When using Teradata JDBC driver this column is not available. Available
columns are:
TABLE_CAT
TABLE_SCHEM
TABLE_NAME
COLUMN_NAME
DATA_TYPE
TYPE_NAME
COLUMN_SIZE
BUFFER_LENGTH
DECIMAL_DIGITS
NUM_PREC_RADIX
NULLABLE
REMARKS
COLUMN_DEF
SQL_DATA_TYPE
SQL_DATETIME_SUB
CHAR_OCTET_LENGTH
ORDINAL_POSITION
IS_NULLABLE
SCOPE_CATLOG
SCOPE_SCHEMA
SCOPE_TABLE
SOURCE_DATA_TYPE
> ConvertJSONToSQL Assumes IS_AUTOINCREMENT
> -----------------------------------------
>
> Key: NIFI-2356
> URL: https://issues.apache.org/jira/browse/NIFI-2356
> Project: Apache NiFi
> Issue Type: Bug
> Components: Extensions
> Affects Versions: 0.7.0
> Environment: Teradata JDBC
> Reporter: Peter Wicks
>
> ConvertJSONToSQL Processor, it assumes that the column "IS_AUTOINCREMENT"
> will always be available.
> When using Teradata JDBC driver this column is not available. Available
> columns are:
> TABLE_CAT
> TABLE_SCHEM
> TABLE_NAME
> COLUMN_NAME
> DATA_TYPE
> TYPE_NAME
> COLUMN_SIZE
> BUFFER_LENGTH
> DECIMAL_DIGITS
> NUM_PREC_RADIX
> NULLABLE
> REMARKS
> COLUMN_DEF
> SQL_DATA_TYPE
> SQL_DATETIME_SUB
> CHAR_OCTET_LENGTH
> ORDINAL_POSITION
> IS_NULLABLE
> SCOPE_CATLOG
> SCOPE_SCHEMA
> SCOPE_TABLE
> SOURCE_DATA_TYPE
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
