Uploaded image for project: 'Apache NiFi'
  1. Apache NiFi
  2. NIFI-8535

PutDatabaseRecord should give a better message when the table cannot be found

    XMLWordPrintableJSON

    Details

    • Type: Improvement
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 1.14.0
    • Component/s: None
    • Labels:
      None

      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.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                mattyb149 Matt Burgess
                Reporter:
                mattyb149 Matt Burgess
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 50m
                  50m