[
https://issues.apache.org/jira/browse/NIFI-3610?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Pierre Villard resolved NIFI-3610.
----------------------------------
Resolution: Feedback Received
Apache NiFi 1.x is no longer maintained and no new release is planned on the
1.x release line. Marking as resolved as part of a cleanup operation. Please
open a new one with an updated description if this is still relevant for NiFi
2.x.
> 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
> Priority: Major
>
> 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
(v8.20.10#820010)
