You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@nifi.apache.org by ijokarumawak <gi...@git.apache.org> on 2017/09/12 03:08:33 UTC

[GitHub] nifi issue #2145: NIFI-4352: Add CLOB and NCLOB support to PutSQL

Github user ijokarumawak commented on the issue:

    https://github.com/apache/nifi/pull/2145
  
    Added followings:
    
    - CLOB and NCLOB support to PutSQL
    - NCLOB support to ExecuteSQL
    
    Confirmed it can insert and select CLOB and NCLOB columns. For NCLOB, I've tested Japanese characters are inserted and retrieved successfully.
    
    A template is available here in Gist:
    https://gist.github.com/ijokarumawak/451085b01349c7e6e83bcc42182ecffc
    
    ```
    CREATE TABLE clob_test (
      i INT not null,
      c CLOB,
      nc NCLOB,
      CONSTRAINT clob_test_pk PRIMARY KEY (i)
    );
    ```


---