[NIFI-9064] ExecuteSQLRecord support Oracle timestamp when `Use Avro Logical Types` is true

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.14.0
• Fix Version/s: 1.16.0
• Component/s: Extensions
• Assignee: ZhangCheng
• Reporter: ZhangCheng
• Created: 19/Aug/21 11:37
• Updated: 02/Mar/22 16:19
• Resolved: 02/Mar/22 16:19

Description

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

```

Issue Links

• links to: GitHub Pull Request #5318
• links to: GitHub Pull Request #5807