[
https://issues.apache.org/jira/browse/NIFI-15455?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jakub Bogusz updated NIFI-15455:
--------------------------------
Description:
For BINARY SQL Type `setObject` gets called instead of `setBytes`. Some
database drivers detect calls to `setObject` with `byte[]` and route to
`setBytes` internally, but not all, so this leads to errors such as following:
{code:java}
SQL compilation error: Invalid bind value ([B@290283be) for type (BINARY).
{code}
was:
For BINARY SQL Type `setObject` gets called instead of `setBytes`. Some
database drivers detect calls to `setObject` with `byte[]` and route to
`setBytes` internally, but not all, so this leads to errors such a following:
{code:java}
SQL compilation error: Invalid bind value ([B@290283be) for type (BINARY).
{code}
> PutDatabaseRecord uses wrong binding for BINARY type
> ----------------------------------------------------
>
> Key: NIFI-15455
> URL: https://issues.apache.org/jira/browse/NIFI-15455
> Project: Apache NiFi
> Issue Type: Bug
> Components: Extensions
> Affects Versions: 2.7.2
> Reporter: Jakub Bogusz
> Priority: Major
> Time Spent: 10m
> Remaining Estimate: 0h
>
> For BINARY SQL Type `setObject` gets called instead of `setBytes`. Some
> database drivers detect calls to `setObject` with `byte[]` and route to
> `setBytes` internally, but not all, so this leads to errors such as following:
> {code:java}
> SQL compilation error: Invalid bind value ([B@290283be) for type (BINARY).
> {code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
