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)
