[ https://issues.apache.org/jira/browse/NIFI-9064?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
ZhangCheng resolved NIFI-9064. ------------------------------ Resolution: Fixed > ExecuteSQLRecord support Oracle timestamp when `Use Avro Logical Types` is > true > -------------------------------------------------------------------------------- > > Key: NIFI-9064 > URL: https://issues.apache.org/jira/browse/NIFI-9064 > Project: Apache NiFi > Issue Type: Bug > Components: Extensions > Affects Versions: 1.14.0 > Reporter: ZhangCheng > Assignee: ZhangCheng > Priority: Major > Fix For: 1.15.0 > > Time Spent: 20m > Remaining Estimate: 0h > > When the source db is Oracle, and the table has `timestamp` column, using > `ExecuteSQLRecord`(the same as `QueryDatabaseTableRecord`) and set `Use Avro > Logical Types` true, we will get sth like this: > ``` > Caused by: java.io.IOException: > org.apache.nifi.serialization.record.util.IllegalTypeConversionException: > Cannot convert value [2021-08-19 10:58:50.000001] of type class > oracle.sql.TIMESTAMP to Timestamp for field TS > at > org.apache.nifi.processors.standard.sql.RecordSqlWriter.writeResultSet(RecordSqlWriter.java:88) > at > org.apache.nifi.processors.standard.AbstractExecuteSQL.lambda$onTrigger$1(AbstractExecuteSQL.java:302) > ... 14 common frames omitted > ``` -- This message was sent by Atlassian Jira (v8.3.4#803005)