[NIFI-1239] ConvertJSONToSQL should cache results from database resultset metadata

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.4.0
• Component/s: Extensions
• Assignee: Mark Payne
• Reporter: Mark Payne
• Created: 02/Dec/15 20:07
• Updated: 02/Dec/15 22:41
• Resolved: 02/Dec/15 22:41

Description

Currently, when we convert JSON to SQL, we make calls to the database to determine the type of each column that we are converting. We should cache this information instead of calling to the database each time, as performance will be greatly improved. We should be sure not to cache indefinitely, though, as the schema could change.