You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@nifi.apache.org by "RAVINARAYAN SINGH (Jira)" <ji...@apache.org> on 2024/02/21 05:18:00 UTC

[jira] [Created] (NIFI-12828) DatabaseTableSchemaRegistry improvement to handle BIT/Boolean Type

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)