Uploaded image for project: 'Spring XD'
  1. Spring XD
  2. XD-2250

Improve type handling for jdbc sink

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: To Do
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: Stream Module
    • Labels:
      None

      Description

      The jdbc sink is currently limited to handling the entire payload as a string and converting a single json object to row data. We should improve that and support the following input types:

      • LinkedCaseInsensitiveMap (single row)
      • List<LinkedCaseInsensitiveMap> (multiple rows as a batch insert)
      • JSON string {"ID":74488,"NAME":"Foo","YEAR":"2014"}

        (single row)

      • JSON array [ {"ID":74488,"NAME":"Foo","YEAR":"2014"}

        ,

        {"ID":74489,"NAME":"Bar","YEAR":"2014"}

        ] (multiple rows as a batch insert)

      • none of the above use payload.toString()

      The above matches what the new jdbc source puts out (depending on outputType used)

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned
              Reporter:
              thomas.risberg Thomas Risberg
              Votes:
              1 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated: