ZhangCheng created NIFI-9064:
--------------------------------
Summary: 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
Fix For: 1.15.0
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)
