Matt Burgess created NIFI-8535: ---------------------------------- Summary: PutDatabaseRecord should give a better message when the table cannot be found Key: NIFI-8535 URL: https://issues.apache.org/jira/browse/NIFI-8535 Project: Apache NiFi Issue Type: Improvement Reporter: Matt Burgess
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. -- This message was sent by Atlassian Jira (v8.3.4#803005)