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

Posted to issues@nifi.apache.org by "Aaron Leon (JIRA)" <ji...@apache.org> on 2019/03/04 05:42:00 UTC

[jira] [Created] (NIFI-6100) JdbcCommon does not support binary types for Phoenix

Aaron Leon created NIFI-6100:
--------------------------------

             Summary: JdbcCommon does not support binary types for Phoenix 
                 Key: NIFI-6100
                 URL: https://issues.apache.org/jira/browse/NIFI-6100
             Project: Apache NiFi
          Issue Type: Bug
            Reporter: Aaron Leon


The current implementation uses java.sql.PreparedStatement.setBinaryStream, which throws SQLFeatureNotSupportedException when used with org.apache.phoenix.jdbc.PhoenixPreparedStatement. A better alternative is to use setBytes. There will be no performance hit since the binary value is already read into memory in the current implementation, and it is implemented in PhoenixPreparedStatement so this will fix compatibility with Phoenix. It is also noted that PhoenixPreparedStatement should probably implement setBinaryStream anyways, so ideally a PR will be sent to Phoenix as well.

https://github.com/apache/nifi/blob/rel/nifi-1.7.0/nifi-nar-bundles/nifi-standard-bundle/nifi-standard-processors/src/main/java/org/apache/nifi/processors/standard/util/JdbcCommon.java#L832



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)