[
https://issues.apache.org/jira/browse/NIFI-1241?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15036931#comment-15036931
]
Oleg Zhurakousky commented on NIFI-1241:
----------------------------------------
Ok, I was able to confirm that _setObject(..)_ on Postgres works as expected
with or without explicitly setting precision.
What I did get though when trying to execute the flow [~bende] shared is
{code}
Cannot update database for
StandardFlowFileRecord[uuid=c6d94e7b-a525-4e4f-bd4a-a3b7d460adb8,claim=StandardContentClaim
[resourceClaim=StandardResourceClaim[id=1449101389426-1, container=default,
section=1], offset=930, length=82],offset=0,name=1449101489464082000,size=82]
due to java.sql.SQLException: The 'sql.args.3.value' attribute has a value of
'12345' and a type of '2' but this is not a known data type; routing to
failure: java.sql.SQLException: The 'sql.args.3.value' attribute has a value of
'12345' and a type of '2' but this is not a known data type
{code}
That is with old code. Now building with _setObject(..)_. Stay tuned
> PutSQL does not support Boolean, Numeric, or Decimal data types
> ---------------------------------------------------------------
>
> Key: NIFI-1241
> URL: https://issues.apache.org/jira/browse/NIFI-1241
> Project: Apache NiFi
> Issue Type: Bug
> Components: Extensions
> Reporter: Mark Payne
> Assignee: Mark Payne
> Fix For: 0.4.0
>
> Attachments:
> 0001-NIFI-1241-Incorporate-Boolean-Numeric-and-Decimal-da.patch
>
>
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
