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)

Reply via email to