[jira] [Commented] (NIFI-3610) PutSql truncates data after 80 characters

["Matt Burgess (JIRA)" <ji...@apache.org>]

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

Matt Burgess commented on NIFI-3610:
------------------------------------

[~uwegeercken] did you ever get a chance to try this out?

> PutSql truncates data after 80 characters
> -----------------------------------------
>
>                 Key: NIFI-3610
>                 URL: https://issues.apache.org/jira/browse/NIFI-3610
>             Project: Apache NiFi
>          Issue Type: Bug
>          Components: Extensions
>    Affects Versions: 1.1.1
>         Environment: Fedora 25
>            Reporter: Uwe Geercken
>
> I have a ConvertJsonToSQL processor with following attribute:
> sql.args.4.value
> Type: flights, Station: hel, Month offset: -1, Environment: dev hello uwe what are you doing here
> the sql.args.4.type is: -1 (LONGVARCHAR)
> This processor is connected to a PutSQL processor. The same attribute looks like this:
> sql.args.4.value
> Type: flights, Station: hel, Month offset: -1, Environment: dev hello uwe what a
> The data is truncated after 80 characters and arrives like this in the database. I have checked the database - it allows up to 255 characters.
> The insert query from PutSQL - just for the completeness - is: 
> INSERT INTO process_monitoring (process_name, process_name_monitoring, last_runtime_automatic, parameters) VALUES (?, ?, ?, ?). And the record does get inserted - but column "parameters" is truncated to 80 characters.



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)