[jira] [Comment Edited] (NIFI-1241) PutSQL does not support Boolean, Numeric, or Decimal data types

["Oleg Zhurakousky (JIRA)" <ji...@apache.org>]

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

Oleg Zhurakousky edited comment on NIFI-1241 at 12/2/15 9:52 PM:
-----------------------------------------------------------------

Have we considered using _setObject(..)_ and eliminate the switch/case all together? Those methods are primarily for convenience in certain situations, but not in ours.
Here is the related javadoc:
*The JDBC specification specifies a standard mapping from Java Object types to SQL types. The given argument will be converted to the corresponding SQL type before being sent to the database.*

The added benefit is that we don't have to worry about specific vendor mappings and interpretations and let the driver (provided by the vendor) handle it.


was (Author: ozhurakousky):
Have we considered using _setObject(..)_ and eliminate the switch/case all together? Those methods are primarily for convenience in certain situations, but not in ours.
Here is the related javadoc:
*The JDBC specification specifies a standard mapping from Java Object types to SQL types. The given argument will be converted to the corresponding SQL type before being sent to the database.*

> 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)