[ 
https://issues.apache.org/jira/browse/NIFI-1841?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15507556#comment-15507556
 ] 

ASF subversion and git services commented on NIFI-1841:
-------------------------------------------------------

Commit 68291636cb3e823013c430ccbffbc449d178b89d in nifi's branch 
refs/heads/master from [~mattyb149]
[ https://git-wip-us.apache.org/repos/asf?p=nifi.git;h=6829163 ]

NIFI-1841: Fixed support for CLOB/BLOB types

This closes #1035.

Signed-off-by: Bryan Bende <bbe...@apache.org>


> SQLFeatureNotSupportedException with ExecuteSQL and Oracle Driver
> -----------------------------------------------------------------
>
>                 Key: NIFI-1841
>                 URL: https://issues.apache.org/jira/browse/NIFI-1841
>             Project: Apache NiFi
>          Issue Type: Bug
>            Reporter: Bryan Bende
>            Assignee: Matt Burgess
>            Priority: Minor
>             Fix For: 1.1.0
>
>
> Using ExecuteSQL with the Oracle ojdbc7.jar, the following exception is 
> produced:
> {code}
> java.sql.SQLFeatureNotSupportedException: Unsupported feature 
> at oracle.jdbc.driver.ClobAccessor.getBytes(ClobAccessor.java:534) ~[na:na] 
> at 
> oracle.jdbc.driver.GeneratedStatement.getBytes(GeneratedStatement.java:151) 
> ~[na:na] 
> at 
> oracle.jdbc.driver.GeneratedScrollableResultSet.getBytes(GeneratedScrollableResultSet.java:326)
>  ~[na:na] 
> at 
> org.apache.commons.dbcp.DelegatingResultSet.getBytes(DelegatingResultSet.java:241)
>  ~[na:na] 
> at 
> org.apache.commons.dbcp.DelegatingResultSet.getBytes(DelegatingResultSet.java:241)
>  ~[na:na] 
> at 
> org.apache.nifi.processors.standard.util.JdbcCommon.convertToAvroStream(JdbcCommon.java:105)
>  ~[nifi-standard-processors-0.6.1.jar:0.6.1] 
> at 
> org.apache.nifi.processors.standard.util.JdbcCommon.convertToAvroStream(JdbcCommon.java:72)
>  ~[nifi-standard-processors-0.6.1.jar:0.6.1] 
> at 
> org.apache.nifi.processors.standard.ExecuteSQL$1.process(ExecuteSQL.java:158) 
> ~[nifi-standard-processors-0.6.1.jar:0.6.1] 
> {code}
> The issue appears to be related to calling ResultSet getBytes().



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Reply via email to