[
https://issues.apache.org/jira/browse/NIFI-12828?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17820948#comment-17820948
]
Lehel Boér edited comment on NIFI-12828 at 2/27/24 4:10 AM:
------------------------------------------------------------
[~rnsingh] Could you please provide more information?
* Which processor did you use and in what kind of flow did you use when the
conversion mismatch happened? Did you use DatabaseSchemaRegistry?
* Which JDBC driver did you use?
I'm trying to reproduce the issue.
was (Author: lehel44):
[~rnsingh] Could you please provide more information? Which processor and what
flow did you use when the conversion mismatch happened? I'm trying to reproduce
the issue.
> 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
> Time Spent: 10m
> 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)
