[ https://issues.apache.org/jira/browse/NIFI-12828?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Matt Burgess updated NIFI-12828: -------------------------------- Resolution: Fixed Status: Resolved (was: Patch Available) > 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 > Priority: Major > Labels: controller_services > Fix For: 2.0.0, 1.26.0 > > Time Spent: 2h > Remaining Estimate: 0h > > 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)