[jira] [Commented] (NIFI-5901) Write JSON record in database

["Mike Thomsen (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/NIFI-5901?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16723028#comment-16723028 ] 

Mike Thomsen commented on NIFI-5901:
------------------------------------

Whoever decides to take this on should refer to this conversation to get some initial research out of the way on supporting more than just Postgres and JSON (as opposed to JSON + JSONB)

 

http://apache-nifi-users-list.2361937.n4.nabble.com/JSON-record-in-database-td6467.html

> 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
>            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
(v7.6.3#76005)