nifi-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Mike Thomsen (Jira)" <j...@apache.org>
Subject [jira] [Assigned] (NIFI-5901) Write JSON record in database
Date Mon, 23 Dec 2019 15:55:00 GMT

     [ https://issues.apache.org/jira/browse/NIFI-5901?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Mike Thomsen reassigned NIFI-5901:
----------------------------------

    Assignee: Mike Thomsen

[~mattyb149] I'll run this down with 1.11.0-snapshot and report back.

> Write JSON record in database
> -----------------------------
>
>                 Key: NIFI-5901
>                 URL: https://issues.apache.org/jira/browse/NIFI-5901
>             Project: Apache NiFi
>          Issue Type: Improvement
>    Affects Versions: 1.8.0
>            Reporter: Flo Rance
>            Assignee: Mike Thomsen
>            Priority: Minor
>
> 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);



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

Mime
View raw message