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

Write JSON record in database

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Resolved
    • Minor
    • Resolution: Not A Problem
    • 1.8.0
    • None
    • None
    • None

    Description

      It would be good to be able to store a whole json record in databases that implement it (e.g. postgresql). This would require to define the field in the shema as json/jsonb and then let PutDatabaseRecord inserts the json value in the json/jsonb field.

      At the moment, it's possible to store a json/jsonb through Postgresql JDBC using the Java sql type 'OTHER':

      Object data = "{...}"; // the JSON document

      PreparedStatement.setObject(1, data, java.sql.Types.OTHER);

      Attachments

        Activity

          People

            mike.thomsen Mike Thomsen
            trourance Flo Rance
            Votes:
            3 Vote for this issue
            Watchers:
            6 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 - 4h 10m
                4h 10m