[NIFI-4903] Database Fetch processors cannot handle timestamp fields with Oracle 12+

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.6.0
• Component/s: Extensions
• Assignee: Matt Burgess
• Reporter: Matt Burgess
• Created: 22/Feb/18 18:43
• Updated: 25/Feb/18 17:15
• Resolved: 22/Feb/18 19:57

Description

When using GenerateTableFetch or QueryDatabaseTable with an Oracle 12+ adapter, if the maximum value column is set to a column of type timestamp, then upon the second fetch the following error occurs:

java.sql.SQLDataException: ORA-01843: not a valid month

 

Issue Links

• links to: GitHub Pull Request #2488