[jira] [Updated] (NIFI-15455) PutDatabaseRecord uses wrong binding for BINARY type

["Jakub Bogusz (Jira)" <ji...@apache.org>]

     [ 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)