RAVINARAYAN SINGH created NIFI-12828:
----------------------------------------
Summary: DatabaseTableSchemaRegistry improvement to handle
BIT/Boolean Type
Key: NIFI-12828
URL: https://issues.apache.org/jira/browse/NIFI-12828
Project: Apache NiFi
Issue Type: Improvement
Affects Versions: 1.25.0
Reporter: RAVINARAYAN SINGH
Assignee: RAVINARAYAN SINGH
The issue stems from the fact that for the PostgreSQL JDBC driver, the Boolean
type is mapped to {{{}java.sql.Types.BIT{}}}, not {{{}BOOLEAN{}}}. This causes
the line {{columnResultSet.getInt("DATA_TYPE")}} to return -7, which
corresponds to {{{}BIT{}}}, and
{{DataTypeUtils.getDataTypeFromSQLTypeValue(dataType)}} to return {{{}null{}}},
leading to a null pointer exception.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
