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

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

Attach filesAttach ScreenshotVotersWatch issueWatchersCreate sub-taskLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • None
    • 1.14.0
    • None
    • 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

        Activity

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            mattyb149 Matt Burgess
            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

                Slack

                  Issue deployment