[NIFI-8535] PutDatabaseRecord should give a better message when the table cannot be found

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.14.0
• Assignee: Matt Burgess
• Reporter: Matt Burgess
• Created: 12/May/21 18:43
• Updated: 14/May/21 19:59
• Resolved: 14/May/21 19:13

Description

Currently PutDatabaseRecord calls DatabaseMetaData.getColumns() to try and match the columns from the specified table to the fields in the incoming record(s). However if the table itself is not found, this method returns an empty ResultSet, so it is not known whether the table does not exist or if it exists with no columns.

PutDatabaseRecord should call DatabaseMetaData.getTables() if the column list is empty, and give a more descriptive error message if the table is not found. This can help the user determine whether there is a field/column mismatch or a catalog/schema/table name mismatch.

Issue Links

• links to: GitHub Pull Request #5070