[NIFI-1841] SQLFeatureNotSupportedException with ExecuteSQL and Oracle Driver

• Type: Bug
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Fix Version/s: 1.1.0
• Assignee: Matt Burgess
• Reporter: Bryan Bende
• Created: 03/May/16 13:35
• Updated: 20/Sep/16 19:34
• Resolved: 20/Sep/16 19:34

Description

Using ExecuteSQL with the Oracle ojdbc7.jar, the following exception is produced:

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] 

The issue appears to be related to calling ResultSet getBytes().

Issue Links

• links to: GitHub Pull Request #1035