Re: NIFI - PUTSQL - sql.args.1.type

[Peter Turcsanyi]

If you navigate to Constant Field Values

in
the javadoc, you can see the integer constants.

On Tue, Sep 24, 2019 at 6:10 AM KhajaAsmath Mohammed <
mdkhajaasm...@gmail.com> wrote:

> This link doesn’t have any value to integer or other types.  It has
> comparison of data types between sql and java.
>
> Sent from my iPhone
>
> On Sep 23, 2019, at 8:20 PM, Juan Pablo Gardella <
> gardellajuanpa...@gmail.com> wrote:
>
> The values of the constants defined at
> https://docs.oracle.com/javase/8/docs/api/java/sql/Types.html
>
> On Mon, Sep 23, 2019, 8:10 PM Wesley C. Dias de Oliveira <
> wcdolive...@gmail.com> wrote:
>
>> Hi, KhajaAsmath.
>>
>> I've search it too but found nothing.
>>
>> I think it's more easy to observe the type based on your query. "mapping"
>> the arguments with the query fields.
>>
>> Em seg, 23 de set de 2019 às 20:02, KhajaAsmath Mohammed <
>> mdkhajaasm...@gmail.com> escreveu:
>>
>>> Hi,
>>>
>>> I have existing flow and trying to understand what is sql.args.1.type ?
>>>
>>> sql.args.1.type =11
>>> sql.args.1.type=13
>>>
>>> I understood that they are matched to column data type for
>>> sql.args.1.value.
>>>
>>> what is data type for 11 and 13 ? May I know what are all the options
>>> availabe for String, Integer, double ,date etc
>>>
>>> Thanks,
>>> Asmath
>>>
>>
>>
>> --
>> Grato,
>> Wesley C. Dias de Oliveira.
>>
>> Linux User nº 576838.
>>
>

Re: NIFI - PUTSQL - sql.args.1.type

[KhajaAsmath Mohammed]

This link doesn’t have any value to integer or other types.  It has comparison 
of data types between sql and java.  

Sent from my iPhone

> On Sep 23, 2019, at 8:20 PM, Juan Pablo Gardella 
>  wrote:
> 
> The values of the constants defined at 
> https://docs.oracle.com/javase/8/docs/api/java/sql/Types.html
> 
>> On Mon, Sep 23, 2019, 8:10 PM Wesley C. Dias de Oliveira 
>>  wrote:
>> Hi, KhajaAsmath.
>> 
>> I've search it too but found nothing.
>> 
>> I think it's more easy to observe the type based on your query. "mapping" 
>> the arguments with the query fields.
>> 
>>> Em seg, 23 de set de 2019 às 20:02, KhajaAsmath Mohammed 
>>>  escreveu:
>>> Hi,
>>> 
>>> I have existing flow and trying to understand what is sql.args.1.type ?
>>> 
>>> sql.args.1.type =11
>>> sql.args.1.type=13
>>> 
>>> I understood that they are matched to column data type for sql.args.1.value.
>>> 
>>> what is data type for 11 and 13 ? May I know what are all the options 
>>> availabe for String, Integer, double ,date etc
>>> 
>>> Thanks,
>>> Asmath 
>> 
>> 
>> -- 
>> Grato,
>> Wesley C. Dias de Oliveira.
>> 
>> Linux User nº 576838.

Re: NIFI - PUTSQL - sql.args.1.type

[Juan Pablo Gardella]

The values of the constants defined at
https://docs.oracle.com/javase/8/docs/api/java/sql/Types.html

On Mon, Sep 23, 2019, 8:10 PM Wesley C. Dias de Oliveira <
wcdolive...@gmail.com> wrote:

> Hi, KhajaAsmath.
>
> I've search it too but found nothing.
>
> I think it's more easy to observe the type based on your query. "mapping"
> the arguments with the query fields.
>
> Em seg, 23 de set de 2019 às 20:02, KhajaAsmath Mohammed <
> mdkhajaasm...@gmail.com> escreveu:
>
>> Hi,
>>
>> I have existing flow and trying to understand what is sql.args.1.type ?
>>
>> sql.args.1.type =11
>> sql.args.1.type=13
>>
>> I understood that they are matched to column data type for
>> sql.args.1.value.
>>
>> what is data type for 11 and 13 ? May I know what are all the options
>> availabe for String, Integer, double ,date etc
>>
>> Thanks,
>> Asmath
>>
>
>
> --
> Grato,
> Wesley C. Dias de Oliveira.
>
> Linux User nº 576838.
>

Re: NIFI - PUTSQL - sql.args.1.type

[Wesley C. Dias de Oliveira]

Hi, KhajaAsmath.

I've search it too but found nothing.

I think it's more easy to observe the type based on your query. "mapping"
the arguments with the query fields.

Em seg, 23 de set de 2019 às 20:02, KhajaAsmath Mohammed <
mdkhajaasm...@gmail.com> escreveu:

> Hi,
>
> I have existing flow and trying to understand what is sql.args.1.type ?
>
> sql.args.1.type =11
> sql.args.1.type=13
>
> I understood that they are matched to column data type for
> sql.args.1.value.
>
> what is data type for 11 and 13 ? May I know what are all the options
> availabe for String, Integer, double ,date etc
>
> Thanks,
> Asmath
>


-- 
Grato,
Wesley C. Dias de Oliveira.

Linux User nº 576838.

NIFI - PUTSQL - sql.args.1.type

[KhajaAsmath Mohammed]

Hi,

I have existing flow and trying to understand what is sql.args.1.type ?

sql.args.1.type =11
sql.args.1.type=13

I understood that they are matched to column data type for sql.args.1.value.

what is data type for 11 and 13 ? May I know what are all the options
availabe for String, Integer, double ,date etc

Thanks,
Asmath